- Replication by SCN
- Ability to perform basic data transformation/call user-defined functions
- Exception handling
- CDC capabilities when used with ODI
Solutions Developer at a music company with 51-200 employees
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?
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.
Database Expert at a tech company with 51-200 employees
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.
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 IntegrationPopular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Azure Data Factory
Informatica PowerCenter
Teradata
Oracle Data Integrator (ODI)
Talend Open Studio
IBM InfoSphere DataStage
Palantir Foundry
SAP Data Services
Qlik Replicate
Alteryx Designer
Fivetran
SnapLogic
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which ETL tool would you recommend to populate data from OLTP to OLAP?
- Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
- Should we choose Data Hub or GoldenGate?
- When evaluating Data Integration, what aspect do you think is the most important to look for?
- Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
- What are the best on-prem ETL tools?
- Which integration solution is best for a company that wants to integrate systems between sales, marketing, and project development operations systems?
- Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
- Should we choose Data Hub or GoldenGate?
- What are the must-have features for a Data integration system?
Can we monitor using GUI tools like EM Oracle to Teradata replication using GoldenGate?