Pentaho Software


 

Pentaho is a business intelligence system designed to help companies make data-driven decisions, with a platform for data integration and analytics. The platform includes extract, transform, and load (ETL), big data analytics, visualizations, dashboards, reporting, data mining, and predictive analytics.

Pentaho’s data integration functionality allows users to find, manage, and combine data from multiple sources, including native support for analytic databases, Hadoop, and NoSQL. The system can integrate with partners like Melissa Data and Human Inference.

Pentaho is also suitable for embedding or white labeling visual analytics as part of third-party Software as a Service (SaaS)/software applications as it is data agnostic. The application can be rebranded and customized based on open standards and architecture.

The software offers interactive business analytics tools like visual analysis and dashboards, as well as flexible reporting solutions. Predictive analytics offered by the system includes machine learning algorithms, tools for processing data and the capability to import third-party models with PMML.

Pentaho helps users translate big data into insights within a singular platform. Users have access to a complete spectrum of data from different sources with the system’s adaptive big data layer, which takes the source of the data into account. The software is built on an open architecture and can be integrated with multiple systems. Pentaho is available for a limited period free trial.

 

Pentaho - Homepage
 
  • Pentaho - Homepage
    Homepage
  • Pentaho - Dashboard
    Dashboard
  • Pentaho - EMEA sales dashboard
    EMEA sales dashboard
  • Pentaho - Predictive plugin
    Predictive plugin
  • Pentaho - PDI transformations
    PDI transformations
  • Pentaho - Vendor sales report
    Vendor sales report
Supported Operating System(s):
Mac OS, Web browser (OS agnostic), Windows 8, Windows 10

25 Reviews of Pentaho

 

Start your review of Pentaho

Click to start
https://www.softwareadvice.com/bi/pentaho-review/
Software Advice Reviews (15)
More Reviews (10)

Showing 1-15 of 15

Michelle from Central Kansas Foundation
Specialty: Healthcare / Social Services
Number of employees: 51-200 employees Employees number: 51-200 employees

April 2018

April 2018

Pentaho Review

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
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.

Review Source
 
 

Juan Felipe from Casa Garcia
Specialty: Software / Technology
Number of employees: 201-500 employees Employees number: 201-500 employees

March 2018

March 2018

A great data analysis tool

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

personally I think it is a very powerful tool, powerful, very robust and also free

Pros

A very well designed platform, of great cost benefit, as well as the integration and reports, even better than when we analyze the costs,
Pentaho is a free tool, incredibly, because when you work on it, you realize the robustness by handling a lot of information in just seconds

Cons

In addition to its great design, the learning curve is quite high, and its platform is not very intuitive

Review Source
 
 

Gabriel from Poli Junior
Specialty: Software / Technology
Number of employees: 11-50 employees Employees number: 11-50 employees

March 2018

March 2018

Very intuitive

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

It is intuitive for beginners, what makes it easy and quick to learn. Also, it's a free platform, and it has one large community.

Cons

The bugs are usually not so easy to solve, and the errors shown sometimes don't give you a clue of what is wrong.

Review Source
 
 

Victor from waytoweb.com.br
Specialty: Software / Technology
Number of employees: 2-10 employees Employees number: 2-10 employees

November 2017

November 2017

Pentaho is amazing...

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

It's a great platform, congratulations ...
is the only one compatible with the bank I use, only a more robust documentation is missing.

Pros

The only BI software that is compatible with Firebird SQL, I have not found any other compatible BI.

Cons

Particularly I found it difficult to start learning, the documentation regarding the data integration (spoon) is scarce.

Review Source
 
 

Kavan from NA
Specialty: Software / Technology
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

June 2017

June 2017

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

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

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

 
 

Dalton from Rentcars.com
Specialty: Travel, Transportation & Logistics
Number of employees: 51-200 employees Employees number: 51-200 employees

April 2017

April 2017

Riding a Wild Horse - Community Edition

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Value for Money

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.

 
 

James from Legal Server
Specialty: Legal
Number of employees: 11-50 employees Employees number: 11-50 employees

February 2017

