Item: Oracle GoldenGate
Rating: 9
Author: Bryan Salerno

Overall Satisfaction with Oracle GoldenGate

Use Cases and Deployment Scope

We have been successfully using Goldengate to sync our prod and disaster recovery environments for over a year. It decreased the time to sync and increased reliability. We are very happy with it.

Pros and Cons

Pros

Disaster recovery sync, faster than other products like SharePlex.
Integration features, we are looking at using it to sync other DBs and move data around.
Future use case is to offload data to Cassandra.

Cons

Ability to help migrate between different versions of Oracle could be improved.
Possible compression of data to help with transfers across data centers.
Cost is a little high.

Return on Investment

Decreased sync times by 75% helping protect business interests.
Cost is an impact to expense budget.
Future use of syncing to no SQL databases will help speed up processing by 50% or more based on tests and allow us to do a migration. Off the relational DB over time.