Skip to main content
TrustRadius
Oracle GoldenGate

Oracle GoldenGate

Overview

What is Oracle GoldenGate?

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

Read more
Recent Reviews

OGG - always in-sync

8 out of 10
December 08, 2020
Incentivized
Our company in EMEA region has two data centers, working in the Active/Passive(standing by) mode. We use Oracle GoldenGate to "clone" the …
Continue reading

Oracle GoldenGate Review

7 out of 10
September 17, 2019
Incentivized
GoldenGate is being used as a DR solution and as well as a method for replicating from a transactional to reporting DB. It is used across …
Continue reading

GoldenGate Rocks

10 out of 10
September 17, 2019
Incentivized
We use it to move data between databases to a dw for reporting purposes. We also use it to transform data as it moves, and we use it to …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing

Data Integration

$250.00

Cloud
Per License

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://cloud.oracle.com/en_US/goldenga…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

Oracle Goldengate demo

YouTube

Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_31st May

YouTube

2017 05 19 22 04 Oracle Goldengate Demo

YouTube

Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_14 June

YouTube

Oracle 12c Golgen Gate Essentials Training - DEMO

YouTube

Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux

YouTube
Return to navigation

Product Details

What is Oracle GoldenGate?

Oracle GoldenGate products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables:
-Real-time business intelligence and stream analytics for improved business insight
-Query offloading to maximize OLTP performance
-Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability

Documentation

Video Oracle GoldenGate Cloud Service - Get an overview of this cloud based real-time data integration and replication service that provides quick, easy, accurate and safe data movement to the cloud. https://youtu.be/liBgUwHgVew

Oracle GoldenGate Video

GoldenGate Cloud for real-time replication

Oracle GoldenGate Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Oracle GoldenGate Downloadables

Frequently Asked Questions

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

Azure Data Factory, AWS Database Migration Service, and Informatica Cloud Data Integration are common alternatives for Oracle GoldenGate.

Reviewers rate Oracle Implementation Satisfaction highest, with a score of 9.7.

The most common users of Oracle GoldenGate are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(221)

Attribute Ratings

Reviews

(1-25 of 41)
Companies can't remove reviews or game the system. Here's why
Gene Baker | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized

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.

December 08, 2020

OGG - always in-sync

Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Jacob Biguvu | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • 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
December 04, 2020

Oracle GoldenGate Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
GoldenGate helps us to keep a replica of the database consistent, in real time, which is used for reportage in read only mode, In this way we manage to reduce the load of the production database, redirecting all the generation of reports to the contingency site, leaving all the processing capacity available for the provision of services of the productive applications. We are also replicating data from a source database to a target database. GoldenGate works well for that purpose.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle GoldenGate is extremely useful for heterogenous replication and active-active replications.
I have been able to replicate data between Oracle and targets such as TeraData, JMS queue, TIBCO EMS, Kafka, Hbase and Cassandra very easily. GoldenGate is one of the best logical replication product available in the market today, and with the latest innovations, it is only getting better.

Though we were able to set it up, when the source is a DataWarehouse with a lot of large transactions and heavy redo generation in a short amount of time, GoldenGate is not the best product of choice.
September 16, 2019

Sr. Database Engineer

Anuj Kumar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Very well suited for Oracle database bi-directional replications. Excellent tool for dumping Oracle data to other sources like NoSQL, XML, HDFs etc. Setting up replication is easy and quick. Within no time we can start dumping data to other sources. Also CDR rules are easy to configure in active-active replication. It is very useful in case of zero downtime migration where DB size is huge, also we can utilize it in database upgrades.
September 16, 2019

GoldenGate Replication

Score 10 out of 10
Vetted Review
Verified User
Incentivized
GoldenGate is easy to integrate and manage with a low learning curve and administrative efforts. We had a platform requirement where we had to basically decide to go with an application that is supporting bidirectional replication or we do go through available tools in the market. Since we had some other available vendor who supports this feature we found the data quality validation a unique feature and went with this tool.
Return to navigation