Oracle GoldenGate Review
Great Replication tool which gives easy of setup and a small software footprint
Valuable Features:
This product is meant to replace Oracle's Data Guard replication. The setup is simple and it can handle bi directional replication very easily. Training cost is minimal and most DBAs self learn this product. replication between various types of databases is supported and software foot print is very small . Change trails are not very big and easy to manage and store.
Room for Improvement:
DDL (data definition language) replication is still to mature and can be an issue. Supplemental logging causes extra redo log generation in the log storage. Licensing cost is higher as compared to other replication products. Configuration of Golden Gate in HA (High Availability) mode needs setup of extra VIPs which can be challenging in a RAC environment.
Other Advice:
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.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Jul 20 2012
More Oracle GoldenGate reviews from users...who work at a Healthcare Company
...at Small Businesses
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.
Add a Comment
5 Comments
it_user3876 (Database Manager at a tech services company with 501-1,000 employees)Consultant
Management pack for Oracle GoldenGate license includes a plug-in for Oracle Enterprise Manager, as well as a monitoring component.
it_user4401 (Developer at a transportation company with 1,001-5,000 employees)Vendor
It is very reliable. It delivers all commented records to the target, even in the event of network outages. It works data without requiring system interruption or outage windows.
it_user6414 (CEO at a tech services company with 501-1,000 employees)Consultant
Oracle GG is a great tool which is easy to install. What i personally finds challenging and should be addressed is the manner at which it handles DDL replication. It is quite difficult to perform selective replication as it replicate every DDL in the source database.
it_user6615 (Anonymous User at a tech services company)Consultant
I dont think it is ment to replace data guard. It's a great tool for "zero down time" migrations
it_user126345 (User)Vendor
Can we monitor using GUI tools like EM Oracle to Teradata replication using GoldenGate?
Author
it_user1221
Database Expert at a healthcare company with 501-1,000 employees
Vendor
Highlights
This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation.
This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us.
When we are replicating data between similar databases then it is straightforward.
The initial setup is straightforward. It doesn't take too much time or effort to implement the solution.
This is a powerful solution provided by one of the most respected companies in the computer industry.
The most valuable feature is data replication capability.
The CDC feature is interesting.
Product Categories
Data Integration ToolsPopular Comparisons
AWS Database Migration Service
Oracle Data Integrator (ODI)
Qlik Replicate
Quest SharePlex
HVR Software
Informatica PowerCenter
Azure Data Factory
IBM InfoSphere DataStage
IBM InfoSphere Information Server
Informatica PowerExchange
StreamSets
JumpMind SymmetricDS
SAP Data Services
Mule Anypoint Platform
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros
sharing their opinions.