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