Oracle GoldenGate Reviews & Product Details

Oracle Golden gate has eased so many complication that an employer faces, be it in relation with payroll, absences or anything, it helps in making the transactions easier using the technology in its best way. Review collected by and hosted on G2.com.

I honestly have nothing to dislike about Oracle GoldenGate but it surely have some negative points like not everything is answered on Oracle customer connect, oracle needs to make it more interactive so that all the queries are answered. Review collected by and hosted on G2.com.

Oracle Goldengate is an replication tool. By using oracle goldengate database data can be replicated to other systems. Goldengate has to be configured between system for replication and we have two ways on the . Most widly used relocation mechanism is theunidirectional mechanism where the databse data will bereplicated to another databse for different causes like reporting purpose, duplication of databse, backup mechanism and so on. Mostly widley used cause of Goldengate is reporting purpose. The architecture of the goldengate mechanism is very simple and it has some 4 main components. Review collected by and hosted on G2.com.

Oracle goldengate is not very much user friendly in configuration and this can be installed on top of unix operating system so the monitoring part needs to be configured in unix systesm. The monitoring can be also configured in database level using the default views which are available in the goldengate installation but that needs to be configured. Also golden Gate replication is a licensed product so please keep in mind about the cost involved in configuring goldengate as well. Review collected by and hosted on G2.com.

Oracle Golden Gate is an excellent tool which can be used to automate the replicate between instance. There are two ways of replication is available in Golden Gate. One is uni directional and the second one is bi directional. Uni directional goldengate is used widly in reporting application where the production data is replicated to the reporting application and the reports can run over the reorting database which will avoid performance issues on the production system. Also this goldengate setup act as a both the way replication system which is called bi directional which is very much essential in an environment where data is avcested in multiple system and updates are also happening in multiple system and there should be an requirement that data should be synced between systems Review collected by and hosted on G2.com.

It is more complex to resolve if there is an lag issues between systems. Also if there is any network failure then the replication will get affected and the reporting database will provide the old data which has been captured before network failure from the prod database. Also the troubshootimg needs much knowledge about the Oracle components and with the help of the vendor support the troubleshloting can be dont for comples issues. Where sync is not happening for a long time. Else we need to do a full load which will again consume lot of time and effort. Review collected by and hosted on G2.com.

very powerful and flexible software that allows data movement between a lot of sources and tagets Review collected by and hosted on G2.com.

can become very complex and create data issues if not used correctly Review collected by and hosted on G2.com.

heavyweight enterprise software great for real-time and no-downtime migrations Review collected by and hosted on G2.com.

Technically complicated, difficult to control during in-play migrations, for monitoring requires further additional licensing and cost with Oracle Enterprise Manager plug-in. Need to employ heavyweight technical DBA's - Only support in Oracle Cloud not AWS or Azure Review collected by and hosted on G2.com.

Its robust and powerful and can do transformations on the go. It can be monitored with OEM too so we can create tickets too Review collected by and hosted on G2.com.

Its robust and powerful and can do transformations on the go. It can be monitored with OEM too so we can create tickets too Review collected by and hosted on G2.com.

We like the replication of the database. It works better then dataguard Review collected by and hosted on G2.com.

It is too expensive. We don't deploy Golden gate as much as data guard Review collected by and hosted on G2.com.

Very Easy to use. Goldengate can be used to minimize downtime where we need to move large amount of database about 100TB between Solaris & Linux Review collected by and hosted on G2.com.

There should be easy way to do whole database copy and hide all complexity behind the scene e.g. migrate database from Solaris to Linux Review collected by and hosted on G2.com.

It is a very handy product thats very useful to stream data out of RDBMS databases Review collected by and hosted on G2.com.

Its majorly command line oriented. It will be great to have a UI for managing it Review collected by and hosted on G2.com.

It has helped us with creating reporting environments. Review collected by and hosted on G2.com.

We have had some issues with bugs in the past. Review collected by and hosted on G2.com.