Oracle GoldenGate for real time replication
Anonymous | TrustRadius Reviewer
October 25, 2017

Oracle GoldenGate for real time replication

Score 6 out of 10
Vetted Review
Verified User
Review Source

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

Connect to traditional data sources
Connecto to Big Data and NoSQL
Not Rated
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