Pentaho

Pentaho

Score 8.1 out of 10
Pentaho

Overview

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.
Read more

Recent Reviews

Pentaho - Yay or Nay?

6 out of 10
November 04, 2016
I worked in a small-size private consulting firm that used Pentaho for analytics and reporting firm-wide. It catered to clients in a broad …
Continue reading
Verified User
Consultant
Read all reviews

Popular Features

View all 28 features
  • Multi-User Support (named login) (21)
    9.1
    91%
  • Role-Based Security Model (20)
    8.8
    88%
  • Formatting capabilities (20)
    8.4
    84%
  • Publish to PDF (20)
    7.7
    77%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Pentaho, and make your voice heard!

Record a review
Return to navigation

Pricing

View all pricing
Pentaho

Pentaho

N/A
Unavailable

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

47 people want pricing too

Alternatives Pricing

Microsoft Power BI

Microsoft Power BI

$9.99
per month
What is Microsoft Power BI?

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

SAP Analytics Cloud

SAP Analytics Cloud

$36
per month per user
What is SAP Analytics Cloud?

The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…

Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

8.6Avg 8.1

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

8.7Avg 8.0

Report Output and Scheduling

Ability to schedule and manager report output.

8.8Avg 8.3

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for pattern and outliers and the ability to represent the data visually.

8.4Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

8.8Avg 8.5

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

8.6Avg 7.9

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

8.6Avg 7.9
Return to navigation

Product Details

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Pentaho Integrations

Pentaho Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Reviewers rate Responsive Design for Web Access highest, with a score of 9.6.

The most common users of Pentaho are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

 (131)

Attribute Ratings

Reviews

(1-25 of 32)
Popular Filters
Companies can't remove reviews or game the system. Here's why
June 28, 2022

Secured & Safest ETL and Reporting tool

