TrustRadius
Oracle GoldenGate for real time replication
https://www.trustradius.com/data-integrationOracle GoldenGateUnspecified8.4172101
No photo available
October 25, 2017

Oracle GoldenGate for real time replication

Score 6 out of 101
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
6
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
7
Complex transformations
5
Data model creation
7
Metadata management
6
Business rules and workflow
6
Collaboration
4
Testing and debugging
4
Integration with data quality tools
5
Integration with MDM tools
6