TrustRadius
Great Replication Solution for Heterogeneous database solutions.
https://www.trustradius.com/data-integrationOracle GoldenGateUnspecified8.4172101
Ravi Gupta profile photo
March 28, 2019

Great Replication Solution for Heterogeneous database solutions.

Score 10 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle GoldenGate

We have been using Oracle GoldenGate (OGG) for our replication needs. We have a mix of database environments including Oracle, DB2 and Microsoft SQL Server. We use Oracle GoldenGate to replicate across the mix of these different RDBMS. OGG is reliable, fast, has high throughput and allows heterogeneous replication.

We also use OGG Management Pack which is an extra license cost and includes Oracle GoldenGate Monitor, Oracle GoldenGate Director and Oracle GoldenGate Veridata.
  • Supports both homogeneous and heterogeneous replications.
  • Supports DDL replication if both source and target databases are Oracle.
  • Supports multiple replication topology such as unidirectional, bi-directional, cascading, peer to peer and multicasting.
  • Can interface with JMS and Big Data Systems.
  • Like most Oracle products, it is quite expensive.
  • Too many tables in single replication channels creates performance bottlenecks. You have to split your tables into multiple channels.
  • Time to go live was [reduced] as scripts and configuration files were reusable across environments.
  • Day to day administration is easy and convenient. This reduces database/application downtime.
  • Not a member of any user groups
We evaluated SQData, Dell Shareplex and some other replication software. OGG was our choice for breadth of services and wide range of RDBMS and Big Data solutions it supports.
Red Hat JBoss Enterprise Application Platform, Oracle Enterprise Manager Cloud Control, Oracle Enterprise Manager, Veeam Backup & Replication, vCenter Site Recovery Manager, VMware Site Recovery Manager, JIRA Software, HPE 3PAR StoreServ Storage, HPE StoreOnce, ClickUp, Toad for Oracle, erwin Data Modeler, Red Hat Enterprise Linux (RHEL), Apple Remote Desktop, Chrome Remote Desktop, Google Authenticator, Apple iCloud, Asana, VMware vCenter Server, Control-M, VMware ESXi, Slack, Remote Desktop Manager, Ubuntu Linux, WebSphere Enterprise Service Bus, dbForge Studio for Oracle, dbForge Studio for PostgreSQL, Apache Hive, Artesian, Apache Flume, WebSphere Message Broker, Apache Kafka, Aomei Backupper Standard, WebSphere Process Server, Avira Antivirus
We have been very impressed by Oracle GoldenGate and would recommend it for any RDBMS replication needs.

Oracle GoldenGate Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
9
Simple transformations
10
Complex transformations
10
Data model creation
7
Metadata management
8
Business rules and workflow
8
Collaboration
9
Testing and debugging
8
feature 1
8
Integration with data quality tools
10
Integration with MDM tools
9