Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases. 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 1 of 172 Oracle GoldenGate ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-1 of 1)

Do you use this product? Write a 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