1. Home
  2. Data Replication Software
  3. Oracle GoldenGate Reviews
  4. User Review of Oracle GoldenGate
Overall, GoldenGate is an excellent software to provide real-time data integration and replication
November 12, 2018

Overall, GoldenGate is an excellent software to provide real-time data integration and replication

Wenqiang Cao | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle GoldenGate

It is used by IT to sync data across databases. The source is our SQL Server database and the target is the Oracle database. The source database is outsourced to a third party and we use GoldenGate to sync the data to our local Oracle database. The main challenge we have is that GoldenGate can't replicate DDL among different RDBMS. We have had to stop and rebuild GoldenGate multiple times due to DDL change on the source side.
  • Real Time Sync
  • Less overhead
  • Stable performance
  • Should make the high availability easier to use. Not bound to only DBFS or ACFS.
  • Need a powerful GUI tool to make the configuration easier.
  • Could it be cheaper? Or have a basic free version?
  • If it could support DDL among different RDBMS, that would be great.
  • It increases the data integration speed.
  • Negative impact is that due to many DDL changes on the source side, we need a lot of time to maintain GoldenGate to manually resync.
Well-suited to work between Oracle databases. I worked before at Bank of America and there we used this to replicate from Oracle database to Oracle database. We just replicate the whole schema and enable DDL replication. It is really convenient. Another good example is to use it for zero downtime upgrades. I also believe the active-active is very useful, but haven't tried yet.

Oracle GoldenGate Feature Ratings