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?

152 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 8.0

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 21)

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?

Pentaho: a strong open source BI suite

Rating: 9 out of 10
November 04, 2014
NS
Nathan Smith
Systems Analyst
Olathe Medical Center (Government Administration, 1001-5000 employees)
Vetted Review
Verified User
Pentaho
7 years of experience
Use Cases and Deployment Scope
Pentaho Data Integration was used for a variety of data integration projects, including populating a dimensional data warehouse. Data sources included relational data bases, flat files, and LDAP directories. Pentaho Reporting served reports from a range of data sources to multiple departments with security integrated with Active Directory. The Mondrian OLAP engine delivered pivot tables for slice and dice analysis.
Pros
  • The Pentaho Data Integration tool is extremely versatile. I find it easier to use than comparable tools like SSIS.
  • The reporting engine delivers reports in multiple formats, including Excel and PDF.
  • It is easy for users to subscribe to reports for delivery by email.
  • The report parameterization is very flexible, and I find it easier to use and more versatile than parameterization in Crystal.
Cons
  • If using the community edition, be prepared to invest some effort in learning the product. Documentation can be vague.
  • The new pivot table viewer is part of the enterprise edition. Fortunately there is a nice open source plug in called Saiku that can replace the old, difficult to use jPivot pivot table interface.
  • I wish there were easier ways to audit user activity, especially to see which items have not been accessed for a long time and could be retired.
  • There are not as many people who know how to use Pentaho in the market as there are people proficient in other BI tools. There is a learning curve and design patterns are not necessarily the same from one BI tool to the next.
Likelihood to Recommend
Pentaho provides a rich end to end BI solution. It is highly configurable. The data integration module is an especially useful and powerful. You may need a higher level of IT skills and support to work with Pentaho than you do with other BI tools. It is helpful to have SQL querying skills when creating Penthao reports. Make sure you have resources who are familiar with Pentaho or are able to get training.

A powerful ETL tool which is open source

Rating: 9 out of 10
Incentivized
March 01, 2016
YH
Yinghua Hu
Senior Data Scientist
CARD.com (Financial Services, 11-50 employees)
Vetted Review
Verified User
Pentaho
2 years of experience
Use Cases and Deployment Scope
Pentaho is used as main ETL tool in the data analytics team. It solves the problem of processing and populating financial and ads related data.
Pros
  • Populate relational database
  • Transform and clean data
  • Create periodic job and generate report
  • Aggregate data
Cons
  • It will be helpful to have modules supporting Google Adwords and Facebook API and Twilio API
  • It has "add constant", but does not have "multiply constant" module.
  • Unit transform module
Likelihood to Recommend
Pentaho is well suited for ETL processing and database population. It is less appropriate for visualization and analytics. Key question is the benefit it can bring and the cost and robustness.

Pentaho for Quality Assurance

Rating: 8 out of 10
Incentivized
February 24, 2016
Verified User
Team Lead in Information Technology
Computer Software Company, 501-1000 employees
Vetted Review
Verified User
Pentaho
2 years of experience
Use Cases and Deployment Scope
At our organization we are building a data ware house for data migration and analytics. After researching several options we went for the Pentaho community edition which is an open source tool. Pentaho played big role in the implementation of ETL jobs and QA testing. The features available in Pentaho covered all of our scenarios, plus it allowed us to plug in external jars to use for any unsupported activity.
Pros
  • Pentaho allows for migration from one system to another system without much trouble.
  • Minimum code or almost no code expertise is required. Just get your SQL and Pentaho will do rest.
  • It is difficult to verify millions of rows. But with Pentaho you can do that, this makes the QA task easier.
Cons
  • Pentaho does make comparison of data between two systems fairly easier compared to other systems, but it lags in terms of output you get. The output has a merge difference option which will show a difference transaction only but if you have large data set columns it is not easy to find issues.
  • Date formatting and number formatting is again an issue, both the systems should have the same datatype. It was difficult for us to compare as a new system had updated data types and pentaho failed to compare these.
Likelihood to Recommend

Pentaho is well suited for:

  • Migration of large data.
  • Reading XML file and processing data.
  • QA Testing.
  • Data modeling.
  • Data processing.
It is less appropriate for:
  • DataType validation
  • Reporting

Data Integration with Pentaho Kettle review

Rating: 9 out of 10
December 05, 2014
IS
Itamar Steinberg
CEO
Inflow Systems LTD (Computer Software, 11-50 employees)
Vetted Review
Verified User
Pentaho
7 years of experience
Use Cases and Deployment Scope
I used Pentaho Kettle as a team manager of development and later as a CIO. After that I opened a company that consults and implement business intelligence solutions. We are using Pentaho mostly with the data integration module. I think that of all the modules of Pentaho, Kettle is the most complete. It can give a "fair fight" to source solutions that are not open. The problem it addresses of course is to extract data from various sources; transform them; ”play with data”; and then load it to the target. I find the transformation most valuable and rich with functionality. I even made a full scale course about it, you can find it on udemy.
Pros
  • Pentaho Kettle gives you a great graphic user interface to plan your transformation and jobs.
  • Pentaho Kettle makes it easy to handle errors, logging and performance.
  • Pentaho Kettle has dozen of great steps like: lookup and SCD functionality.
Cons
  • Several steps have performance issues like the Json input.
  • The community edition does not include scheduler and job manager so you need to figure it out yourself, unless of course you buy the Enterprise edition.
  • I think that web service should be easier to operate.
Likelihood to Recommend
Pros:
I find it suited for 90% of data integration projects , its a very good tool, easy to use, stable and affordable.
Cons:
I think that the big data connections are still not perfect, so if you have a NoSQL DBl / Hadoop / Cassandra, you might consider extracting the data to file from the source using MapReduce. Also, if you need bulk load, sometimes it's better to use it directly on a tool, for example Redshift / InfiniDB (that is no longer with us).
Apart than that I think it will suit you well.
Return to navigation