Item: Oracle GoldenGate
Rating: 10
Author: João Leal

Use Cases and Deployment Scope

It's used by our Computer Services Department to create reporting databases as well as for DR. The replication is unidirectional and replicates data in four non-production environments. This enables us to perform long-running queries without affecting the performance of our production systems. We have a lot of clients using it. It can migrate data between databases in realtime.

Pros and Cons

Flexibility to migrate data.
Fast transactions between source and target databases .
Easy to analyze problems when occur.
Good for disaster recovery and data protection database.

Oracle GoldenGate Studio is expensive, and you can use Grafana instead.
Character set problems when migrating database.

Return on Investment

It's a good investment for your company if you want to migrate fast, but there are a lot of bugs/limitations.

Key Insights

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

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

If you want to migrate databases quickly or put some schemas from the production, quality, or testing databases, you can use GoldenGate (but it is expensive). I only use it for Oracle Source and Oracle Target databases.

GoldenGate is best for real-time data needs.

Overall Satisfaction with Oracle GoldenGate