Item: Oracle GoldenGate
Rating: 10
Author: Gurcan Orhan

Use Cases and Deployment Scope

Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now am able to replicate Big Data solution from any supported source system to Hadoop clusters.

Pros and Cons

Ease of installation
Ease of maintenance
Powerful output with sub-second speed
Supporting Big Data and Cloud environment
Capturing source data based on transnational log, no cost on source CPU
Handle the distribution and the delivery of committed data in real-time
Supports heterogeneous systems regarding target or source database
Can be implemented uni-directional, bi-directional or peer-to-peer mode
Zero downtime migration
Supports data distribution
Can be used for disaster recovery or data protection

Oracle GoldenGate Studio could be more user-friendly.
It would be better for Oracle Golden Gate Studio GUI to include other OGG related licensed products (i.e. Veridata or others).

Return on Investment

In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.
But both issues are solved now.
Installation is straightforward, easy.
Deployed everything within Oracle Data Integrator.
Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
Management Pack and VeriData are additional packs for your management and data verification needs.

Alternatives Considered

SharePlex

We switched from SharePlex of Quest Software because of licensing costs.

Other Software Used

Oracle Data Integrator, Oracle Enterprise Data Quality, Oracle Warehouse Builder, Oracle Data Warehouse, Oracle Database, Oracle Database 12c, Oracle Database as a Service, Oracle Exadata Database Machine

Likelihood to Recommend

Capture data based on transaction log

Handle the distribution and the delivery of committed data in real-time

Supports heterogeneous systems both in source or target database

It can work in uni-directional, bi-directional or peer-to-peer mode

It has a sub-second speed

Low impact on source and target systems

Platform independent universal data formatEasy to deploy - simple configuration of parameter files

Conflict detection and resolution

Supports data encryption

Different Source Systems (IBM DB2, Microsoft SQL Server) Are Supported For Real Time Replication.

Overall Satisfaction with Oracle GoldenGate