Oracle GoldenGate Overview
Oracle GoldenGate is the #8 ranked solution in our list of top Data Integration Tools. It is most often compared to AWS Database Migration Service: Oracle GoldenGate vs AWS Database Migration Service
What is Oracle GoldenGate?Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.
Oracle GoldenGate is also known as GoldenGate.
Oracle GoldenGate Buyer's Guide
Download the Oracle GoldenGate Buyer's Guide including reviews and more. Updated: April 2021
Oracle GoldenGate CustomersJapan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
Oracle GoldenGate Video
Filter Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Showingreviews based on the current filters.
Jun 7, 2018
Transforms data in real-time from one database to many or from many to one
What is our primary use case?The primary usage of the product is to transform data from one database to another, for an application.
Pros and Cons
- "You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time."
- "It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."
What other advice do I have?I would recommend Oracle GoldenGate, of course.
Database Architect and Oracle ACE Director at Chandler Systems
Jun 6, 2018
Enables migration from system to system with no downtime at incredible speed
What is our primary use case?The primary use case, generally speaking, is either data migration or data loading from an OLTP system to a data warehouse. It's probably Oracle's primary product for migration to the cloud, to later migrate from on-premises into cloud with zero downtime.
Pros and Cons
- "It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."
- "It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful."
- "It scales well. You can either have it working in with the databases, or you can move it outside. It's got the ability to parallelize up, so you can certainly extract and replay the data from your databases in parallel. So it does have horizontal scalability. That is probably one of its stronger features, the ability just to automatically parallelize the replay and playing of data to allow to scale to large volumes."
What other advice do I have?You've got to balance the cost with your requirements. You may find that using something like Dbvisit Replicate is good enough for what you are doing, and it is substantially cheaper.
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2021.
479,323 professionals have used our research since 2012.
Data Quality Software Development Manager at Yapı Kredi Bank
Mar 27, 2017
Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication.
Pros and Cons
- "Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."
- "It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
What other advice do I have?Oracle GoldenGate is a stable, powerful and robust solution for your data replication needs. It supports not only Oracle, but also many source and target systems to replicate. It now has the ability to work together with Oracle Enterprise Manager, as well as it has its own GUI (Oracle GoldenGate Studio). Management Pack and VeriData are additional packs for your management and data verification needs.
Technical Specialist at a healthcare company with 1,001-5,000 employees
Nov 3, 2016
It replicates in real time between heterogeneous databases such as SQL Server, DB2, Oracle, Sybase.
What other advice do I have?I recommend buying the product. It performs outstanding. If you want to offload from your online transaction processing, your application, to an enterprise data warehouse, data lake, etc., this is far beyond a superior tool to the competitors. It's worth the price.
Jul 22, 2015
We're able to use it for real-time ETL and implementation of zero-downtime migrations, but it needs a wizard for table replication.
What other advice do I have?Reduce the price to compete with products like DBVisit because once customers see the power behind this product, they will be locked in forever.
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication being the primary purpose of all the mentioned technologies, each have different internal operational behavior. The purpose is to achieve maximum database availability, these mentioned technologies fully accommodate the requirement but internally there are differences at internal operational level. DBA's must learn and understand the functionality of both and know which technique can be used and in what scenario. Let's discuss the differences between Oracle Active Dataguard and Oracle…
Support for Oracle, MySQL, DB2, Sybase, Teradata, SQL server and others
In 2009, Oracle acquired Golden Gate to strengthen its data replication technology as part of future strategies within data warehouse and real time transaction database. Before this acquisition, Oracle had its own replication technology which mainly constitutes basic replication, advance replication and stream replication. Oracle's basic replication process had two different methods: log based and trigger based. In log based replication, snapshot schema and DB links had to set up between source and target database. Data was transported from online redo log to target database over network. In advance replication Oracle included multiple master replications from multiple environments and trigger based replication method. In later versions of Oracle 9i, stream…
Database Expert at a healthcare company with 501-1,000 employees
Jul 20, 2012
Great Replication tool which gives easy of setup and a small software footprint
What other advice do I have?Integration of Golden Gate with monitoring tools like OEM (Oracle Enterprise Manager) is still not available and most DBAs monitor this with custom scripts. We chose this product mostly on it's bidirectional replication feature and easy setup. Some applications are using this as a messaging mechanism between multiple databases.
Senior Manager of IT at a tech company with 51-200 employees
Jun 6, 2012
Data replication is seamless but time to value can be long
Valuable Features:Data replication is seamless, once it is setup on a database. No triggers to setup.
Room for Improvement:Amount of min. supplemental logging or storage needed is unknown and has to be figured out, so increases time to value.
Product CategoriesData Integration Tools
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.