An OK tool for data replication--not great but not completely terrible
December 03, 2020

An OK tool for data replication--not great but not completely terrible

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle GoldenGate

Oracle GoldenGate is used in a traditional manner for homogeneous data replication between production and non-production environments. This allows the different environments to be utilized for different purposes with the same source data. Some environments are for real-time data analysis while others are backend reporting and analysis.
Oracle GoldenGate allows us to split highly responsive, mission critical systems from lower environments while retaining clean copies of source data.
  • Integrates with Oracle databases and Oracle database servers (particularly exadata - engineered systems)
  • Easy to define source and destination data attributes and configuration
  • Robust error reporting
  • More integration with traditional Oracle products such as SQL*plus
  • GUI
  • More transparent integration with OEM
  • More standard error reporting similar to traditional Oracle products
  • Positive--no separate licensing from Oracle database products or engineered systems, so no extra cost
  • Negative--too complex to become fully adopted as the de facto data replication tool
  • Negative--too difficult to support, so tool-specific specialists are required to handle configuration and support
Oracle GoldenGate is the preferred solution for streamlining cross-platform data replication; with Autonomous Database, Data Pump import and export can provide similar results but are less robust and require much more customization. Data Pump does provide a great degree of ease of use as it is fully integrated with the Oracle database product whereas Oracle GoldenGate is its own standalone tool.

Do you think Oracle GoldenGate delivers good value for the price?

Not sure

Are you happy with Oracle GoldenGate's feature set?

Yes

Did Oracle GoldenGate live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle GoldenGate go as expected?

No

Would you buy Oracle GoldenGate again?

Yes

Oracle database data replication is very straightforward but still a bit too complicated to configure (versus an out-of-the-box, easy-to-configure data replication tool). Oracle GoldenGate is advertised as being able to replicate data between different database products (vendors) as well as different versions of the space database product (so Oracle 11g replicated to Oracle 12c). Given that it's complicated to configure for Oracle database to Oracle database (same version), I'm sure any of the other advertised configurations are more complicated. These complexities make Oracle GoldenGate a difficult sell internally. It needs to be more straightforward and out of the box to configure and utilize.

Oracle GoldenGate Feature Ratings