Skip to main content
TrustRadius
Pentaho

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

Learn from top reviewers

Trust Pentaho to deliver a smooth data mining experience

Rating: 9 out of 10
June 24, 2022
IncentivizedVetted ReviewVerified User
We use Pentaho to store, collaborate & present data in a more modular form, which in turn helps us in making better business decisions & also allows end-users to navig...
Continue reading
Verified user
Analyst
Pentaho6 years of experience

Best for Reporting and Dashboard

Rating: 10 out of 10
April 12, 2022
Vetted ReviewVerified User
I use Pentaho for reporting and dashboard development. We develop the reports and integrate them with different database sources. It really helps us to achieve our business go...
Continue reading
Verified user
Analyst
Pentaho1 year of experience

Data integration made easy

Rating: 8 out of 10
February 4, 2022
IncentivizedVetted ReviewVerified User
Pentaho is used in my organization, mainly by the IT team, creating processes and routines focused on data ingestion from many sources. We also use Pentaho to create complex E...
Continue reading
Rafael Grandizoli
Manager - Product Management
Gerente de Operações
MUV
Pentaho2 years of experience

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

Rating: 9 out of 10
March 23, 2021
Vetted ReviewVerified User
Information is our company fuel, The information and this software are used in all parts of our company, marketing, and sales, as well as development and research we make bett...
Continue reading
Ali Kazempour
Consultant - Information Technology
Information Technology Adviser
Information Technology Adviser
Pentaho2 years of experience

My Experience with Pentaho data integrator

Rating: 9 out of 10
March 2, 2020
IncentivizedVetted ReviewVerified User
I use the Pentaho Data Integration ETL tool in our enterprise business intelligence projects. I often use the Pentaho tool for data manipulation and data transport. Pentaho pl...
Continue reading
zahit bogus
Consultant - Information Technology
Business Intelligence Consultant
EMO A.Åž
Pentaho2 years of experience
Log in with LinkedIn to see content from your network
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?

151 people also want pricing

Alternatives Pricing

Microsoft Power BI

Microsoft Power BI

$10
per month per user
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 Lumira Discovery

SAP Lumira Discovery

$185
per user
What is SAP Lumira Discovery?

SAP Lumira Discovery is SAP’s data visualization and discovery application. It facilitates data discovery, visualization, and analysis by assisting users with creation of dashboards, infographics, presentations, data facets, tag clouds, and more.

Return to navigation

Product Demos

Pentaho and Hadoop Demo

YouTube

Adempiere Pentaho Demo - Products & Sales figures

YouTube

Agile BI with Pentaho BI Suite Demo

YouTube

Google Analytics (part 1/2) - Pentaho Data Integration Demo

YouTube

PENTAHO DATA INTEGRATION TOOL DEMO

YouTube

Control de Mando (Dashboard) con Pentaho de Matrix CPM Solutions

YouTube
View more demos
Return to navigation

Features

BI Standard Reporting

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

9
Avg 8.1

Ad-hoc Reporting

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

8.7
Avg 8.0

Report Output and Scheduling

Ability to schedule and manager report output.

9.7
Avg 8.3

Data Discovery and Visualization

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

8.1
Avg 8.0

Access Control and Security

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

9.1
Avg 8.5

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

8.3
Avg 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.6
Avg 7.8
Return to navigation

Product Details

What is Pentaho?

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 Customizable dashboards and Report Delivery Scheduling and Multiple Access Permission Levels (Create, Read, Delete) highest, with a score of 9.9.

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 From Top Reviewers

View all reviews
(1-5 of 31)

Using the Pentaho tools to solve ETL challenges

Rating: 10 out of 10
Incentivized
May 07, 2021
Verified User
Engineer in Engineering
Information Technology and Services Company, 10,001+ employees
Vetted Review
Verified User
Pentaho
2 years of experience
Use Cases and Deployment Scope
Before working for Hitachi Vantara, I had experience using the Pentaho Tools for personal projects mainly. I had the chance to work directly with the teams that supported the Pentaho tools, and I can tell with much objectivity that the Pentaho tools are by far one of the best options in the market when it comes to all the ETL processes. Data science requires extracting data from different sources, organizing it, and transforming it according to each necessity. Machine learning is built on top of these concepts, and with the Pentaho tools, you can accomplish most of it. Since I supported the Pentaho tools while working for Hitachi Vantara, my perspective is kind of unique; I can tell that the tools were used to solve internal problems such as integrations with our release tools and some of our agile tools, so the tools were used to enhance the newer versions.