February 2017

Saves me not only hours, but DAYS

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Value for Money

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.

 
 

Gaurav from University of Illinois at Chicago
Specialty: Software / Technology
Number of employees: 51-200 employees Employees number: 51-200 employees

December 2016

December 2016

Pentaho review

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

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

 
 

Ashutosh from SJSU
Specialty: Software / Technology

November 2015

November 2015

Very ergonomic ETL tool

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

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

Likes Least

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

Recommendations

It is very easy to learn and has good support service.

 
 

Tushar from SJSU
Specialty: Education

November 2015

November 2015

Its a great Experience.

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

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

Likes Least

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

Recommendations

I would definitely recommend this product to other students specially if they are working on big data related projects. Really useful features in product and easy to use for new user.

 
 

Sudhakar from VMware
Specialty: Software / Technology

November 2015

November 2015

Sudhakar from VMware

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

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

Likes Least

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

Recommendations

Use it for real-time business analytics. All your data can be analyzed properly.

 
 

Sumant from San jose State University
Specialty: Education

November 2015

November 2015

Great business product. Easy to use

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

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

Likes Least

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

Recommendations

Services they provide and the results are astonishing !

 
 

Gaurav from SJSU
Specialty: Education

October 2015

October 2015

Good business analytics tool

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

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

Likes Least

nothing to dislike, everything is good. All the features are really good.

Recommendations

Must use for business analytics related operations. Good and very helpful tool for analytics related to operations.

 
 

Rohit from Intuit
Specialty: Software / Technology

October 2015

October 2015

Requires training before actual use

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

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.

Likes Least

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

Recommendations

Very useful for enterprises, since Pentaho provides active support in case of software issues.

 
 

Yinghua from Card.com
Specialty: Banking & Financial Services

December 2014

December 2014

Pentaho is a user-friendly open source ETL tool

Ease-of-use

Functionality

Product Quality

Customer Support

Likes Best

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.

Likes Least

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

Recommendations

It is easier to learn from examples. Pentaho has examples with the installation.

 
 
 
Showing 1-10 of 10


April 2018

April 2018

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

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

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.

Review Source: Capterra
 

Sara Natalie from Fondo de Compensación Interterritorial

April 2018

April 2018

I love this tool, because it has minimized data preparation time by filtering the most interesting d

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Represents the solution to meet the needs of extraction, manipulation, validation and data loading from multiple sources of origin and in different environments can solve many problems. For the creation of the Dimensions Tables. Transformation of these data and Upload of that data in another site.

Pros

It allows to extract the information from an OLTP database, transform the information through a dimensional model and load the results of the transformation into a database to develop specialized reports which Pentaho also has. It includes tools to perform queries, generate reports and reports, interactive analysis, dashboards, extraction, transformation and data loading, data integration.

Cons


It requires a large investment, because its correct implementation is not an easy task and these systems consume many resources.

Review Source: Capterra
 

Stewart from Publicis Media
Number of employees: 10,000+ employees Employees number: 10,000+ employees

March 2018

March 2018

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

Ease-of-use

Functionality

Product Quality

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
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.

Review Source: GetApp
 


March 2018

March 2018

Practical, versatile and objective

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

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.

Review Source: Capterra
 


February 2018

February 2018

Gives me the ability to use clicks instead of code.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
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.

Review Source: Capterra
 


October 2017

October 2017

The best tool for data integration

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
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

Review Source: Capterra
 

Jason from MemberPlanet, LLC

February 2017

February 2017

customization is key

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

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

Review Source: Capterra
 

naresh from saint elizabeth healthcare
Number of employees: 5,001-10,000 employees Employees number: 5,001-10,000 employees

December 2016

December 2016

cool tool for your web app

Ease-of-use

Functionality

Product Quality

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality

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.

Review Source: Capterra
 

John Wisani from SkyLimit IT Solutions
Number of employees: 2-10 employees Employees number: 2-10 employees

January 2018

January 2018

Product Quality
Quality
Source: GetApp
 

Henrik from pr3tium

November 2016

November 2016

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Support
Source: GetApp