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

Denodo 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:
 

ROI

Sentiment score
3.9
Migrating to dbt improved efficiency, reduced costs, and enhanced data quality and governance without needing more staff.
Sentiment score
6.5
Denodo boosts ROI by enabling rapid reporting, improving decision-making, and streamlining data integration for enhanced efficiency and customer satisfaction.
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.
Senior Data Engineer at a pharma/biotech company with 10,001+ employees
I have seen a return on investment as it means we don't have to employ as many people.
Head of Data & AI engineering at One NZ
Since we migrated from SSIS to dbt model architecture, it takes around four hours only to complete a full refresh.
Manager Projects at Cognizant
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
Information Technology Manager at Lockheed Martin
If you don't need to write a whole ETL to make the data virtualization, you need way fewer people to write a query instead of writing an ETL pipeline.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
I have seen a return on investment, which showed up in improved customer satisfaction scores.
Quality Engineering Lead at a logistics company with 51-200 employees
 

Customer Service

Sentiment score
7.1
Users praise dbt's responsive support and active community, with satisfaction varying by service tier and resource availability.
Sentiment score
6.9
Denodo support is responsive and helpful, but some users face delays in bug resolution and unfriendliness in the portal.
If you type your question, you will likely find that someone has already asked it, so we do not need to contact their support directly.
Lead Software Engineer at Momentus
I would rate the technical support a nine out of ten.
Manager Projects at Cognizant
We ran dbt Core, which is open-source, so there is no direct vendor support.
AI Engineer at a educational organization with 51-200 employees
They have a good methodology for learning how to use the tool.
Data Architecture and Engineering Specialist at coprocenva
Denodo's customer support team is very competent and responsive.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
Principal Architect at a manufacturing company with 10,001+ employees
 

Scalability Issues

Sentiment score
7.5
dbt is scalable and effective for complex transformations, integrating well with Snowflake, and valued for handling large data sets.
Sentiment score
7.1
Denodo effectively scales across organizations, managing many users and data sources, but performance may vary with automation and configuration.
The bottlenecks that we have are not coming from dbt; they are coming from Snowflake.
Principal Data Engineer at Integrant, Inc.
We were processing large volumes of financial documents, hundreds of trial balances, balance sheets, and invoice sets, and dbt handled the transformation layer without issues.
AI Engineer at a educational organization with 51-200 employees
dbt is quite scalable since it has its own feature set for incorporating business logic.
Data Architect at Envision Pharma, Inc.
For huge data requests, it cannot scale automatically; admin action is required.
Principal Architect at a manufacturing company with 10,001+ employees
Denodo's scalability comes into play specifically when there is data transfer.
Quality Engineering Lead at a logistics company with 51-200 employees
My client has almost 100 million records, and the performance was impacted in a way that required optimization.
Data Consultant at IT-Bots
 

Stability Issues

Sentiment score
7.8
Users praise dbt's stability, noting reliable data processing and comparing it favorably to industry leaders like Informatica and Alteryx.
Sentiment score
7.0
Denodo is stable and reliable in production, with minor issues, praised for robustness but needs technical expertise for optimization.
Comparing it to tools I have seen in the past, such as Informatica and Alteryx, dbt can easily match up to that rating, specifically for stability.
Lead Software Engineer at Momentus
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.
Principal Data Engineer at Integrant, Inc.
When I conduct dbt tests, the data processed in the data warehouse performs exactly as expected.
Data Architect at Envision Pharma, Inc.
I would rate it nine out of ten because it is very reliable, always performing as expected.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Technology Leader at eTCaaS
Denodo is stable and good.
Data Engineer at a consultancy with 11-50 employees
 

Room For Improvement

Users seek better integration, Python support, and stability improvements, alongside enhanced SQL, testing, setup, structure, and package management.
Denodo should expand markets, improve UI and integration, address performance issues, and enhance support and documentation.
Improvement is needed in the tool itself in terms of the copilot, in terms of covering outages, in terms of testing, and in terms of quality reasons related to governance and collaboration.
Senior Data Engineer at a pharma/biotech company with 10,001+ employees
The whole data testing field is not very mature. It is not the same as software testing; for example, you have test suites, test tools, and profilers, but for data testing, it is not yet that advanced.
Principal Data Engineer at Integrant, Inc.
dbt does not have a native concept of multi-tenant or multi-standard project organization.
AI Engineer at a educational organization with 51-200 employees
Ensuring data caching is up to date is critical.
Director Software Engineer at a computer software company with 10,001+ employees
Denodo needs better communication on how the product can be deployed for specific solutions.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
The system has dependencies on other environments, like JVM, which can affect its performance.
Technology Leader at eTCaaS
 

Setup Cost

