

Pentaho Data Integration and Denodo are competitive products in the data management space, with Pentaho having the upper hand in affordability, while Denodo leads in advanced data virtualization capabilities.
Features: Pentaho provides excellent ETL capabilities, a user-friendly graphical interface, and strong support for big data technologies like Hadoop and HBase. Denodo offers powerful data virtualization, supports a wide range of data sources, and includes a robust semantic layer for data modeling.
Room for Improvement: Pentaho could enhance its real-time data processing abilities, offer more advanced data replication options, and improve integration with modern cloud platforms. Denodo might benefit from streamlined deployment processes, reduced complexity in setup, and increased flexibility in pricing models.
Ease of Deployment and Customer Service: Pentaho offers straightforward deployment and responsive customer service, focusing on simplifying complex data operations. Denodo's deployment is intricate due to its sophisticated virtualization, but it provides extensive documentation and training to support users.
Pricing and ROI: Pentaho presents a cost-effective solution, offering favorable ROI through its extensive features, appealing to budget-conscious organizations. Denodo requires a larger initial investment but is seen as providing substantial ROI for those prioritizing cutting-edge data virtualization capabilities.
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.
I have seen a return on investment; my team was able to stay extremely small even though we had a lot of data integrations with many companies.
I can testify to the return on investment with metrics regarding time saved; we have increased our efficiency by about 20 to 30 percent due to the swift migration processes facilitated by the tool.
I have noticed a return on investment with Pentaho Data Integration and Analytics in terms of time savings and staff reduction.
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.
24/7 assistance is available for the Enterprise Edition.
take the time to understand our business requirements, offering appropriate recommendations.
Communication with the vendor is challenging
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.
It can be scaled well until you reach a point where you need to perform a lot of operations, and the issue arises when it runs out of memory to handle some data.
Its ability to scale horizontally in cloud-native architectures or for massive real-time processing is limited.
Pentaho Data Integration handles larger datasets better.
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.
Performance issues arise due to reliance on a flowchart-based mechanism instead of scripts, which can lead to longer execution times.
I find that version 3.1 is the most stable version I have ever used.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
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.
We should also explore more effective partitioning for parallel processing and fine-tuning database connections to reduce load times and improve ETL speed.
Pentaho Data Integration and Analytics can be improved by working with different environments, specifically the possibility to change the variables, meaning I write my variables only once and can change them for different environments such as production or development.
Pentaho Data Integration and Analytics could have real-time processing and automatic alerting, having alerts or automatic notifications when a job fails or when certain data doesn't meet certain rules.
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.
I use the community version of Pentaho Data Integration and Analytics, and I do not need additional costs.
The setup cost was minimal, and the pricing experience was pretty good.
The company covered it and they had no problem paying for it because they saw that it was cost-effective in terms of performance afterwards.
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.
Pentaho Data Integration and Analytics has positively impacted my organization because it meant we didn't have to write a lot of custom API back-end processing logic; it did the majority of that heavy lifting for us.
It automates the data workflow, including extraction, cleansing, and loading into warehouses for BI reporting purposes, while also removing duplicates, validating data, and standardizing formats, enabling real-time decision-making.
Pentaho Data Integration and Analytics has positively impacted my organization because it is easier to use, and my knowledge about this work facilitates the translation from the source to my final system.
| Product | Mindshare (%) |
|---|---|
| Denodo | 1.4% |
| Pentaho Data Integration and Analytics | 1.7% |
| Other | 96.9% |


| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 21 |
| Company Size | Count |
|---|---|
| Small Business | 18 |
| Midsize Enterprise | 17 |
| Large Enterprise | 31 |
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.
Pentaho Data Integration and Analytics offers an intuitive platform for data workflows, enabling users to easily manage ETL processes across diverse data formats, ensuring seamless automation and development.
With its drag-and-drop interface, Pentaho allows for efficient ETL workflows without extensive coding. It supports a multitude of data formats and sources such as SQL, NoSQL, Hadoop, CSV, and JSON. Advanced features like metadata injection and API integration enable seamless automation. However, improvements in big data performance, better cloud service integration, and enhanced real-time processing capabilities can enhance user experience. Additional connectors and improved documentation are sought after by many. Providing support for more programming languages and optimizing memory usage also presents opportunities for enhancement.
What are the key features of Pentaho Data Integration and Analytics?Pentaho is employed across finance, healthcare, and retail industries for ETL processes. It's instrumental in integrating data from ERP, SAP systems, Excel, and APIs to develop comprehensive reports and data models. Companies rely on its capabilities for both on-premises and cloud deployments, improving data transparency and management.
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.