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.

Supported Operating System(s):
Mac OS , Web browser (OS agnostic) , Windows 8 , Windows 10

29 Reviews of Pentaho

Showing 1 - 20 of 29

Start your review of Pentaho

Click to start
  • Ritchea from Software Industry

    Specialty: Software / Technology

    Number of employees: 501-1,000 employees

    May 2018

    Best Data integration and business analytics tool

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Felix from corporación Estelio

    Specialty: Consulting

    Number of employees: 2-10 employees

    May 2018

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

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

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Ummar from COMSATS Institute of Information and Technology

    Number of employees: 1,001-5,000 employees

    May 2018

    Pentaho is integrated set of tools for business intelligence

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Luigi from Sansottera SAS

    Specialty: Software / Technology

    Number of employees: 11-50 employees

    May 2018

    An easy BI tool with a POWERFULL ETL inside

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

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Verified Reviewer

    April 2018

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

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Sara Natalie from Fondo de Compensación Interterritorial

    April 2018

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

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    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.

    This review was submitted organically. No incentive was offered
    Review Source: Capterra
  • Michelle from Central Kansas Foundation

    Specialty: Healthcare / Social Services

    Number of employees: 51-200 employees

    April 2018

    Pentaho Review

    Ease-of-use
    Functionality
    Quality
    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Juan Felipe from Casa Garcia

    Specialty: Software / Technology

    Number of employees: 201-500 employees

    March 2018

    A great data analysis tool

    Ease-of-use
    Functionality
    Quality
    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

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Stewart from Publicis Media

    Number of employees: 10,000+ employees

    March 2018

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

    Ease-of-use
    Functionality
    Quality
    Support
    N/A
    Value for Money
    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: GetApp
  • Verified Reviewer

    March 2018

    Practical, versatile and objective

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    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.

    This review was submitted organically. No incentive was offered
    Review Source: Capterra
  • Gabriel from Poli Junior

    Specialty: Software / Technology

    Number of employees: 11-50 employees

    March 2018

    Very intuitive

    Ease-of-use
    Functionality
    Quality
    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Verified Reviewer

    Number of employees: 51-200 employees

    February 2018

    Gives me the ability to use clicks instead of code.

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

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Victor from waytoweb.com.br

    Specialty: Software / Technology

    Number of employees: 2-10 employees

    November 2017

    Pentaho is amazing...

    Ease-of-use
    Functionality
    Quality
    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.

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source
  • Verified Reviewer

    Number of employees: 201-500 employees

    October 2017

    The best tool for data integration

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

    This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
    Review Source: Capterra
  • Kavan from NA

    Specialty: Software / Technology

    Number of employees: 1,001-5,000 employees

    June 2017

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

    Ease-of-use
    Functionality
    Quality
    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

    April 2017

    Riding a Wild Horse - Community Edition

    Ease-of-use
    Functionality
    Quality
    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.

  • Jason from MemberPlanet, LLC

    February 2017

    customization is key

    Ease-of-use
    Functionality
    Quality
    Support
    Value for Money

    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
  • James from Legal Server

    Specialty: Legal

    Number of employees: 11-50 employees

    February 2017

    Saves me not only hours, but DAYS

    Ease-of-use
    Functionality
    Quality
    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.

  • naresh from saint elizabeth healthcare

    Number of employees: 5,001-10,000 employees

    December 2016

    cool tool for your web app

    Ease-of-use
    Functionality
    Quality
    Support
    N/A

    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
  • Gaurav from University of Illinois at Chicago

    Specialty: Software / Technology

    Number of employees: 51-200 employees

    December 2016

    Pentaho review

    Ease-of-use
    Functionality
    Quality
    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

Do you use Pentaho?Write a Review
In just fifteen minutes, the experts at Software Advice can help you narrow down the right software for your organization. Call us for a Free FastStart Consultation: (844) 680-2046