No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle GoldenGate vs dbt comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

dbt
Ranking in Data Integration
9th
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
10
Ranking in other categories
Data Quality (5th)
Oracle GoldenGate
Ranking in Data Integration
17th
Average Rating
8.2
Reviews Sentiment
6.3
Number of Reviews
52
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2026, in the Data Integration category, the mindshare of dbt is 1.4%, down from 1.5% compared to the previous year. The mindshare of Oracle GoldenGate is 1.5%, down from 3.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
dbt1.4%
Oracle GoldenGate1.5%
Other97.1%
Data Integration
 

Featured Reviews

Harshwardhan Gullapalli - PeerSpot reviewer
AI Engineer at a educational organization with 51-200 employees
Data pipelines have improved financial accuracy and now build transparent audit-ready reports
As for something I wish we had, dbt's native support for Python transformations came later, and we did some complex financial classification calculations that felt clunky in pure SQL. We ended up writing Python in our n8n workflows and then fed the results back into dbt, which created a bit of a split-brain situation. If we would have had dbt Python models earlier, we could have kept that logic unified. Managing multiple reporting standards was our biggest operational pain point with dbt. We were running UAE corporate tax compliance and IFRS disclosure workflows simultaneously for different clients, and dbt does not have a native concept of multi-tenant or multi-standard project organization. Everything lives in one flat structure, so we had to build more conventions: separate schema folders for IFRS models versus UACT models, custom macros to tag models by compliance regime, and environment variables to control which set of transformations run for which client.
EmmanuelCatalano - PeerSpot reviewer
DBA at a tech services company with 5,001-10,000 employees
Real-time data streaming has simplified transformations and kept enterprise databases synchronized
Oracle GoldenGate is good, but I would like to improve it. There is a need for whoever installs and configures Oracle GoldenGate to set the correct parameters for the use cases we need to use. In some cases, we had performance problems related to the streaming because there was a lot of information to stream concurrently. However, you can tune Oracle GoldenGate to use more RAM on the source side or more processes. I think that sometimes what is missing is knowledge about the tool from the person responsible for configuration. At this moment, Oracle GoldenGate is a very good tool, and I do not know in which area we can improve it. Perhaps the debug part of the tool could be improved. In some cases, I use the utility for how Oracle GoldenGate generates messages about the statements that it streams because of bugs, and in some cases, it is not very user-friendly. It may be possible to improve the API or the path related to debugging, but not the tool itself. The tool itself is good. I remember that in some configurations, we had problems with the streaming of DDL, which are changes to Oracle object structures such as tables and procedures. A new feature could be to perform streaming for operational objects such as procedures, functions, packages, or grants. This would synchronize source and target for these aspects, not only for data or the main types of structures, but also for others. I remember that there was some configuration in which you performed the streaming of the entire schema, or if you performed streaming for only tables, then you were unable to stream grants and other Oracle objects. I think it is important to introduce that capability.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product is developer-friendly."
"I would say the best feature or the most desirable feature for dbt is the ability to write everything in code."
"dbt has positively impacted my organization by allowing us to create our data pipelines much faster, going from ingestion of data to creating a data product in weeks instead of months, and we can do it in-house with the skillset we already have."
"Overall, I find dbt to be optimized compared to other tools."
"From a developer point of view, I find the ease of development and the code to be the most useful capabilities of dbt."
"It is very convenient because at the end, I have the opportunity to orchestrate all my transformations in just one single place, rather than having them spread out."
"Since we migrated from SSIS to dbt model architecture, it takes around four hours only to complete a full refresh, and the client is now happy because our downtime was drastically reduced when we perform a complete refresh of the data."
"There is operational efficiency achieved, and data quality and governance have also been achieved with modular SQL and version controlling, which reduced duplication of data and data errors."
"The most valuable feature of Oracle GoldenGate is its ability to sync data in real-time, which is crucial for me."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"The product is reliable for data integrity."
"This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation."
"It scales well. You can either have it working in with the databases, or you can move it outside. It's got the ability to parallelize up, so you can certainly extract and replay the data from your databases in parallel. So it does have horizontal scalability. That is probably one of its stronger features, the ability just to automatically parallelize the replay and playing of data to allow to scale to large volumes."
"Oracle GoldenGate is a stable, powerful and robust solution for your data replication needs."
"Oracle GoldenGate is beneficial for data replication and ensures secure data transport."
"It is quite scalable."
 