Harsh Gangwar | TrustRadius Reviewer
Harsh Gangwar
Assistant Engineer
Accenture (Airlines/Aviation, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Likelihood to Recommend
I used this tool for a complex ETL problem where we fetched data from APIs, SQL, and Oracle. We merged and created a complex job which was able to fulfill our requirements and was able to make better business decisions based on the trends from the data. Sometimes, it's very hard to optimize jobs if you didn't work on this or similar ETL tools in past but I enjoyed it and made the best out of it.
June 24, 2022

Trust Pentaho to deliver a smooth data mining experience

Verified User
Analyst in Sales
Logistics & Supply Chain Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho is very well suited to perform data extraction & data mining from various cloud storage & transform that data using various available data models. However, the software struggles when it comes to visualizing the extracted data in an appealing manner & can be difficult for end-users to get an understanding of data tables created using those models.
April 12, 2022

Best for Reporting and Dashboard

Verified User
Analyst in Information Technology
Information Technology & Services Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Likelihood to Recommend
We did report designing for the market requirement. It was well suited to the requirement because of its apt feature. Also, both Pentaho report designer and Pentaho data integration are very good in terms of high flexibility and compatibility. Also, in terms of cost, any small organization can utilize the service.
February 04, 2022

Data integration made easy

Rafael Grandizoli | TrustRadius Reviewer
Rafael Grandizoli
Gerente de Operações
MUV (Marketing & Advertising, 11-50 employees)
Score 8 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho requires less technical skills than other solutions to start integrating and creating complex data manipulations and preparation. By having logical skills you can just start to 'drag and drop' some boxes, connect them, and create a data pipeline, step by step.
May 07, 2021

Using the Pentaho tools to solve ETL challenges

Verified User
Engineer in Engineering
Information Technology and Services Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Any company looking to solve ETL, data science, data mining problems can solve these issues with the Pentaho tools.

From a very close perspective, I know that different industries, such as the leads generation industry, which operates with other sectors such as loans, medical insurance, and mortgage, can benefit significantly from using the Pentaho tools to perform data extraction and refine records.

Other industries such as universities use the Pentaho tools for different kinds of investigations.

Banking industries also use the Pentaho tools to perform internal data mining operations, which, as you can imagine having so much data is challenging.

Perhaps if you are a single developer trying to extract data for some machine learning process, using the Pentaho tools could be a little too much, maybe overcomplicated when some spreadsheets or using R or Python could probably get the job done. Still, complex or straightforward data transformations could suffice for the job.
March 23, 2021

Integrate and connect all data sources with Ai engineering in the cloud environment

Ali Kazempour | TrustRadius Reviewer
Ali Kazempour
Information Technology Adviser
Information Technology Adviser (Information Technology & Services, 1-10 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Integration Pentaho with Hitachi Vantara is a successful idea, it has increased the speed of work in all departments of the organization. We recommend Hitachi Pentaho Enterprise Edition (Lumada DataOps Suite) to our customers in all industries, information technology, human resources, hospitals, health services, financial companies, and any organization that deals with information and databases and we believe Pentaho is one of the good options because it's agile, safe, powerful, flexible and easy to learn.
March 02, 2020

My Experience with Pentaho data integrator

zahit bogus | TrustRadius Reviewer
zahit bogus
Business Intelligence Consultant
EMO A.Åž (Information Technology & Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
The Pentaho Data Integration ETL tool runs successfully on systems derived from both Windows and Unix. When designing a data warehouse, we can create ETL packets both at the Stage layer and at the DWH layer. There are many components for ETL design. We can run packages at certain time intervals through the Windows Task Scheduler. Since Pentaho Data Integration is an open-source application, it can be developed in applications to be integrated with PDI (Pentaho Data Integration). This allows you to manage the scheduler process through a separate application.
October 21, 2019

Robust platform that needs some refresher to compete with more modern tools

Verified User
Manager in Information Technology
Utilities Company, 10,001+ employees
Score 6 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho is well suited for bringing together data from multiple data sources in order to perform analyses and to create reports.

If you want to create very nicely looking interactive graphs using the latest web technologies, there might be other tools that are more suited. We have also seen performance problems with large amounts of data, but it is not certain if this only was the fault of Pentaho but could also be the infrastructure around.
June 28, 2018

A great tool, but falls under the shadow of the larger players.

Verified User
Manager in Finance and Accounting
Consumer Goods Company, 10,001+ employees
Score 6 out of 10
Vetted Review
Verified User
Likelihood to Recommend
The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
March 19, 2018

Pentaho for your business

Ilham AB | TrustRadius Reviewer
Ilham AB
Senior Solution Architect
Three. (Telecommunications, 501-1000 employees)
Score 8 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho will work great to embed analytic content with full features of Machine Learning capabilities. It supports many machine-learning frameworks and can be easily integrated. So, you also can connect with many data sources and have no worries about it. In our case, we are using it to help us create many day-to-day jobs and transformations that our internal users need. But to achieve this, we need to train our team to be able to understand the main concepts of how this software works.
February 23, 2018

Pentaho can be a great solution for a company

Mihaela Olariu | TrustRadius Reviewer
Mihaela Olariu
Business Intelligence Functional Coordinator
ELDON Enclosures (Business Supplies and Equipment, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
  • Operational reports, big lists of COs, POs, DOs, master information and details. Bursting reports by email and scheduling tasks are interesting and very useful.
  • Complex aggregations are useful to use in cross tabs and calculated functions in the tables. I would recommend a new tool if the purpose is dashboards, but they still can be created in Pentaho as well.
June 30, 2017

Pentaho was just OK as an OEM solution

Verified User
Manager in Product Management
Computer Software Company, 51-200 employees
Score 5 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Overall as an OEM vendor of analytics, I would say it was about average. They did help us get to market sooner than if we developed everything in-house, but I felt the dashboards were pretty ugly and I wouldn't say I was super impressed. I found the Analyzer OLAP tool to be very useful and that part would have been harder to develop in-house, but I would skip the dashboards next time and go straight to developing those in-house, which is what we ended up with in the end.
November 04, 2016

Pentaho - Yay or Nay?

Verified User
Consultant in Information Technology
Accounting Company, 10,001+ employees
Score 6 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho is well suited to small - mid size firms that have specific reporting needs. It is less likely to benefit firms that already have data analytics capabilities built into multiple platforms as Pentaho is not easy to integrate with other analytics platforms. There isn't enough documentation available online, however, customer support is easy to reach.
November 03, 2016

Pentaho: A great DW/BI soultion

Nikhil Karkare | TrustRadius Reviewer
Nikhil Karkare
Business Intelligence Analyst/Developer
CD-adapco (Computer Software, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Well suited scenarios: When we need to deal with any type of RDBMS, from data input to the data loading, Pentaho is super fast. It has many bulk loaders available too. Dealing with the tables is the specialty of Pentaho.

Less Appropriate scenarios: When you have a star schemas with the bridge tables or snow-flake schemas, you will need a lot of additional work to be done in Pentaho apparently. Also, dealing with the files is not bad, but it should be improved.
** My review is for Pentaho 5.4.0.8 or previous releases.
November 02, 2016

Rookie Pentaho review from an ETL veteran

Verified User
Consultant in Information Technology
Computer Software Company, 201-500 employees
Score 6 out of 10
Vetted Review
Verified User
Likelihood to Recommend
It is well suited for developers who may not be adept at strict coding, but have experience with GUI development. It is also better for rather simpler ETL, as the GUI interface has natural restrictions that make complex ETL problems challenging to solve. It may also be well suited for companies on a budget, as the free version still has enough features to be reasonably useful.
June 27, 2016

Pentaho - Enhancing our ETL Capabilities

Gordon Yeh | TrustRadius Reviewer
Gordon Yeh
Remedy Architect
Apotex Inc. (Pharmaceuticals, 10,001+ employees)
Score 8 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Open sourced ETL tool to help corporations load data. Very easy to learn but you have to take the time to do it! Lots of reading and exploring by yourself and there are some free jobs and transformations online to help you get started. However, we have heard and seen cases with the jobs just do not load the data entirely; it'll have issues after 50K records.
February 26, 2016

Pentaho- An adequate BI solution for users on a budget!

Ivan Miller | TrustRadius Reviewer
Ivan Miller
Business Intelligence Engineer
Experticity (Marketing and Advertising, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho is very well suited for organizations looking for end-to-end BI solutions without wanting to break the bank--particularly because the community edition has most of the functionality necessary to get you started, and it's free. Honestly though, if you have deep pockets there are probably more complete solutions out there in terms of functionality
February 23, 2016

Pentaho powerful backend BI tooling, hit-and-miss data visualization

Jordan Squire | TrustRadius Reviewer
Jordan Squire
Business Intelligence Engineer
Experticity (Marketing and Advertising, 51-200 employees)
Score 8 out of 10
Vetted Review
Verified User
Likelihood to Recommend
As far as generating and maintaining a data warehouse, Pentaho does an excellent job and I would highly recommend it. For analysis and gaining insight into your data, Pentaho is excellent. For visualization, dashboarding, or executive grade reporting it may not be as beautiful or flashy as your clients require.
February 23, 2016

An implementor view on Pentaho tools.

Verified User
Engineer in Information Technology
Computer Software Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Likelihood to Recommend
There are different Pentaho features, and each one has its own specific scenario where it is best suited. Reporting - is for generating boring Excel like reports, with calculations etc. For data visualization reporting is not a [good] tool. PDI is used for creation data transformations, from almost any source of data. But it is very heavy weighted. It has Hadoop and other support. But hand made code runs faster than transformation made in Spoon. And there are some algorithms that can be much easily written manually.
February 16, 2016

One of the best BI solutions for start up companies or those looking for a highly customizable tool.

Anderson L.A. | TrustRadius Reviewer
Anderson L.A.
CTO
RTSC Consultoria Financeira (Investment Management, 1-10 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho is an excellent tool for start ups and where CTOs are willing to invest in staff training Drawback : Takes a bit longer to master Pentaho in relation to the leading BI solutions.
August 19, 2015

Pentaho - Fast and Furious Data Integration

Alex Meadows | TrustRadius Reviewer
Alex Meadows
Senior Business Intelligence Engineer.
Red Hat (Information Technology and Services, 5001-10,000 employees)
Score 9 out of 10
Vetted Review
Verified User
Likelihood to Recommend
PDI is a great alternative to proprietary tools. If your environment is just starting out using ETL tools, definitely look into using PDI. The number of features plus the ability to write flexible dynamic processes allows for much more maintainable code.
June 03, 2015

B.I. made simple. Pentaho rocks!

Sandro Frattura | TrustRadius Reviewer
Sandro Frattura
Database Manager
Online Buddies, Inc. (Internet, 51-200 employees)
Score 8 out of 10
Vetted Review
Verified User
Likelihood to Recommend
If you are an open-source shop, this is a great choice. Also, if your developer has minimal experience with ETL, Pentaho is a great way to go wince it is easy to use. There is also a ton of help in the forums, in you go with Community Edition (i.e. sans support)
March 16, 2015

Pentaho - Jumping On The Band Wagon

Stephanie Dozier | TrustRadius Reviewer
Stephanie Dozier
Business Data Analyst
Centex Systems Support Services (Information Technology and Services, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Pentaho is well suited for an internal environment who needs access to data quickly and offer the data up in a very professional business document. It is not suited for a reporting portal that customers can access via the internet or web. The limited security prevents us from being able to offer our Pentaho UI as a service to our partners and customers.
Return to navigation