38 reviews

Pentaho

Data integration & business analytics platform

4.3 /5 (38 reviews) Write a Review!
Overall rating
4.3
/
5
Value for Money
4.5
Features
4.4
Ease of Use
4.1
Customer Support
3.8
92% recommended this app
38 reviews
Enrico P.
Industry: Farming
Company size: 10,000+ Employees

Nice surprise

Used Daily for 1+ year
Reviewed on 9/1/2020
Review Source: Capterra

The tool allows the creation of complex ETL projects in a quick way and save time to produce valuable solution for the company.

Pros

Data Integration allows the build of such a complex ETL projects in a quick way, it's very powerful. Being an open source software allows the user to always find hints over the web

Cons

Issue log reports not really clear the error/s occurring and the troubleshooting results sometimes difficult.
Scheduling

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 8.0/10

Verified Reviewer

Practical, versatile and objective

Used Weekly for 2+ years
Reviewed on 11/3/2018
Review Source: Capterra

Fast execution of ETL processes in the case of massive data migration with a very low margin of error

Pros

-Automate the steps for execution
- It has a friendly graphic environment
- Easy to use
- Wide range of tools

Cons

-High basic requirements for execution.
- lack of detailed comments in error messages.
-It does not have documentation in Spanish language.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 8.0/10

Hasin A.
Industry: Computer Software
Company size: 2-10 Employees

I love the out of the box visualization templates!

Used Weekly for 2+ years
Reviewed on 15/12/2018
Review Source: Capterra

I really like using it but chose to use other apps like tableau due to lack of features.

Pros

Pentaho makes it really easy to generate some complex data driven visualizations.

Cons

Pentaho doesn't have a lot of options for pulling data from public APIs.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 7.0/10

Anastasia P.
Industry: Information Technology & Services
Company size: 501-1,000 Employees

Data integrator for successful projct implementation

Used Weekly for 1-5 months
Reviewed on 30/8/2020
Review Source: GetApp

Pentaho is well organized for combining data together from different sources. You can make different kind of analyses and reports based on that.

Pros

Very good tools for visualisation of data. Dashboards are very easy to develop. Easy to integrate with third-party tools.

Cons

Takes some time to understand how it works. Interface is not intuitive. If you want to solve the problem by yourself there is no much information how to do that even with a very small problems.

Rating breakdown

Ease of Use

Likelihood to recommend: 8.0/10

Rohit V.
Industry: Computer Software

Requires training before actual use

Reviewed on 7/10/2015
Review Source: SoftwareAdvice

Pros

Pentaho Data Integration has lot of functions to fulfill the requirements. Functions dealing with running shell script to creating and reading from Excel spreadsheets were quite useful for creating an ETL flow.

Cons

Requires the training to actually understand the product. It is hard to figure out several aspects like declaring variables (global) within the product.

Rating breakdown

Ease of Use

Likelihood to recommend: 6.0/10

Tushar K.
Industry: Primary/Secondary Education

Its a great Experience.

Reviewed on 3/11/2015
Review Source: SoftwareAdvice

Pros

This product has good features including data mining, integration. This product also has features for data reporting. Learning curve for the product is less.

Cons

Not Really. I don't think there is anything I dislike. This product has all good features.

Rating breakdown

Ease of Use

Likelihood to recommend: 9.0/10

Henrik D.
Industry: Information Technology & Services
Company size: 2-10 Employees

Rating only

Reviewed on 4/11/2016
Review Source: GetApp

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Michelle W.
Industry: Civic & Social Organization
Company size: 51-200 Employees

Pentaho Review

Used Weekly for 2+ years
Reviewed on 4/4/2018
Review Source: SoftwareAdvice

Pros

Once you understand the basics of this program it is easy to use. The bonus with this program is that if someone write a report, they can share the script with you. The updated 6.1 version is definitely an improvement.

Cons

If you are not at all familiar with writing script, this program can be very challenging. No real user manuals are included.

Rating breakdown

Ease of Use

Likelihood to recommend: 8.0/10

Yinghua H.
Industry: Financial Services

Pentaho is a user-friendly open source ETL tool

Reviewed on 5/12/2014
Review Source: SoftwareAdvice

Pros

