Item: Oracle GoldenGate
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

Oracle GoldenGate is being used by our core software development team. We are using it as a real-time data replication solution to achieve high availability/disaster recovery for our data, to prepare a read-replica database to offload query-based requests, and to perform real-time business intelligence related operations on our synced data.

Pros and Cons

No Downtime during System Migration. Replicating data onto other servers in preparation for a system migration does not result in any downtime.
Initial setup of Oracle GoldenGate is easy and straightforward. Instructions are precise and simple to follow.
Thorough and Insightful Documentation. All troubleshooting and tuning issues are well-known by the community, and hence are well-documented online.

Lack of Simple UI for Non-Technical Users. It would be nice to have an option to toggle simpler, and less advanced options to make it easier for non-technical users to understand what Oracle GoldenGate is.
Lack of Variety of Performance Metrics. Would prefer more detailed performance metrics to be offered out-of-the-box.
Some Features Won't Always Run as Expected. We have sometimes faced issues when features don't run as they are used to. They will be working at times, but there is the occasional failure in streaming.

Return on Investment

As Oracle GoldenGate integrated well with the Oracle products we were already using, we didn't need to spend additional time and money to purchase or develop an integration solution.
XStream and Active Data Guard licenses come free with Oracle GoldenGate, reducing overhead costs.
Eliminated the need to scale our workstations up in terms of hardware resources. Creating read-replicas to offload read requests gave more opportunities to scale horizontally.

Alternatives Considered

I haven't used any other products like Oracle GoldenGate.

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?

Yes

Did implementation of Oracle GoldenGate go as expected?

Yes

Would you buy Oracle GoldenGate again?

Yes

Likelihood to Recommend

Oracle GoldenGate is well-suited for Enterprise-level companies which require mission-critical security and performance along with their real-time data replication needs. Oracle GoldenGate integrates well with other Oracle products as well such as: Oracle Fusion Middleware, Oracle Veridata, Oracle XStream, and Oracle Active Guard. If you plan to use Oracle's products with your data replication workflow, Oracle GoldenGate is the way to go.

The Golden Gate to Success!

Overall Satisfaction with Oracle GoldenGate