Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases. with 99.999 uptimeWe 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.,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.,10,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.,Not a member of any user groups,SharePlex,Oracle Enterprise Manager Cloud Control, Oracle Exadata Database Machine, Toad for Oracle,100,100,High Availability Migrations and Upgrades without downtime Achieve Active Active requirement,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.,Use Golden Gate micro services for easy management.,10,No,Price Product Features Prior Experience with the Product,I won't change my decision to move away from Golden Gate.,Implemented in-house,No,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,9,Yes,10,Yes,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.,Golden Gate install and setup troubleshooting and checking status of the processes logdump utility.,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.,9MyCentsonGoldWe are using this application to replicate data from one data center to other data center. And it's very accurate and it's solved our data issues during the down time the replication helped not loosing of business and with little impact to customer for check out and creating profiles,Well organized and greater data integration Response Time(no latency) able to sustain the load during the process Because of Golden Gate our business able to deliver the continuance and high availability of the application Less hassles of maintenance,Little more flexibility and should be more robustness Need improvement on session management Replication takes more time - you need a better approach with less time,9,Cost cutting More reliability Able to handle another data center without any hiccups,Not a member of any user groups,IBM InfoSphere Data Replication,Data Management for IMS and DB2 on z/OS,,10,Copying the data from one data center to other data center Maintain seam less data in both centers No down time,As we noticed our database went during peak season couldn't able to continue to keep the orders processed and availability to customers,Continuous use for more data centers,9,Not Sure,Product Features Product Usability Product Reputation Prior Experience with the Product,There won't be much changes,Implemented in-house,No,Change management was minimal,Little implementation process,9,8,Haven't faced the situation,column-conversion functions,Transforming Data,Yes,9Oracle GoldenGate, it's not just for Oracle DBs anymore!At a previous job, bi-directional Oracle GoldenGate replication was used to support a highly available application model. It was used across the whole IT DBA organization. At my current position Oracle GoldenGate is being used in a uni-directional manner to replicate data from 10 different application databases to an ERP platform that is used for our enterprise reporting needs, this also helps in offloading the reporting from the application databases.,Replication. Oracle GoldenGate's strength is it's main feature, replication. GoldenGate is able to quickly replicate transactions in a method that maintains transactional integrity and give you a like to like replica on the other side. Transformation. Oracle GoldenGate is able to do some data transformation as it replicates, this is very key if you need your data to appear a certain way, especially important in Reporting. Recoverability. Oracle GoldenGate has many fail safes to ensure data is not lost, some examples of this are trail files its own system of recording changes that works with the DB SCN. Multiple Data Sources/Targets. Oracle GoldenGate is not limited to just Oracle Databases as a target it can support most of the popular databases in the industry today such as SQL Server, MySQL, DB2 and more.,Setting Up Oracle GoldenGate as HA in an Oracle RAC environment. While this is possible to do and there is documentation out there, I've found that specific Oracle GoldenGate and Oracle RAC experience is needed in order to make this happen. That level of experience does not exist everywhere. Monitoring Oracle GoldenGate. Currently there are two main options for monitoring Oracle GoldenGate, the first, GoldenGate Monitor, does not scale well as it becomes very non-performant when you have more than 10-15 GoldenGate Managers reporting to it, the second, Oracle Enterprise Manager, while getting better still requires a lot of manual configuration to have Oracle GoldenGate talk to the OEM agent. While this has got a lot better with 12c GoldenGate, I still feel that there is room to improve here. Unable to replicate certain Data Types. Again, less of an issue in 12c Oracle GoldenGate, but there are still some Data Types that Oracle GoldenGate is unable to replicate.,9,Increased Availability. Through using Oracle GoldenGate we were able to completely eliminate customer experienced downtime when applying patches and upgrades to our databases. This led to a increase in our availability numbers company wide for database. The key though was architecting our applications to allow them to work in a multi-site fashion that allowed us to leverage Oracle GoldenGate for this. Being able to move data/processes off of the main application databases to put less strain on those resources. Being able to replicate data from 11 Application DBs to one ERP DB running on Exadata has increased performance on the application databases as they no longer needed to have a report run against them. It also allowed us to create new reports for our customers which has many times over paid for our investment in Oracle GoldenGate.,Oracle Streams,50,10,Enterprise Reporting. Auditing. Replication,Auditing of client data.,Replicating data between DB platforms. Bi-Directional Replication to support highly available application architecture.,10,Yes,Product Features Product Usability Analyst Reports,I don't know that we would want to change in our selection process, I believe what we looked at and what we tested made sense. I think if we had known about the monitoring challenges ahead of time we could have maybe worked with the vendor to understand the best practices around that a little better from the get go and that would have helped some of our operational challenges around Oracle GoldenGate.,Vendor implemented,Yes,Change management was minimal,How to Monitor at Scale. This was before the OEM Oracle Golden Gate Plugin, so Oracle GoldenGate Monitor was our only alertnative and it became very slow when we started getting a larger Oracle GoldenGate footprint. Configuration. Some of our earliest implementations were some of our most cumbersome, in hindsight it would have been better to begin with easier implementations and work our way up there, but unfortunately the biggest need from the business was in that most challenging implementation. Knowledge distribution. The SMEs for Oracle GoldenGate were very busy and were not able to give the time necessary to properly train the entire team on Oracle GoldenGate, this let to some siloing until the whole team could be brought up to speed through Oracle University Training.,9,Online training In-person training Self-taught,10,10,While you can learn without training, I would not recommend it. The Oracle documentation can only get you so far. If your implementation is very basic you may get away with it, but ultimately it will come back to bite you. I strongly advise getting Oracle GoldenGate Training if at all possible.,9,If installing Oracle GoldenGate on a RAC System, use RAC Services to make it highly available!!!,No - there is no facility to customize the interface,No - we have not done any custom code,No,9,No,Oracle has sent us their best Oracle GoldenGate consultant on multiple occasions, Valerie Bedard. She has been an absolute joy to work with and her Oracle GoldenGate knowledge is just amazing. She has been consulting on Oracle GoldenGate since before the company was acquired by Oracle. She knows the ins and outs of the product and her support has been invaluable in supporting Oracle GoldenGate at our organization.,Stopping/Starting extracts. Finding the lags.,Creating a replicat extract. Hooking Oracle GoldenGate in to enterprise level monitoring.,No,8,10,10,9,Oracle Data Integrator (ODI),SQL Server MongoDB,ETL tools,10,Make sure the integration is supported both from the Oracle GoldenGate side and the other vendor(s) in the integration.,10,10,We were able to include Oracle GoldenGate in to our UELA.,No,Yes,Integrated Replicat. Integrated Extract. Performance Boosts.,Additional Data Sources/Targets especially in the Big Data Space.,No,No
Oracle GoldenGate
172 Ratings
Score 8.4 out of 101
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Oracle GoldenGate Reviews