I like its ease of use; it is very easy to build an ETL pipeline after the initial learning curve. I also like the variety of modules. There are a lot of powerful modules, and you will mostly find the module you want. User-defined code is very flexible; it's possible and very easy to plug in user-defined Java code. When there is no module implemented for desired function, this feature comes handy. Multithreading is also easy. The transformation can be set to run multiple copies in parallel.

Cons

Occasionally, Pentaho Spoon (GUI) crashes, and a restart is required.

Rating breakdown

Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Naresh S.
Industry: Health, Wellness & Fitness
Company size: 5,001-10,000 Employees

cool tool for your web app

Used Weekly for 6-12 months
Reviewed on 13/12/2016
Review Source: Capterra

I was impressed with the ability to integrate this into an existing web app. It allowed our users to start looking at operational data and learning from it.

Pros

It provided an intuitive interface for most advanced users.

Rating breakdown

Ease of Use

Likelihood to recommend: 8.0/10

Sumant M.
Industry: Primary/Secondary Education

Great business product. Easy to use

Reviewed on 2/11/2015
Review Source: SoftwareAdvice

Pros

Great analytics and results are very useful. Provides good insight of the business.

Cons

Nothing much to dislike, in fact haven't seen so many applications supported by a single software

Rating breakdown

Ease of Use

Likelihood to recommend: 9.0/10

Dalton S.
Industry: Transportation/Trucking/Railroad
Company size: 51-200 Employees

Riding a Wild Horse - Community Edition

Used Daily for 2+ years
Reviewed on 18/4/2017
Review Source: SoftwareAdvice

Pros

Many features.
I like to use the reporting PRD, I think that it is the best.
I use Spoon/Kettle that is a ETL tool to process data.

Cons

Many bugs. Maybe is because of Community Edition.
We have many difficult to install in cloud.
The layout of some report that run in developing, don't run in production.

Rating breakdown

Value for Money
Ease of Use

Likelihood to recommend: 10.0/10

Verified Reviewer
Industry: Financial Services
Company size: 51-200 Employees

Gives me the ability to use clicks instead of code.

Used Monthly for 2+ years
Reviewed on 2/2/2018
Review Source: Capterra

Pros

Penatho brings a visual interface to processes which would traditionally only be accomplished by many, many lines of code (which it can also do). Many powerful inputs from servers, software, and CRM systems. It also has very detailed error handling, which makes it easy to troubleshoot.

Cons

Support is mostly wiki/community based, with instructions for particular steps being lacking, outdated, or missing completely. Outputs could be simplified as well, with even a basic CSV output being slightly more complex than it should be, compared to other steps.

Rating breakdown

Value for Money
Ease of Use
Customer Support

James W.
Industry: Legal Services
Company size: 11-50 Employees

Saves me not only hours, but DAYS

Used Daily for 6-12 months
Reviewed on 23/2/2017
Review Source: SoftwareAdvice

Pros

Pentaho has nice schema browsing features whereby one not need know anything about the underlying schema in order to design a transformation. Automatic multi-threading by default.

Cons

When outputting to a table, Talend has an option to Drop if exists, and create. Pentaho has a Truncate [prior to load], but no option create the table as part of the data flow nor an option to drop an existing table.

Rating breakdown

Value for Money
Ease of Use

Likelihood to recommend: 10.0/10

Ritchea A.
Industry: Computer Software
Company size: 501-1,000 Employees

Best Data integration and business analytics tool

Used Weekly for 2+ years
Reviewed on 29/5/2018
Review Source: SoftwareAdvice

Best product for reporting and analyzing.

Pros

Best reporting tool.Features like data reporting, integration, data mining and ETL.
Provides easy and good insights of business.
Provides intuitive interface for most advanced users

Cons

Sometimes Pentaho Spoon(GUI) crashes.sharing and collaboration capabilities need to be enhanced Other all features are really good.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Luigi S.
Industry: Computer Software
Company size: 11-50 Employees

An easy BI tool with a POWERFULL ETL inside

Used Monthly for 1+ year
Reviewed on 10/5/2018
Review Source: SoftwareAdvice

Pros

Pentaho BI Solution is nomilly a BI Open Source solution that can compete with the most important players of this area.
Pentaho is easy to manage and has a powerfull ETL inside that can be managed itself as a product.

