39 reviews

Pentaho

Data integration & business analytics platform

4.3 /5 (39 reviews) Write a Review!

Overall rating

4.3 /5
  • Value for Money
  • Ease of Use
  • Customer Support
  • Features
92%
recommended this app
39 reviews
Dalton S.
Overall rating
  • Industry: Transportation/Trucking/Railroad
  • Company size: 51-200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

Riding a Wild Horse - Community Edition

Reviewed on 18/4/2017

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.

Verified Reviewer
Overall rating
  • Industry: Financial Services
  • Company size: 51-200 Employees
  • Used Monthly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support

Gives me the ability to use clicks instead of code.

Reviewed on 2/2/2018

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.

James W.
Overall rating
  • Industry: Legal Services
  • Company size: 11-50 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 10.0 /10

Saves me not only hours, but DAYS

Reviewed on 23/2/2017

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.

Ritchea A.
Overall rating
  • Industry: Computer Software
  • Company size: 501-1,000 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Best Data integration and business analytics tool

Reviewed on 29/5/2018

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.

Luigi S.
Overall rating
  • Industry: Computer Software
  • Company size: 11-50 Employees
  • Used Monthly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

An easy BI tool with a POWERFULL ETL inside

Reviewed on 10/5/2018

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

Ashutosh C.
Overall rating
  • Industry: Computer Software
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

Very ergonomic ETL tool

Reviewed on 3/11/2015

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.

Ummar H.
Overall rating
  • Industry: Higher Education
  • Company size: 1,001-5,000 Employees
  • Used Monthly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Pentaho is integrated set of tools for business intelligence

Reviewed on 17/5/2018

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.

Gaurav G.
Overall rating
  • Industry: Computer Software
  • Company size: 51-200 Employees
  • Used Weekly for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Pentaho review

Reviewed on 8/12/2016

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

Victor S.
Overall rating
  • Industry: Graphic Design
  • Company size: 2-10 Employees
  • Used Monthly for 1+ year
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 10.0 /10

Pentaho Open Source

Reviewed on 5/11/2019

Pros

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

Cons

I have not reported any issues with my use

Jason S.
Overall rating
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support

customization is key

Reviewed on 26/2/2017

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

Sudhakar K.
Overall rating
  • Industry: Computer Software
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 10.0 /10

Sudhakar from VMware

Reviewed on 3/11/2015

Pros

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

Cons

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

Rajesh B.
Overall rating
  • Industry: Computer Software
  • Company size: 51-200 Employees
  • Used Monthly for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Easy reporting and data mining tool

Reviewed on 29/1/2019

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.

Enrico P.
Overall rating
  • Industry: Farming
  • Company size: 10,000+ Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Nice surprise

Reviewed on 9/1/2020

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

Verified Reviewer
Overall rating
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Practical, versatile and objective

Reviewed on 11/3/2018

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.

Hasin A.
Overall rating
  • Industry: Computer Software
  • Company size: 2-10 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 7.0 /10

I love the out of the box visualization templates!

Reviewed on 15/12/2018

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.

Anastasia P.
Overall rating
  • Industry: Information Technology & Services
  • Company size: 501-1,000 Employees
  • Used Weekly for 1-5 months
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 8.0 /10

Data integrator for successful projct implementation

Reviewed on 30/8/2020

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.

Rohit V.
Overall rating
  • Industry: Computer Software
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 6.0 /10

Requires training before actual use

Reviewed on 7/10/2015

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.

Tushar K.
Overall rating
  • Industry: Primary/Secondary Education
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

Its a great Experience.

Reviewed on 3/11/2015

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.

Henrik D.
Overall rating
  • Industry: Information Technology & Services
  • Company size: 2-10 Employees
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Reviewed on 4/11/2016

Verified Reviewer
Overall rating
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

It is definitely the solution to carry out all the projects successfully!

Reviewed on 19/4/2018

Everything is organized better using this software. It is quite efficient and easy to use...

Pros

This software is wonderful, with it you can obtain performance and scalability. As well as manage and schedule reports. It is very efficient which means that you save a lot in daily reports...

Cons

This software is potentially amazing. Has it all! Your free trial is as complete as the paid version. It's very complete.

Senando B.
Overall rating
  • Industry: Electrical/Electronic Manufacturing
  • Company size: 51-200 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Great partner of IT business analyst

Reviewed on 15/1/2019

Using this kind of software brings ease and accurate data reports that helps the company on decision making

Pros

Easy to use, compatible in many database such as mysql, ms sql server, different type of output to choose such as excel, html, richtext, etc.

Cons

Some version are slow on initializing and fetching data such as Pentaho report designer version 5 and above. Unlike version 3 which has smooth process, that was base on my experience.

Verified Reviewer
Overall rating
  • Industry: Computer Software
  • Company size: 501-1,000 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

One of the best Business Analytics tool out there

Reviewed on 3/11/2018

Pros

This tool can be installed on any operating system. It has a simple interface, so it takes less time to learn.

Cons

The design of the software is pretty old! Needs lot of improvement when compared to its competitors.

Stewart F.
Overall rating
  • Industry: Marketing & Advertising
  • Company size: 10,000+ Employees
  • Used Monthly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 8.0 /10

PDI Community Edition is amazing.....the rest is mud

Reviewed on 20/3/2018

Pros

- Free PDI tool....its free so no discussions with finance
- PDI is actually very effective ETL application with a easy to understand flow
- Community is actually helpful

Cons

- Free BI tool is just slightly easier than building a website from scratch but a lot harder than using any other BI tool.
- You need to know how to hack java to use.
- The paid version does not have competitive pricing for the incremental value.

Kavan D.
Overall rating
  • Industry: Computer Software
  • Company size: 1,001-5,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 7.0 /10

Pentaho, a great open source BI suit with strong community support

Reviewed on 16/6/2017

One of the best opensource BI tool, also well integrated with existing platforms. It will be interesting to see how will it get integrated with fast evolving Big data technologies. Pentaho 7.1 is step in right direction.

Pros

- We mature DI (Data integration) module
- Easy to learn design console (Spoon)
- wide community support
- Very well integrated with different platforms
- Innovating fast in Big data world specially Pentaho 7.1

Cons

- Not very well documented for latest releases one of the reasons is many innovation are happening very fast

Riyaadh K.
Overall rating
  • Industry: Telecommunications
  • Company size: 51-200 Employees
  • Used Other for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

ETL on the fly

Reviewed on 31/10/2018

Pros

Drag and drop functionality makes it easy to create transformations. Able to analyse data from multiple sources quickly and efficiently. Jobs can be scheduled in order to run specific tasks and transformations at a certain time.

Cons

Can take some time to figure out how to use it as there are lots of components involved. Can be a bit slow or run into out of memory issues for bigger queries but upping the virtual memory in the configuration can fix this issue.