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

Return to navigation

Pricing

View all pricing
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?

157 people also want pricing

Alternatives Pricing

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.

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

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

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

(1-5 of 29)

Data integration made easy

Rating: 8 out of 10
February 04, 2022
RG
Vetted Review
Verified User
Pentaho
2 years of experience
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.
  • 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
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 - Fast and Furious Data Integration

Rating: 9 out of 10
August 19, 2015
AM
Vetted Review
Verified User
Pentaho
8 years of experience
Pentaho Data Integration is used to move data into our data warehouse solution, used for various projects.
  • Data Integration. PDI handles pretty much any type of data source and can transform data and conform it to any type of business logic.
  • Object Oriented ETl Coding. Code developed in PDI can be shared across numerous jobs/transformations. This allows for resusable and maintainable code.
  • Flexibility and plugins. If the function that you are looking for is not built into the tool, it's fairly straightforward to either download or develop plugins. There is a huge community of users that build new functionality all the time.
  • Scaleable and cloud ready. PDI is able to cluster and scale out to handle huge data sets.
Cons
  • The speed at which some trouble issues get resolved could be improved.
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.

Data Integration with Pentaho Kettle review

Rating: 9 out of 10
December 05, 2014
IS
Vetted Review
Verified User
Pentaho
7 years of experience
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.
  • 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.
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.

My Experience with Pentaho data integrator

Rating: 9 out of 10
March 02, 2020
zb
Vetted Review
Verified User
Pentaho
2 years of experience
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 plays an important role in our business processes because we work on the database in the department where I work. I use the PentahoETL tool when designing ETL processes, transporting data to the database and designing the data warehouse.
  • I frequently use the Pentaho tool for data manipulation and data migration.
  • I use the PentahoETL tool when designing ETL processes, transporting data to the database and designing the data warehouse.
  • It is an ideal ETL tool for transporting XML and JSON-based data.
Cons
  • The error codes we received in the Pentaho ETL tool are not clear enough. Explanations need to be more detailed for quick resolution of the problem.
  • Scheduling ETL packages through the windows Task Scheduler makes things difficult. This process will be more efficient through the Pentaho tool.
  • Database connection information is timed out after a certain period of time. I sometimes have this problem even though the database password hasn't changed.
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.

My Favorite Data Integration Tool is still Kitchen

Rating: 10 out of 10
November 06, 2014
JG
Vetted Review
Verified User
Pentaho
5 years of experience
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.
  • 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.
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.
Return to navigation