Cons

"Dbt is not as stable as preferred, as it has had a few outages in the current year itself, so improvement should be made in the outages section as it is not stable."
"If you compare the cost of those packages with dbt alone, it is more expensive to use dbt alone."
"Every upgrade is a little bit of a risk for us because we do not know if the workarounds that we developed will be available for the next version."
"dbt can be improved as I find the co-pilot in dbt is not very good, and my team has tried using it but opted to move off it and use other co-pilots such as GitHub."
"Managing multiple reporting standards was our biggest operational pain point with dbt."
"The solution must add more Python-based implementations."
"The initial setup of dbt is somewhat complex."
"If I needed to name a few areas for improvement, I would mention the migration of code to Git and GitHub, which sometimes fails and can be confusing for developers during handover."
"The licensing model should be improved to be more cost-effective for the end users."
"The GoldenGate license is very costly."
"Oracle GoldenGate Studio could be more user-friendly."
"The process of transforming the data between two different databases is inefficient and needs to be improved."
"Oracle support is very frustrating in terms of how they pass tickets back and forth and don't read your problem statement."
"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."
"The solution sometimes has issues with long transactions and replication delays. Its pricing needs improvement."
"The support from Oracle could be improved; it is sometimes a challenge."
 

Pricing and Cost Advice

"The solution’s pricing is affordable."
"The tool needs to improve its pricing."
"Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. There don't seem to be any additional costs."
"The solution would be costly for a small organization."
"The return on investment would make it a worthwhile deal."
"We do like the price of this solution."
"Oracle GoldenGate's cost is high."
"The solution is highly-priced."
"We have purchased corporate licensing to use Oracle GoldenGate."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
893,221 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Database Administrator at a tech services company with 51-200 employees
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Insurance Company
8%
Manufacturing Company
8%
Comms Service Provider
7%
Financial Services Firm
18%
Manufacturing Company
7%
Computer Software Company
6%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business2
Midsize Enterprise3
Large Enterprise5
By reviewers
Company SizeCount
Small Business22
Midsize Enterprise5
Large Enterprise30
 

Questions from the Community

What is your experience regarding pricing and costs for dbt?
I mentioned the cost as one of the advantages, specifically the license cost.
What needs improvement with dbt?
With AI, everything is advancing so fast, so I would say that the most important thing is to try to integrate with more platforms. As of now, dbt has a strong integration with AWS and with Snowflak...
What is your primary use case for dbt?
I am currently working with dbt and use dbt's modular SQL models.
What is your experience regarding pricing and costs for Oracle GoldenGate?
The pricing of Oracle GoldenGate depends on the discount we receive from Oracle. If the customer orders a larger quantity, we get a more flexible price. The list price is high, and the price can so...
What needs improvement with Oracle GoldenGate?
Oracle GoldenGate is good, but I would like to improve it. There is a need for whoever installs and configures Oracle GoldenGate to set the correct parameters for the use cases we need to use. In s...
What is your primary use case for Oracle GoldenGate?
I'm working with other Oracle products and Oracle GoldenGate on-premises. I can share my experience with Oracle GoldenGate on-premises. I have used it for several years to stream data between datab...
 

Also Known As

No data available
GoldenGate
 

Overview

 

Sample Customers

Information Not Available
Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
Find out what your peers are saying about Oracle GoldenGate vs. dbt and other solutions. Updated: April 2026.
893,221 professionals have used our research since 2012.