Oracle GoldenGate Reviews & Insights

Score8.7 out of 10

221 Reviews and Ratings

Community insights

TrustRadius Insights for Oracle GoldenGate are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Real-time Data Replication Capabilities: Users have praised Oracle GoldenGate for its real-time data replication capabilities, allowing immediate access to data without additional processes. This feature ensures that users can work with the most up-to-date information at all times.

Seamless Modification of Data: Some reviewers have highlighted the time-saving feature of modifying data during transit with Oracle GoldenGate, especially beneficial for making seamless changes to large datasets before synchronization. This functionality streamlines the process of data manipulation and enhances efficiency in handling extensive amounts of information.

Flexibility in Data Replication: Customers value the product's support for multiple data sources beyond just Oracle databases, appreciating its flexibility in handling various replication scenarios. The ability to replicate data from diverse sources contributes to a more comprehensive approach to managing information across different platforms.

Reviews

41 Reviews

GoldenGate Bridges the gaps between Production and BCP

Rating: 10 out of 10

Incentivized

May 18, 2021

Use Cases and Deployment Scope

Oracle GoldenGate is used as part of our business continuity plan. We use it to replicate in near realtime, transactions from the primary database to the BCP copy of the database. We also use it to maintain a reporting instance of our transactional database so we can offload read-only type queries in order to minimize performance impacts on the transactional database. We are experimenting with using GoldenGate to perform some transformations for us so that we can create data marts for various teams within the organization. That is still in the POC stage.

Pros

Replication
Business Continuity
Query offloading

Cons

Requires a specialized skillset

Likelihood to Recommend

I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.

Gene Baker

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

Vetted Review

3 years of experience

GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity

Rating: 8 out of 10

Incentivized

December 13, 2020

Use Cases and Deployment Scope

GoldenGate (GG) is being used by the utility company I work for in various areas.

Data Analytics is the main use of GG at the moment. Normally, the sheer level of database hits required by our daily Business Intelligence reports would place a heavy burden on the disk groups in our core ASM; however, with GG, we are able to seamlessly replicate that data in real-time into a separate database using separate resources. By doing this, we are able to alleviate potential bandwidth issues posed by our BI group’s database querying. It should be noted that GG does not require all tables to be replicated: we only replicate under 100 of the thousands of tables in the main databases. Our GG database is not normalized, so we are essentially combining disparate databases into one, which has its advantages and disadvantages.

Another use we currently have for GoldenGate is on a large project level. As part of a data conversion effort, we are using GoldenGate to replicate data into a separate database in real-time. This will allow us to save 12+ hours during our conversion, as well will not need to execute an RMAN backup in order to move data into our target database. In other words, we are directly replicating data into our target database, so right when we are ready to switch servers/databases for the go-live of our project, we will be ready to immediately start to convert data.

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.

Likelihood to Recommend

Oracle [GoldenGate] is well suited for data replication where real-time results are important, such as data reporting. There is potential to have the users query the replicated database, which can have separate resources set up to be compressed or using lower performing or cheaper resources.

As mentioned, columns with LOBs can become a headache, as they will need to be synchronized in their own group many times. Tables containing data in CHAR, VARCHAR, NUMBER, DATE, or other non-LOB columns, however, are able to be replicated quite seamlessly.

[Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.

Chris Oros

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

Vetted Review

2 years of experience

OGG - always in-sync

Rating: 8 out of 10

Incentivized

December 8, 2020

Use Cases and Deployment Scope

Our company in EMEA region has two data centers, working in the Active/Passive(standing by) mode. We use Oracle GoldenGate to "clone" the live data transactions from the master database (which resides in the currently active data center) to the standing-by database (which is in the limited read-only mode, and resides in our passive data center). If the active DC is down and DR is required, the standing-by database in the passive DC will be promoted to the master one which can take R/W transactions, and the OGG will reverse the uni-direction data copy. This pattern is applied on all business critical IT application's DB instances.

Pros

As the product under the Oracle umbrella, it perfectly and natively supports the Oracle database very well.
For the standard scenario and use cases, the configuration is straight-forward (in our case uni-direction copy from source to target).
It is robust and the performance meets our SLA, even for a large amount of data volume.
The error report is not only detailed but hits the right points, so trouble shooting is easy.

Cons

The metrics UI is another product that should be purchased separately, with high price, we use open source Grafana as a replacement.
Documentation can be improved. Sometimes [it is] not so easy to find the correct information quickly.

Likelihood to Recommend

Oracle GoldenGate is very handy to deal with Data Center to Data Center DB copy (near real time), uni-directional or bi-directional, it is also suitable to copy the data from production environment to the testing/dev environments. If you also have to deal with the problem of decoupling the reporting purposed read from the busy transaction-intensive operational DB instance, OGG will be also a good candidate. However Oracle GoldenGate is like the other Oracle products, quite expensive, so the small/medium company may not be able to afford the cost.

Verified User

Strategist in Information Technology (10,001+ employees)

Vetted Review

4 years of experience

Replicate as much as you can as frequent as you can

Rating: 8 out of 10

Incentivized

December 7, 2020

Use Cases and Deployment Scope

Currently [Oracle] GoldenGate is being used to replicate a backup database for disaster recovery and also integrating different data sources to a single database.

Pros

Documentation is easy to follow
Downtime seems very minimal
Able replicate in real-time

Cons

Expensive, considering we were going to use Active Data Guard.
A lot of memory is being used.
No UI

Likelihood to Recommend

If you need to integrate many data sources together, [Oracle] GoldenGate is well suited to easily do that while maintaining data integrity.

Verified User

Team Lead in Corporate (10,001+ employees)

Vetted Review

1 year of experience

Oracle Golden Gate is efficient and high performance

Rating: 10 out of 10

Incentivized

December 5, 2020

Use Cases and Deployment Scope

Oracle GoldenGate is being used by the departments as required and as needed. Especially we used for migration purpose. We are migrating the databases from on-premises to Cloud. The real problem is to complete the migration with zero-downtime. We need a revert plan (rollback strategy) when it fails. [Oracle] GoldenGate helped a lot in completing this migration task with Zero-downtime. [Oracle GoldenGate] is real-time data capture, continuous delivery of transaction data across different sources.

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

Likelihood to Recommend

when you want to migrate databases with Zero-down migration (on-prem to on-prem/ on-prem to cloud/cloud to cloud / cloud to on-prem)
when you want to replicate the entire database between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
when you want to replicate the specific tables between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
when you want to replicate the data set between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
when you want to create Read-Only databases
when you want to create two master database - using bidirectional databases

Jacob Biguvu

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

Vetted Review

7 years of experience

An OK tool for data replication--not great but not completely terrible

Rating: 7 out of 10

Incentivized

December 3, 2020

Use Cases and Deployment Scope

Oracle GoldenGate is used in a traditional manner for homogeneous data replication between production and non-production environments. This allows the different environments to be utilized for different purposes with the same source data. Some environments are for real-time data analysis while others are backend reporting and analysis.
Oracle GoldenGate allows us to split highly responsive, mission critical systems from lower environments while retaining clean copies of source data.

Pros

Integrates with Oracle databases and Oracle database servers (particularly exadata - engineered systems)
Easy to define source and destination data attributes and configuration
Robust error reporting

Cons

More integration with traditional Oracle products such as SQL*plus
GUI
More transparent integration with OEM
More standard error reporting similar to traditional Oracle products

Likelihood to Recommend

Oracle database data replication is very straightforward but still a bit too complicated to configure (versus an out-of-the-box, easy-to-configure data replication tool). Oracle GoldenGate is advertised as being able to replicate data between different database products (vendors) as well as different versions of the space database product (so Oracle 11g replicated to Oracle 12c). Given that it's complicated to configure for Oracle database to Oracle database (same version), I'm sure any of the other advertised configurations are more complicated. These complexities make Oracle GoldenGate a difficult sell internally. It needs to be more straightforward and out of the box to configure and utilize.

Verified User

Professional in Information Technology (1001-5000 employees)

Vetted Review

5 years of experience

GoldenGate is best for real-time data needs.

Rating: 10 out of 10

Incentivized

December 4, 2019

Use Cases and Deployment Scope

It's used by our Computer Services Department to create reporting databases as well as for DR. The replication is unidirectional and replicates data in four non-production environments. This enables us to perform long-running queries without affecting the performance of our production systems. We have a lot of clients using it. It can migrate data between databases in realtime.

Pros

Flexibility to migrate data.
Fast transactions between source and target databases .
Easy to analyze problems when occur.
Good for disaster recovery and data protection database.

Cons

Oracle GoldenGate Studio is expensive, and you can use Grafana instead.
Character set problems when migrating database.

Likelihood to Recommend

If you want to migrate databases quickly or put some schemas from the production, quality, or testing databases, you can use GoldenGate (but it is expensive). I only use it for Oracle Source and Oracle Target databases.

João Leal

Oracle Services Engineer in Information Technology at TAP (10,001+ employees)

Vetted Review

3 years of experience

The Golden Gate to Success!

Rating: 8 out of 10

Incentivized

October 7, 2019

Use Cases and Deployment Scope

Oracle GoldenGate is being used by our core software development team. We are using it as a real-time data replication solution to achieve high availability/disaster recovery for our data, to prepare a read-replica database to offload query-based requests, and to perform real-time business intelligence related operations on our synced data.

Pros

No Downtime during System Migration. Replicating data onto other servers in preparation for a system migration does not result in any downtime.
Initial setup of Oracle GoldenGate is easy and straightforward. Instructions are precise and simple to follow.
Thorough and Insightful Documentation. All troubleshooting and tuning issues are well-known by the community, and hence are well-documented online.

Cons

Lack of Simple UI for Non-Technical Users. It would be nice to have an option to toggle simpler, and less advanced options to make it easier for non-technical users to understand what Oracle GoldenGate is.
Lack of Variety of Performance Metrics. Would prefer more detailed performance metrics to be offered out-of-the-box.
Some Features Won't Always Run as Expected. We have sometimes faced issues when features don't run as they are used to. They will be working at times, but there is the occasional failure in streaming.

Likelihood to Recommend

Oracle GoldenGate is well-suited for Enterprise-level companies which require mission-critical security and performance along with their real-time data replication needs. Oracle GoldenGate integrates well with other Oracle products as well such as: Oracle Fusion Middleware, Oracle Veridata, Oracle XStream, and Oracle Active Guard. If you plan to use Oracle's products with your data replication workflow, Oracle GoldenGate is the way to go.

Verified User

Engineer in Information Technology (51-200 employees)

Vetted Review

2 years of experience

GG is great for what it is, but be aware of its limitations

Rating: 6 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

We use GoldenGate to sync up data from our customer and care system to Oracle Analytics Database

Pros

When it works, it works great

Cons

Whenever we have to do a data subset from prod to lower environments its almost impossible for GG to find its checkpoint... we had lots of difficulty with restarting GG process after the refresh.

Likelihood to Recommend

The product works well in normal circumstances but fails to deliver when some flexablity is required. For example when syncing source to target it works really well, but when you reverse the process the system can be a bit buggy.

Serge Trikur

Sr System Admin in Information Technology at PGE (1001-5000 employees)

Vetted Review

2 years of experience

Oracle Golden Gate implementation at courier services

Rating: 8 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

We use it for our core system to support our main database for courier services. The core system is used by all of the operations and sales teams, as well as the Board of Directors. All of the transactions should be backed up and maintained in our backup servers as well as our disaster recovery. We use GoldenGate to replicate our database.

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.

Likelihood to Recommend

GoldenGate is the best software to replicate main databases for backup and for disaster recovery. It will not be suitable for interconnected systems that are based on messaging.

budhi setyawan

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

Vetted Review

5 years of experience

Loading Reviews List....

GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity

Rating: 8 out of 10

Incentivized

December 13, 2020

Use Cases and Deployment Scope

GoldenGate (GG) is being used by the utility company I work for in various areas.

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.

Likelihood to Recommend

[Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.

Chris Oros

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

Vetted Review

2 years of experience