DBT is cost-effective, open-source, with manageable costs, praised for its affordability and free beginner courses.
Denodo pricing is high, suitable for larger enterprises, with variable costs and value-enhancing features, seen as fair by many.
The course content that dbt provides is free and excellent for anyone starting out.
Lead Software Engineer at Momentus
dbt is open source for its core modules.
Data Engineer at a comms service provider with 10,001+ employees
I mentioned the cost as one of the advantages, specifically the license cost.
Data Engineer at Georgia Institute of Technology
For small companies, it's not a solution that most small companies can afford.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Technology Leader at eTCaaS
 

Valuable Features

dbt offers fast, efficient SQL-based data transformation, with features like version control, templating, and testing for improved performance.
Denodo excels in data integration, virtualization, governance, and scalability, enhancing user experience with API and query optimizations.
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.
Head of Data & AI engineering at One NZ
There are the benefits of having code, so you have a software development lifecycle; you can use version control, testing, and documentation.
Principal Data Engineer at Integrant, Inc.
The tests, especially custom tests for financial data like validating that debits equal credits, caught a lot of our data quality issues early.
AI Engineer at a educational organization with 51-200 employees
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Director Software Engineer at a computer software company with 10,001+ employees
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo supports SQL base, so if you want to join two tables or two views, you can use SQL, which is an advantage as most developers or business people know SQL.
Principal Architect at a manufacturing company with 10,001+ employees
 

Categories and Ranking

dbt
Ranking in Data Integration
11th
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
11
Ranking in other categories
Data Quality (5th)
Denodo
Ranking in Data Integration
7th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
42
Ranking in other categories
Data Virtualization (1st), Cloud Data Integration (8th), Data Management Platforms (DMP) (3rd), AI Data Analysis (2nd)
 

Mindshare comparison

As of June 2026, in the Data Integration category, the mindshare of dbt is 1.4%, down from 1.7% compared to the previous year. The mindshare of Denodo is 1.4%, down from 1.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Denodo1.4%
dbt1.4%
Other97.2%
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.
Patel-Dhulva - PeerSpot reviewer
Information Technology Manager at Lockheed Martin
Data virtualization has unified siloed sources and now supports real-time decisions
The best features Denodo offers stand out to me as the ability to develop REST web services fast and easily, create and combine new views, integrate different sources of data, and connect with other tools seamlessly. When I mention fast and easy creation of views and integration, I love the agile data provisioning and integration, where Denodo provides a comprehensive set of capabilities for implementing logical data integration, management, and delivery, which in turn enables agile data analytics and an informed decision-making process to be smooth. I also appreciate the performance optimization with AI, which improves performance optimization through the integration of artificial intelligence capabilities. Furthermore, I appreciate the unified security and governance, where it addresses the need for an organization to effectively manage security, data privacy, and data protection easily, offering a centralized platform that allows the application of governance policies and fine-grained security controls. Another feature I would add about Denodo is that it also provides a single point of control where we can establish security controls over the entire infrastructure and gain visibility into all our data assets. Denodo has positively impacted my organization as since we started using this tool, it has been very helpful because it is a huge advantage that we can connect to many different databases to provide data rapidly and accurately and also gain insights, which helps us to make data-driven decisions easily. It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues more accurately. Through data insights from Denodo, we have been able to improve our decision making, which helps to better communication between the stakeholders thanks to the real-time experience. It also saves a lot of time.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
900,644 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Insurance Company
7%
Manufacturing Company
7%
Comms Service Provider
7%
Financial Services Firm
22%
Manufacturing Company
14%
Energy/Utilities Company
6%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business2
Midsize Enterprise3
Large Enterprise6
By reviewers
Company SizeCount
Small Business17
Midsize Enterprise6
Large Enterprise20
 

Questions from the Community

What is your experience regarding pricing and costs for dbt?
My experience with pricing, setup cost, and licensing for dbt is that dbt is open source for its core modules, so the pricing, setup, and everything was really good.
What needs improvement with dbt?
dbt can be improved by introducing Python. Ideally, I would want to be able to orchestrate across the DAG and have both Python and SQL combined. The last time I used it, it was not able to visualiz...
What is your primary use case for dbt?
My main use case for dbt is data pipelines. I build data transformations and usually construct analytics pipelines.
Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from it, including administrators, developers, and architects. If you are keen on i...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I think make the product less good or effective. The only thing I can point out is...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data fabric Master data management In my opinion, organizations in different fields...
 

Also Known As

No data available
Denodo for AWS
 

Overview

 

Sample Customers

Information Not Available
Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
Find out what your peers are saying about Denodo vs. dbt and other solutions. Updated: June 2026.
900,644 professionals have used our research since 2012.