No more typing reviews! Try our Samantha, our new voice AI agent.
Pentaho Data Integration and Analytics Logo

Pentaho Data Integration and Analytics pros and cons

4.0 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Pentaho Kettle enables rapid development with an intuitive interface, providing quick ETL, reporting, analysis, and analytics.
Flexible deployment across on-prem and cloud environments is highly beneficial for secure and multi-server usage.
Lumada significantly reduces ETL development and processing time by leveraging metadata to automate data pipelines.
Pentaho Data Integration has positively impacted organizations by automating tasks, saving costs, and enhancing data integration capabilities.
The tool is effective for integrating unstructured or semi-structured datasets with strong parallelization capabilities.

CONS

Performance issues are observed when handling large datasets, especially in cloud environments, leading to memory errors and delays compared to other ETL tools.
There is a lack of adequate connectors and native support for modern databases and cloud solutions, making data integration challenging.
Technical support is criticized for slow responses and insufficient problem-solving skills, causing frustration and hindered performance.
Documentation quality has declined, with missing critical information since Hitachi's acquisition, making it difficult for users to navigate the application effectively.
Stability concerns arise with frequent freezing and data migration issues, particularly when working with AS400 DB2 and other databases.
 

Pentaho Data Integration and Analytics Pros review quotes

Michelle Lawson - PeerSpot reviewer
Principal Software Engineer at a tech vendor with 10,001+ employees
Nov 30, 2025
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.
Adrián Moreiras - PeerSpot reviewer
Data Analyst at Telefonica Digital
Feb 18, 2026
When I started doing it and did the migration so that all that ETL process would be done in Pentaho Data Integration and Analytics, I reduced the processing time from two and a half hours per run to seven minutes.
AmolDhormare - PeerSpot reviewer
Data Integration Developer at a tech services company with 1,001-5,000 employees
Dec 9, 2025
Pentaho Data Integration and Analytics has positively impacted my organization by saving costs, managing large data sets, and integrating multiple sources.
Learn what your peers think about Pentaho Data Integration and Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
AS
Senior Data Engineer at a financial services firm with 10,001+ employees
May 28, 2026
The best features Pentaho Data Integration and Analytics offers are friendly user interfaces and ease of use, which makes it the best way for data integration.
Jayakrishnanmg MG - PeerSpot reviewer
Data architect at a tech vendor with 10,001+ employees
Nov 29, 2025
Pentaho Data Integration and Analytics has had a notably positive impact on my organization, enabling us to complete several projects efficiently.
reviewer2787603 - PeerSpot reviewer
Data engineer at a educational organization with 1,001-5,000 employees
Dec 12, 2025
Pentaho Data Integration and Analytics positively impacted my organization by organizing data that was scattered across many different databases and APIs, reducing a lot of manual work and centralizing it into one data warehouse.
Alberto Pedro - PeerSpot reviewer
Founder-CEO at Ubuntu Analytica
Dec 12, 2025
Since we started using Pentaho Data Integration and Analytics, many of our manual tasks have become automatic, and we have increased our time for productive things.
JuanCarlosMartinezLara - PeerSpot reviewer
Project Manager at Laberit
Dec 9, 2025
Pentaho Data Integration and Analytics is a great solution to accomplish big things in a very short time.
JH
Data Architecture and Engineering Specialist at coprocenva
Dec 3, 2024
I find the drag and drop feature in Pentaho Data Integration very useful for integration.
Aqeel UR Rehman - PeerSpot reviewer
BI Analyst at a computer software company with 51-200 employees
Nov 28, 2024
Pentaho Data Integration is easy to use, especially when transforming data.
 

Pentaho Data Integration and Analytics Cons review quotes

Michelle Lawson - PeerSpot reviewer
Principal Software Engineer at a tech vendor with 10,001+ employees
Nov 30, 2025
The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.
Adrián Moreiras - PeerSpot reviewer
Data Analyst at Telefonica Digital
Feb 18, 2026
For managing very large volumes of data, Pentaho Data Integration and Analytics is not the best tool, but it is in a good position to handle millions of records.
AmolDhormare - PeerSpot reviewer
Data Integration Developer at a tech services company with 1,001-5,000 employees
Dec 9, 2025
In terms of improvements, while creating on a remote service, we face challenges related to limited memory, which calls for optimization.
Learn what your peers think about Pentaho Data Integration and Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
AS
Senior Data Engineer at a financial services firm with 10,001+ employees
May 28, 2026
To improve Pentaho Data Integration and Analytics, I suggest developing capabilities for cloud-based solutions instead of being solely on-premises.
Jayakrishnanmg MG - PeerSpot reviewer
Data architect at a tech vendor with 10,001+ employees
Nov 29, 2025
When dealing with substantial data volumes from cloud systems, performance can become an issue; even using the Enterprise Edition, the time required for executing particular pipeline tasks is notably high compared to other ETL tools such as ADF, DataBricks, or SSIS.
reviewer2787603 - PeerSpot reviewer
Data engineer at a educational organization with 1,001-5,000 employees
Dec 12, 2025
One thing I wish was better about Pentaho Data Integration and Analytics is its performance, as it sometimes gets intensive on the CPU standpoint, taking a lot of memory in some cases, especially when dealing with big data sets.
Alberto Pedro - PeerSpot reviewer
Founder-CEO at Ubuntu Analytica
Dec 12, 2025
Regarding the features, I find many issues using Pentaho Data Integration and Analytics when working with different environments, especially development environments and production environments, where I have faced many issues working with two environments.
JuanCarlosMartinezLara - PeerSpot reviewer
Project Manager at Laberit
Dec 9, 2025
I think Pentaho Data Integration and Analytics needs additional plugins for the market, and for some specific tasks it is very difficult.
JH
Data Architecture and Engineering Specialist at coprocenva
Dec 3, 2024
While Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle.
Aqeel UR Rehman - PeerSpot reviewer
BI Analyst at a computer software company with 51-200 employees
Nov 28, 2024
I experience difficulties when handling millions of rows, as the data movement from one source to another becomes challenging.