Oracle GoldenGate for real time replication
October 25, 2017

Oracle GoldenGate for real time replication

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

Overall Satisfaction with Oracle GoldenGate

We use Oracle databases as the primary data storage facility for our university. We have many ERP products that need to integrate with custom applications designed to support our IT infrastructure. We decided to use Oracle GoldenGate as a means of keeping data in sync between our ERP system and a temporary data-cache. It offers real-time replication of data between different database systems.
  • I think it's a very useful tool that can provide live transactional data across heterogeneous environments.
  • Oracle GoldenGate allows you to configure data mapping between different tables using simple configuration files.
  • The licensing agreement that we had for GoldenGate did not include an admin visual console to monitor the different replication processes in real time.
  • Once a replication process gets abended due to some data load error, the product does not skip onto the next record to continue replication. This was one feature we really needed.
  • We found this product really useful since it allowed us to keep two different data stores in sync.
  • It freed us from conducting expansive querying of our live data base, and instead just using the data-cache store instead.
Oracle GoldenGate was the obvious choice for us since we already had an entire Oracle ERP suite implemented at our university.
The product is well suited for managing real-time replication between Oracle databases. It is useful for keeping audit trails on transaction logs. It is difficult to configure if multiple database products are involved like IBM DB2 or Microsoft SQL server.

Oracle GoldenGate Feature Ratings