Solving problems such as extracting metadata from thousands of files, organizing this information, and filtering it to create release files, determining how to create meta information files is just an example of the ETL cycle that can be performed with the Pentaho tools.
Pros
  • Open source, the Pentaho tools have a free to use version with a lot of support.
  • Performance. The Pentaho tools can be setup so they process gigabytes of data seamlessly.
  • Support from the open source developer community.
  • Documentation up-to-date.
Cons
  • The web versions of the Pentaho tools are limited to the server component.
  • Worker nodes features are being improved but more documentation and support is always welcome.
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.

Data integration made easy

Rating: 8 out of 10
Incentivized
February 04, 2022
RG
Rafael Grandizoli
Gerente de Operações
MUV (Marketing & Advertising, 11-50 employees)
Vetted Review
Verified User
Pentaho
2 years of experience
View profile
Use Cases and Deployment Scope
Pentaho is used in my organization, mainly by the IT team, creating processes and routines focused on data ingestion from many sources. We also use Pentaho to create complex ETL jobs and prepare data to be used in our data warehouse and reporting platforms that are used by other departments in the company.
Pros
  • Data Integration with (almost) any source
  • ETL jobs
  • Manage and scheduling recurrent process
Cons
  • Report development could be easier
  • Better integration with online repository
  • Native deployment and development environments
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.

Pentaho - Yay or Nay?

Rating: 6 out of 10
Incentivized
November 04, 2016
Verified User
Consultant in Information Technology
Accounting Company, 10,001+ employees
Vetted Review
Verified User
Pentaho
1 year of experience
Use Cases and Deployment Scope
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 range of industries ranging from hospitality to the public sector. The software is easy to learn and has an impressive amount of functionality incorporated. The ETL (Kettle) module is great for generating visualizations and I highly recommend this software to a beginner interested in BI.
Pros
  • User friendly interface
  • Easy and quick report generation
  • Great report customizing features
Cons
  • Heavy software to install
  • Requires licensing to enable all features
  • Difficult to integrate with other servers
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.

My Favorite Data Integration Tool is still Kitchen

Rating: 10 out of 10
November 06, 2014
JG
Julia Gusman
BI Consultant
Altis Consulting (Information Technology and Services, 1-10 employees)
Vetted Review
Verified User
Pentaho
5 years of experience
Use Cases and Deployment Scope
We are a consulting company and implement BI and data warehousing solutions for our clients. I have lead and implemented a number of BI and data warehousing solutions in my current as well as previous role.
Pros
  • The data integration tool is very strong. It is easy to use and very accessible to business users
  • The data integration component provides ability to connect to almost any data source as input as well as output - quick and easy
  • The data integration component allows quick preview of the data in a pivot view type format which enables data analysis at an early stage of development
Cons
  • The BI server front end does not seem to be very appealing to the end users. In my experience the end users wish for a prettier display and easier navigation
  • Schema workbench is not easy to develop with, I know there were some plans of integrating the tool with the data integration component
  • Data integration server does not seem to be as useful. For example, while it provides some source control, the files are only controlled separately one by one. If the developer changes several files at the same time, they cannot commit them all in one go. Often the changes across different files need to be kept in sync.
Likelihood to Recommend
I would definitely recommend the ETL tool but not the server. I would consider the amount of data to be processed, the budget the client is looking to spend, available knowledge and expertise. it seems that there are not that many Pentaho skills on the market and companies are reluctant to implement the product as they are concerned about ongoing maintenance. I would also ask about requirements to integrate with other products or run on the cloud. Being open standards Pentaho integrates nicely with in-house systems.

Pentaho Open Source

Rating: 7 out of 10
June 10, 2014
Verified User
Team Lead in Information Technology
Hospital & Health Care Company, 51-200 employees
Vetted Review
Verified User
Pentaho
1 year of experience
Use Cases and Deployment Scope
I worked for a small company where everything was open source. We used a Postgres database, etc. The tool was used for some minor reporting as it was hard to get the users of this small company to make a change.
Pros
  • For an open source tool the documentation was fairly good and the support reasonable
  • The tool was relatively easy to learn without a lot of training.
Cons
  • We did have some issues getting the automation to work. I believe this was 'Kettle'. Other than that, not too many bugs.
Likelihood to Recommend
How much support will be available? What about software updates?
Return to navigation