Oracle GoldenGate

Score8.7 out of 10

221 Reviews and Ratings

What is Oracle GoldenGate?

Oracle Cloud Infrastructure (OCI) GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis.

Categories & Use Cases

Gene Baker View profile

Vice President, Chief Architect, Development Manager and Software Engineer in Information Technology at WySTAR Global Retirement Solutions, a Wells Fargo Company (10,001+ employees employees)

Pros

Replication
Business Continuity
Query offloading

Cons

Requires a specialized skillset

Return on Investment

We just passed our BCP simulation with flying colors
Positive impact as we have [been] able to maintain high performance transactions while offloading reports and still being able to provide the reports in a timely manner to clients

Alternatives Considered

SAP Replication Server

Chris Oros

IT Analyst in Information Technology at Duquesne Light Co. (1001-5000 employees employees)

Pros

Replicates data without "missing" items. This is key, as there was initial concern that with the amount of tables and columns involved, certain items were bound to be "missed", though we have not seen this (outside of an anomalous server crash incident that wasn't due to GG).
Replicates data in real-time. Proof of concept for GG was intuitive for end users, as the data is immediately available. There are no "jobs" or "interfaces" that need to be run: the data is immediately available on the target database for viewing
GG is able to modify data "in transit", which can save loads of time if you were to need to instead modify large amounts of data after it is synchronized to the target database. As one would expect, this is seamless with low complexity modification, by can become untenable with larger blocks of data (e.g. CLOBs).

Cons

GG can sometimes lag behind in synching large objects (i.e. CLOBs and BLOBs) on tables, which is odd because we are using GG on an Oracle database with an Oracle software suite. It's definitely possible to use GG on non-LOB columns, and we do, but it is best used for non-LOB columns, just based on personal experience.
When using GG, it is key to separate the replicat groups into manageable sizes. This can be somewhat burdensome, as maintenance will increase with each new replicat group. If tables are large enough, they need to essentially be their own group.
Sometimes, replicat groups need to be grouped by parent and child (if using in a normalized db). This again increases maintenance due to more groups existing. This will be especially true for large tables that are partitioned with foreign key constraints on child tables.

Return on Investment

On a project level, by allowing us to begin our data conversion process 12 hours earlier, we are able to save in off-time losses and increase customer satisfaction, as we will be on line a whole half day earlier.
By being able to replicate data to cheaper performing resources, we are able to save money by not having to duplicate the costs of our main resources.
GG knowledge is somewhat specialized, so it does require a human resource(s) to be employed that knows how to maintain it. This is not a full time job, but it is absolutely necessary.

Jacob Biguvu View profile

Cloud DBA/Developer (Cloud and On-Premises) in Information Technology at Capital One, Walmart (10,001+ employees employees)

Pros

OGG can be used and integrated with heterogeneous databases as well as homogeneous databases.
OGG is easy setup as well as easy learning curve
OGG supports large databases
OGG support many uses cases (topologies) such as unidirectional replication, bidirectional, peer-to-peer, Broadcast, Cascading replication etc.
OGG can be used not only for CDC (change capture), can be used to full load

Cons

Expensive
Require resources such as OGG script developer and SME

Return on Investment

OGG can be used for the database migration
OGG can be used for database replication
OGG can be used for data integration
OGG is expensive (negative)
OGG is cost due to hire SME or expert

Alternatives Considered

SharePlex, Microsoft SQL Server and Qlik Replicate

budhi setyawan

consultant in Corporate at TIKI JNE (5001-10,000 employees employees)

Pros

Oracle GoldenGate has been able to replicate all of our data in different servers and locations.
It also supports large databases
It supports a high volume of daily transactions of our sales.

Cons

In certain cases, we consider how well GoldenGate is able to help us interconnect our main database directly to our backup system (we use actifio for it).
We have some difficulties to cut-off our size of main database, so maybe Oracle GoldenGate could make it easier by providing a function to shrink our data safely.
We also interconnected with our partners to share some data, specific and limited fields only, through third party services, using messaging system (ISO 8583, XML and JSON). It would be great if GoldenGate also provided such a function.

Return on Investment

It make it easier to manage and back up our main database
GoldenGate helps make it faster in terms of solving technical problems related to preparing inter-department reports.
It helps us be more efficient in terms of using manpower to handle our database

Alternatives Considered

Oracle Database Cloud Service

Mohamad habba

Technology channels manager in Information Technology at Magrabi Retails (501-1000 employees employees)

Pros

Initiating integration and configuring source and target is easy.
Easy integration with different types of DB.
Availability to synchronize specific tables/DB schemas.

Cons

No clear documentation for some points like sequence synchronization.

Return on Investment

Product cost is high, however, we can see it is an excellent product.

Informatica Cloud Data Integration

Azure Data Factory

AWS Database Migration Service

Oracle GoldenGate

What is Oracle GoldenGate?

Categories & Use Cases

Reviews

GoldenGate Bridges the gaps between Production and BCP

Pros

Cons

Return on Investment

Alternatives Considered

GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity

Pros

Cons

Return on Investment