Oracle GoldenGate Review

Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication.


What is most valuable?

Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service).

How has it helped my organization?

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 can able to replicate Big Data solution from any supported source system to Hadoop clusters.

What needs improvement?

Oracle GoldenGate Studio could be more user-friendly.

It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others).

For how long have I used the solution?

More than 5 years.

What was my experience with deployment of the solution?

No, if found Oracle Support and/or Oracle Community helped me a lot.

What do I think about the stability of the solution?

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, truncate 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.

What do I think about the scalability of the solution?

No.

How is customer service and technical support?

Customer Service:

Created some service requests about GoldenGate years before, but all are solved.

Technical Support:

10 over 10.

Which solutions did we use previously?

Quest Shareplex, because of licensing costs.

How was the initial setup?

Straightforward, easy. Deployed everything within Oracle Data Integrator.

What about the implementation team?

In-house and vendor, depending on the project.

What was our ROI?

Developing 1000 of ODI interfaces for loading into Operational Data Store will took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.

What's my experience with pricing, setup cost, and licensing?

No comment about pricing and licensing.

Which other solutions did I evaluate?

Yes, we switched from SharePlex of Quest Software.

What other advice do I have?

Oracle GoldenGate is a stable, powerful and robust solution for your data replication needs. It supports not only Oracle, but also many source and target systems to replicate.

It now has the ability to work together with Oracle Enterprise Manager, as well as it has its own GUI (Oracle GoldenGate Studio).

Management Pack and VeriData are additional packs for your management and data verification needs.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email