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
View more demos
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 Integrations

Oracle GoldenGate Competitors

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-1 of 1)
Companies can't remove reviews or game the system. Here's why
November 09, 2018

GoldenGate with 99.999 uptime

Verified User
Team Lead in Information Technology
Financial Services Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope

We use Oracle GoldenGate to achieve high availability, perform upgrades, and for patching and data center drills.

We use Golden Gate in active active configuration.

It meets our SLA requirement of 99999.


Pros and Cons
  • Oracle GoldenGate provides the best HA solution. It gives us 99.999% availability in a year.
  • GoldenGate is very easy to install, set up and troubleshoot. The commands are fairly simple.
  • GoldenGate is a very lightweight tool. It performs auto CDR in active setups.
  • Tuning Golden Gate is fairly very simple.
  • Golden Gate is very fast in catching up the lag.
  • Where there are open transactions GoldenGate needs to auto-detect them.
  • GoldenGate should have dba views like Oracle Database.
  • Patching or upgrading GoldenGate is a bit complicated.
  • When extract or pump trail file sequence number is about to reach the max limit, we should get a warning or critical threshold alert.
  • When Integrated replicat is altered, it converts to classic replicat. We don't get any message that the replicat is running in classic mode. There should be some sort of alerting in the ggserrlog file.
Likelihood to Recommend
  • For real-time or tier 0 and tier 1 applications where 99.999% availability is needed GoldenGate is the best solution.
  • For tier 2 and above applications, Oracle Data Guard is a good choice.
Oracle GoldenGate Feature Ratings
Return on Investment
  • GoldenGate has saved us from penalties by providing 99.999% uptime.
  • DR drills are very fast due to active architecture using GoldenGate.
  • We need to pay for additionals licenses for GoldenGate but for Data Guard we don't have to pay for and additional license.
Alternatives Considered

Oracle Golden Gate is very user friendly product and very easy to install, setup and troubleshoot.

Quest SharePlex is bit complicated compared to Oracle Golden Gate and has less features.


Other Software Used
Users and Roles
100
Oracle Golden Gate is used for high availability. Golden Gate helps our application to fulfil the the active active requirement as well. We can do patching, upgrades or any maintenance tasks without any downtime due to Golden Gate.
Support Headcount Required
100
Oracle DBA, SQL Server DBA mostly use Golden Gate. Mostly DBA skills are needed to support Golden Gate.
Business Processes Supported
  • High Availability
  • Migrations and Upgrades without downtime
  • Achieve Active Active requirement
Innovative Uses
  • We use Hub and Spoke model of Golden Gate
  • We use Active active feature of golden Gate
  • We used Golden Gate for Sybase to Oracle Migration.
Future Planned Uses
  • Use Golden Gate micro services for easy management.
Likelihood to Renew
10
We are very Happy with the product and the support and it helps us achive our 99999 SLA.
Products Replaced
No
Key Differentiators
  • Price
  • Product Features
  • Prior Experience with the Product

Golden Gate is a very solid product with very less bugs. It's very user friendly and can be used in various Heteregenous environment.

The commands are very simple and very easy to troubleshoot.


Evaluation Lessons Learned
I won't change my decision to move away from Golden Gate.
Implementation Details / Implementation Partner
  • Implemented in-house
Implementation Phases
No
Implementation Issues
  • while impleming parallel classic replicat there was a manual error in specifying the range and that let to data out of sync.
  • data looping
  • out of sync data
Implementation Rating
9
We use the oracle golden gate documentation for implementation. All the steps are very well documented.
Premium Support
Yes
We are happy and satisfied with the premium support
Support Rating
10
Overall support for Golden Gate is very good. Whenever we have created an SR, We get solution for it pretty fast.
Bug Resolution
Yes
Exceptional Examples of Oracle GoldenGate Support
We had a case where we had to have end to end lag reduce from 10 seconds to 1 second and Golden Gate team provided us with a solution for it. This was very much needed for our active active and because of this we were able to achieve our goal.
Easy Tasks
  • Golden Gate install and setup
  • troubleshooting and checking status of the processes
  • logdump utility.
Difficult Tasks
  • golden Gate doesn't have compare and repair functionality and so if we have to sync two databases then it takes quite some time and effort to do it.
  • Setting up bidirectional replication.
  • Active Active setup.
Usability
9
As stated earlier Golden Gate is very user friendly and easy to use. Has some very good features that helps troubleshooting very easy.
Return to navigation