Great Replication Solution for Heterogeneous database solutions.
March 28, 2019

Great Replication Solution for Heterogeneous database solutions.

Ravi Gupta | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

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.
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