Try our new research platform with insights from 80,000+ expert users

Denodo vs Pentaho Data Integration and Analytics 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
8.0
Denodo enhances ROI by speeding processes, improving strategic accuracy, reducing churn, and boosting customer loyalty within six months.
Sentiment score
7.9
Pentaho offers cost-effective integration, reducing ETL time, lowering expenses, and enhancing competitiveness with open-source flexibility and efficiency.
 

Customer Service

Sentiment score
7.2
Denodo's service and support are praised for expertise and promptness, but initial support and training need improvement.
Sentiment score
5.2
Users rely on community support over customer service due to mixed experiences, despite responsive technical support and Hitachi's involvement.
Denodo's customer support team is very competent and responsive.
The documentation is very thorough.
They are proactive in conducting webinars and connecting with customers.
Communication with the vendor is challenging
 

Scalability Issues

Sentiment score
7.6
Denodo offers scalable architecture with successful integration and deployment, overcoming financial and query delegation challenges to ensure performance.
Sentiment score
7.3
Pentaho excels in scalability and efficient data handling but faces challenges with exceptionally large data and complex growth scenarios.
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
Pentaho Data Integration handles larger datasets better.
 

Stability Issues

Sentiment score
7.1
Denodo is stable, handles stress well, but faces occasional challenges with complex queries and external dependencies.
Sentiment score
7.1
Pentaho Data Integration offers reliability for small to midsize operations but may lag and freeze with complex uses.
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.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
 

Room For Improvement

Denodo requires improvements in data catalog, integration, modernization, connectivity, security, performance, visualization, documentation, and user-friendliness.
Pentaho needs improvements in big data performance, error handling, UI, scheduling, backward compatibility, cloud integration, and Python support.
The system has dependencies on other environments, like JVM, which can affect its performance.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle.
 

Setup Cost

Denodo's pricing is expensive but fair for enterprises, with various editions and licensing often based on CPU or core.
Pentaho offers a cost-effective solution with its free Community Edition and affordable subscription-based Enterprise Edition for varying needs.
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.
 

Valuable Features

Denodo offers efficient data virtualization with robust integration, optimized queries, and secure access, enhancing analytics and data management.
Pentaho provides an intuitive, open-source platform for efficient ETL development and data integration with minimal coding and broad compatibility.
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's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Its catalog is useful for data governance and helps document information for databases and fields.
I find the drag and drop feature in Pentaho Data Integration very useful for integration.
 

Categories and Ranking

Denodo
Ranking in Data Integration
10th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
36
Ranking in other categories
Data Virtualization (1st), Cloud Data Integration (6th)
Pentaho Data Integration an...
Ranking in Data Integration
24th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
53
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of January 2025, in the Data Integration category, the mindshare of Denodo is 1.9%, down from 2.0% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.5%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Vishal_Goyal - PeerSpot reviewer
The data catalog feature helps define data structures without storing data
The data catalog feature is valuable as it helps define data structures without storing data. Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy. It supports API usage to call and present data in JSON or Tableau format without visualization capabilities.
Ryan Ferdon - PeerSpot reviewer
Low-code makes development faster than with Python, but there were caching issues
If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was. It was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
831,265 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Manufacturing Company
10%
Computer Software Company
9%
Energy/Utilities Company
8%
Financial Services Firm
22%
Computer Software Company
14%
Government
7%
Comms Service Provider
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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...
Which ETL tool would you recommend to populate data from OLTP to OLAP?
Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...
What do you think can be improved with Hitachi Lumada Data Integrations?
In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...
What do you use Hitachi Lumada Data Integrations for most frequently?
My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...
 

Also Known As

No data available
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

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
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Denodo vs. Pentaho Data Integration and Analytics and other solutions. Updated: January 2025.
831,265 professionals have used our research since 2012.