Item: Oracle GoldenGate
Rating: 10
Author: Jacob Biguvu

Use Cases and Deployment Scope

Oracle GoldenGate is being used by the departments as required and as needed. Especially we used for migration purpose. We are migrating the databases from on-premises to Cloud. The real problem is to complete the migration with zero-downtime. We need a revert plan (rollback strategy) when it fails. [Oracle] GoldenGate helped a lot in completing this migration task with Zero-downtime. [Oracle GoldenGate] is real-time data capture, continuous delivery of transaction data across different sources.

Pros and Cons

OGG can be used and integrated with heterogeneous databases as well as homogeneous databases.
OGG is easy setup as well as easy learning curve
OGG supports large databases
OGG support many uses cases (topologies) such as unidirectional replication, bidirectional, peer-to-peer, Broadcast, Cascading replication etc.
OGG can be used not only for CDC (change capture), can be used to full load

Expensive
Require resources such as OGG script developer and SME

Return on Investment

OGG can be used for the database migration
OGG can be used for database replication
OGG can be used for data integration
OGG is expensive (negative)
OGG is cost due to hire SME or expert

Alternatives Considered

SharePlex, Microsoft SQL Server and Qlik Replicate

They are system-limited. Oracle GoldenGate provides more flexibility to use in different use cases and topologies. Most of the other tools are not matured like the Oracle GoldenGate. Oracle GoldenGate is best compared to other tools in terms of high performance, configuration and management, support for the cloud environment, and integration with complex databases.

Key Insights

Do you think Oracle GoldenGate delivers good value for the price?

Yes

Are you happy with Oracle GoldenGate's feature set?

Yes

Did Oracle GoldenGate live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle GoldenGate go as expected?

Yes

Would you buy Oracle GoldenGate again?

Yes

Likelihood to Recommend

when you want to migrate databases with Zero-down migration (on-prem to on-prem/ on-prem to cloud/cloud to cloud / cloud to on-prem)
when you want to replicate the entire database between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
when you want to replicate the specific tables between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
when you want to replicate the data set between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
when you want to create Read-Only databases
when you want to create two master database - using bidirectional databases

Oracle Golden Gate is efficient and high performance

Overall Satisfaction with Oracle GoldenGate