Undoubtedly the best database replication solution in market
Anonymous | TrustRadius Reviewer
September 07, 2018

Undoubtedly the best database replication solution in market

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle GoldenGate

I have been using Oracle GoldenGate since 2011, 2 years right after Oracle acquired the company. It was an awesome project back then with version 10, but Oracle has continued adding tonnes of features to it ever since and this is just the best replication solution I have worked with. I have done all kinds of replication using Oracle GoldenGate. Be it homogeneous, heterogeneous, unidirectional, bidirectional, on premise, on cloud (Oracle Public Cloud), integrating with JMS (Java Messaging System) - we have done it all. We have loved the product so much that we have over years replaced all our existing replication infrastructure using Oracle GoldenGate. I love that you can perform changes in almost zero downtime, replicate millions of data in sub seconds and their is large online documentations and forums to help you with troubleshooting any problems. This doesn't requires a lot of expertise to begin with and overtime, you will love working on it. Oracle GoldenGate now also comes with many GUI based tools like OGG Studio, OGG Director, OGG Monitor and OGG Veridata. These come with additional cost, but are great add-ons. We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tonnes of applications to assign installation and repair jobs to field technicians. In some of the applications, we can't afford latency or replication errors. GoldenGate has been a great tool.
  • Oracle GoldenGate lets you replicate data in homogeneous, heterogeneous, unidirectional, bidirectional, on premise , on cloud (Oracle Public Cloud).
  • You can integrate Oracle GoldenGate with non relational database systems like JMS (Java Messaging System).
  • You can also generate flat files in real time and feed into systems like a data lake.
  • I am an Oracle GoldenGate fan, so it's hard to say what I dislike about it. But yes, I would have loved if it was easier to find syntax errors in your GoldenGate commands. Sometimes it just tells you ambiguous generic error messages for a syntax error.
  • Oracle GoldenGate sometimes gives you too many ways to do the same thing. It makes it slightly confusing for less experienced people to choose among different options available.
  • logdump utility is great to view a trail file being replicated, but it is not straight forward and easy to understand. It requires a lot of technical knowledge to read through a trail file using log dump utility. This can be made better.
  • Oracle GoldenGate, being an Oracle tool, is slightly on the expensive side compared to similar tools offered by vendors like Dell.
  • We still chose to replace all our existing replication infrastructure with Oracle GoldenGate for the ease of implementation and sophisticated features very well apt for our complex business requirements.
  • Our customers have been extremely satisfied with our GoldenGate implementations.
SharePlex offers a cheaper alternative and is sometimes faster performing as well for simpler replication needs, but Oracle GoldenGate comes with tonnes of features that I have not seen in any other competing technology. OGG offers real time flat file generation, integration with Java Systems, integration with Big Data and Cloud. OGG also has awesome GUI tools for monitoring and validation. It supports multiple database types and replication topologies.
Oracle GoldenGate is most appropriate where a relational database replication is involved. However, with changing times and Big Data advancement, we are moving away from relational to more distributed databases (NoSQL). Oracle GoldenGate yet needs to become more sophisticated to be useful in NoSQL environments.

Oracle GoldenGate Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools