Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Solutions Developer at a music company with 51-200 employees
Vendor
We're able to use it for real-time ETL and implementation of zero-downtime migrations, but it needs a wizard for table replication.

What is most valuable?

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

How has it helped my organization?

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

What needs 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

For how long have I used the solution?

3 years

Buyer's Guide
Oracle GoldenGate
January 2025
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,997 professionals have used our research since 2012.

What was my experience with deployment of the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How are customer service and 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.

How was the initial setup?

Straightforward

What about the 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.

What was our ROI?

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

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

NA

Which other solutions did I evaluate?

No

What other advice do I have?

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.
PeerSpot user
it_user1221 - PeerSpot reviewer
Database Expert at a tech company with 51-200 employees
Real User
Great Replication tool which gives easy of setup and a small software footprint

Valuable Features:

This product is meant to replace Oracle's Data Guard replication. The setup is simple and it can handle bi directional replication very easily. Training cost is minimal and most DBAs self learn this product. replication between various types of databases is supported and software foot print is very small . Change trails are not very big and easy to manage and store.

Room for Improvement:

DDL (data definition language) replication is still to mature and can be an issue. Supplemental logging causes extra redo log generation in the log storage. Licensing cost is higher as compared to other replication products. Configuration of Golden Gate in HA (High Availability) mode needs setup of extra VIPs which can be challenging in a RAC environment.

Other Advice:

Integration of Golden Gate with monitoring tools like OEM (Oracle Enterprise Manager) is still not available and most DBAs monitor this with custom scripts. We chose this product mostly on it's bidirectional replication feature and easy setup. Some applications are using this as a messaging mechanism between multiple databases.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user

Can we monitor using GUI tools like EM Oracle to Teradata replication using GoldenGate?

See all 5 comments
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.
Updated: January 2025
Product Categories
Data Integration
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.