<a href='' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Oracle GoldenGate
172 Ratings
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Do you work for this company? Manage this listing

Show Filters 
Hide Filters 
Showing 3 of 172 Oracle GoldenGate ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-3 of 3)

Do you use this product? Write a Review
No photo available
November 07, 2018


Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

This helped our company continuous availability and not loosing orders and customer information
Read this authenticated review

Feature Scorecard Summary

Connect to traditional data sources (21)
Connecto to Big Data and NoSQL (12)
Simple transformations (18)
Complex transformations (17)
Data model creation (14)
Metadata management (13)
Business rules and workflow (14)
Collaboration (10)
Testing and debugging (17)
feature 1 (2)
Integration with data quality tools (15)
Integration with MDM tools (11)

About 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


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.

Categories:  Data Integration

Oracle GoldenGate Integrations

Oracle GoldenGate Competitors

Informatica Enterprise Data Integration, AWS Database Migration Service, Azure Data Factory


Has featureFree Trial Available?Yes
Does not have featureFree or Freemium Version Available?No
Does not have featurePremium Consulting/Integration Services Available?No
Entry-level set up fee?No

Oracle GoldenGate Support Options

 Free VersionPaid Version
Live Chat
Social Media
Video Tutorials / Webinar

Oracle GoldenGate Technical Details

Operating Systems: Unspecified
Mobile Application:No