

Denodo and dbt compete in the data management and transformation space. dbt has an advantage with its standout features that justify its cost.
Features: Denodo specializes in data virtualization and integration, providing efficient data abstraction and federation capabilities. It offers a unified data access layer and supports a variety of data sources. dbt focuses on transforming raw data within the data warehouse, leveraging SQL for analytics engineering. It facilitates data transformation workflows in the warehouse and includes strong version control and testing features.
Ease of Deployment and Customer Service: Denodo's deployment is complex due to its comprehensive capabilities and support for diverse data environments, requiring expert intervention, but their customer service is robust. dbt offers straightforward deployment with ease of setup in cloud environments and relies on a community-driven support model with abundant resources but less direct customer service.
Pricing and ROI: Denodo's setup costs are higher due to advanced integration features but offer potential returns through comprehensive data management. dbt presents a cost-effective option with agile and scalable approaches, offering significant ROI in terms of rapid deployment and reduced time to value in analytics workflows.
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.
I have seen a return on investment as it means we don't have to employ as many people.
Since we migrated from SSIS to dbt model architecture, it takes around four hours only to complete a full refresh.
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
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.
I have seen a return on investment, which showed up in improved customer satisfaction scores.
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.
I would rate the technical support a nine out of ten.
We ran dbt Core, which is open-source, so there is no direct vendor support.
They have a good methodology for learning how to use the tool.
Denodo's customer support team is very competent and responsive.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
The bottlenecks that we have are not coming from dbt; they are coming from Snowflake.
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.
dbt is quite scalable since it has its own feature set for incorporating business logic.
For huge data requests, it cannot scale automatically; admin action is required.
Denodo's scalability comes into play specifically when there is data transfer.
My client has almost 100 million records, and the performance was impacted in a way that required 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.
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.
When I conduct dbt tests, the data processed in the data warehouse performs exactly as expected.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Denodo is stable and good.
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.
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.
dbt does not have a native concept of multi-tenant or multi-standard project organization.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
The system has dependencies on other environments, like JVM, which can affect its performance.
The course content that dbt provides is free and excellent for anyone starting out.
dbt is open source for its core modules.
I mentioned the cost as one of the advantages, specifically the license cost.
For small companies, it's not a solution that most small companies can afford.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
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.
There are the benefits of having code, so you have a software development lifecycle; you can use version control, testing, and documentation.
The tests, especially custom tests for financial data like validating that debits equal credits, caught a lot of our data quality issues early.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
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.
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.
| Product | Mindshare (%) |
|---|---|
| Denodo | 1.4% |
| dbt | 1.4% |
| Other | 97.2% |


| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 3 |
| Large Enterprise | 6 |
| Company Size | Count |
|---|---|
| Small Business | 17 |
| Midsize Enterprise | 6 |
| Large Enterprise | 20 |
dbt is a transformational tool that empowers data teams to quickly build trusted data models, providing a shared language for analysts and engineering teams. Its flexibility and robust feature set make it a popular choice for modern data teams seeking efficiency.
Designed to integrate seamlessly with the data warehouse, dbt enables analytics engineers to transform raw data into reliable datasets for analysis. Its SQL-centric approach reduces the learning curve for users familiar with it, allowing powerful transformations and data modeling without needing a custom backend. While widely beneficial, dbt could improve in areas like version management and support for complex transformations out of the box.
What are the most valuable features of dbt?
What benefits should you expect from using dbt?
In the finance industry, dbt helps in cleansing and preparing transactional data for analysis, leading to more accurate financial reporting. In e-commerce, it empowers teams to rapidly integrate and analyze customer behavior data, optimizing marketing strategies and improving user experience.
Denodo specializes in data virtualization, data cataloging, and user-friendly interfaces. It's recognized for connecting disparate data sources, presenting unified data for analytics, and supporting efficient decision-making with agile analytics and robust data governance.
Denodo effectively aggregates data from multiple sources to offer a comprehensive understanding through its virtualization capabilities. It provides role-based access control, flexible query languages, performance optimization, and integration with databases. Enhancements are needed in its interface and documentation to ensure better user experiences. While the platform supports cloud migration, integration challenges with tools like Salesforce and MuleSoft exist. Improvements in data visualization, automation, and scalability, especially in large data environments, are critical areas for growth.
What are the key features of Denodo?In industries like finance, healthcare, and retail, Denodo plays a crucial role in data virtualization and integration. Organizations use it to unify disparate data systems, enabling real-time analytics and supporting cloud migrations. Denodo's platform is ideal for businesses needing to aggregate, transform, and utilize diverse data efficiently, optimizing operations and enhancing governance.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.