Cons

The "Open Source Philosophy" is not away true.... I mean that if you want a full support from Pentaho it will be not-so-cheap

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Ashutosh C.
Industry: Computer Software

Very ergonomic ETL tool

Reviewed on 3/11/2015
Review Source: SoftwareAdvice

Pros

Really helps to solve complex business solutions with its cool features and like their contribution to open source.

Cons

Its a great tool to use, nothing to dislike about the product.

Rating breakdown

Ease of Use

Likelihood to recommend: 9.0/10

Ummar H.
Industry: Higher Education
Company size: 1,001-5,000 Employees

Pentaho is integrated set of tools for business intelligence

Used Monthly for 6-12 months
Reviewed on 17/5/2018
Review Source: Capterra

I have transformed multiple databases from different sources and formats into one single format and recognizable database set. After single database operation, I need to summarize report for that purpose i used Pentaho report designer tool to summarize and design report.

Pros

Data in Pentaho can be easily import from nearly any type of source including .csv, excel etc to create single report.

Cons

Pentaho itself is too much resource hungry as compared to other BI softwares. Configuration after installation is required that will be difficult for non-techies.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Gaurav G.
Industry: Computer Software
Company size: 51-200 Employees

Pentaho review

Used Weekly for 1-5 months
Reviewed on 8/12/2016
Review Source: SoftwareAdvice

Pentaho features pixel-perfect reporting, subreports, parameterized reports, and OLAP. The OLAP tools let you perform ad-hoc views, reports, and views through MDX queries. Pentaho puts more effort into data integration, ETL, and workflow automation.

Pros

· Very powerful integrated tools
· Better user interface
· Best report design wizard
· Fastest growth and improvement
· Better dashboard capabilities

Cons

· Doesn’t seem to have a wizard for creating charts
· Weaker support community

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Victor S.
Industry: Graphic Design
Company size: 2-10 Employees

Pentaho Open Source

Used Monthly for 1+ year
Reviewed on 5/11/2019
Review Source: SoftwareAdvice

Pros

Simply the best BI on the market and still for free, perfect

Cons

I have not reported any issues with my use

Rating breakdown

Ease of Use

Likelihood to recommend: 10.0/10

Jason S.

customization is key

Reviewed on 26/2/2017
Review Source: Capterra

Provides much-appreciated flexibility for us to customize KPI reports as well as client reports that we don't offer on platform.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Sudhakar K.
Industry: Computer Software

Sudhakar from VMware

Reviewed on 3/11/2015
Review Source: SoftwareAdvice

Pros

Features like data reporting, integration, data mining and ETL capabilities

Cons

Nothing, Everything looks good to me. All features meet expectations.

Rating breakdown

Ease of Use

Likelihood to recommend: 10.0/10

Rajesh B.
Industry: Computer Software
Company size: 51-200 Employees

Easy reporting and data mining tool

Used Monthly for 1-5 months
Reviewed on 29/1/2019
Review Source: SoftwareAdvice

Best to consider for data mining.

Pros

we can create reports very easily and its very easy to manage. we can provide information in more informational way to our customers.

Cons

This is easy to use but hard to integrate ,use is limited in many cases and not for every application.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Felix F.
Industry: Management Consulting
Company size: 2-10 Employees

Once you understand the basics of this program it is very, but very easy to use

Used Daily for 1+ year
Reviewed on 22/5/2018
Review Source: SoftwareAdvice

Pros

"higher visual interface to processes, has a good number of functions (and very easy to understand) for data reporting, integration, data mining and ETL.. very simple but effective Big data transform

You can build many dimensional model and load the results of the transformation into a database to develop any report whit low margin of error through a dimensional model and load the results of the transformation into a database to develop specialized reports , low margin of error-Automate the steps for execution"

Cons

Its a great tool to use, nothing to dislike about the product. Nothing to dislike, everything is good. All the features are really good.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Verified Reviewer
Company size: 201-500 Employees

The best tool for data integration

Used Daily for 6-12 months
Reviewed on 5/10/2017
Review Source: Capterra

Pros

Ease of use and abundant features to get things done. Helps a lot in filling the various gaps in data sources.

Cons

Not so user friendly, takes sometime for new user to get around the application and figure out the various tricks and tools available

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10