Oracle GoldenGate Review

We're able to use it for real-time ETL and implementation of zero-downtime migrations, but it needs a wizard for table replication.


Valuable Features

  • Replication by SCN
  • Ability to perform basic data transformation/call user-defined functions
  • Exception handling
  • CDC capabilities when used with ODI

Improvements to My Organization

  • Ability to implement zero-downtime migrations
  • Ability to scale horizontally
  • Ability to use ODI and Goldengate for real-time ETL

Room for Improvement

Current features:

None

New features:

Offer basic process monitoring out-the-box

Offer a (CLI) wizard for quickly creating and configuring (extract, pump, replicat) table replication

Use of Solution

3 years

Deployment Issues

Base versions where a bit buggy particularly during recovery after there were machine/host crashes or unexpected shutdowns. Latest patches/versions resolved these issues.

Stability Issues

Only in Windows were there a few GoldenGate crashes, but we suspect these were due to insufficient memory.

Scalability Issues

No, although we haven't applied parallelism to any of our processes yet.

Customer Service and Technical Support

Customer Service:

Very good. I have often spoken directly with support personal and P1 issues are handled swiftly.

Technical Support:

Excellent for above P3.

Initial Setup

Straightforward

Implementation Team

Initially through a vendor, Michael Rainey from RittmanMead, and we were able to support the product on our own after that. Michael's level of expertise is very high.

ROI

Hard to calculate, but GoldenGate offers an excellent ROI if you use the product cleverly.

Pricing, Setup Cost and Licensing

NA

Other Solutions Considered

No

Other Advice

Reduce the price to compete with products like DBVisit because once customers see the power behind this product, they will be locked in forever.

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