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

TrustRadius Insights

Pentaho has proven to be a valuable tool for users across a range of industries and business functions. Users have found value in using …
Continue reading
TrustRadius Insights
TrustRadius Insights

Best for Reporting and Dashboard

10 out of 10
April 12, 2022
I use Pentaho for reporting and dashboard development. We develop the reports and integrate them with different database sources. It …
Continue reading

Pentaho - Yay or Nay?

6 out of 10
November 04, 2016
Incentivized
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
Read all reviews

Popular Features

View all 28 features
  • Publish to PDF (19)
    9.7
    97%
  • Role-Based Security Model (19)
    9.5
    95%
  • Multi-User Support (named login) (20)
    9.3
    93%
  • Formatting capabilities (19)
    8.3
    83%
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?

136 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.2

Ad-hoc Reporting

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

8.7
Avg 8.1

Report Output and Scheduling

Ability to schedule and manager report output.

9.6
Avg 8.4

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.2
Avg 8.1

Access Control and Security

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

9.1
Avg 8.6

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.9
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 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 and Ratings

(131)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Pentaho has proven to be a valuable tool for users across a range of industries and business functions. Users have found value in using Pentaho for building data warehouses for data migration and analytics, covering all scenarios and allowing the use of external jars for unsupported activities. Pentaho's BI stack is utilized for ETL, report delivery, and as an endpoint for custom web apps. It offers ease of learning and impressive functionality, making it a popular choice for small-size private consulting firms. Pentaho is also used by engineering departments to create data warehouse environments for multiple customers, enabling analytics usage. In addition, it serves as the primary source for Business Intelligence in many companies, used by multiple users for creating reports and evaluating work across different teams. The software's ability to handle large and complex data sets with ease has been highly regarded by users, along with its advanced features for data integration, reporting, and analytical dashboards. Overall, Pentaho meets various needs such as scheduled ETL processes, data ingestion, reporting and dashboard development, making it a flexible solution across organizations.

Wide range of tools and features: Users appreciate the flexibility of Pentaho, as it offers a wide range of tools and features that can be tailored to meet the specific needs of different users and organizations. This has been mentioned by multiple reviewers who found this feature highly customizable and easy to learn.

Excellent reporting tool: Pentaho is praised for being an excellent reporting tool, with features like data reporting, integration, data mining, and ETL. Users find it intuitive and easy to use, even for advanced users. The visual interface simplifies processes that would traditionally require writing lines of code. Many reviewers have highlighted this aspect as one of the strengths of Pentaho.

Highly accessible data integration module: Pentaho's Data Integration module is highly regarded for its maturity and ease of learning. It allows business users to quickly connect to almost any data source. The ability to preview data in a pivot view format enables early data analysis. Several users have mentioned this module as a valuable feature in their reviews.

Limited Data Visualization Capabilities: Users have expressed the need for Pentaho to improve its data visualization capabilities in order to enhance the end result of dashboards. Specifically, some users feel that the current options are limited and lack advanced features and customization.

Difficulties with Mondrian-based ROLAP: Some users have mentioned that the Mondrian based ROLAP capability does not scale up well when analyzing data for a large number of subscribers over different time periods. This has resulted in performance issues and challenges in meeting the needs of complex business requirements.

Lack of Support and Guidance for WEKA: Users believe that WEKA, the machine learning platform used by Pentaho, lacks use cases in production environments and requires more support and guidance. They have found it challenging to implement and fully leverage the potential of WEKA within their organizations due to limited resources and documentation.

Attribute Ratings

Reviews

(26-31 of 31)
Companies can't remove reviews or game the system. Here's why
November 06, 2014

My Favorite Data Integration Tool is still Kitchen

Julia Gusman | TrustRadius Reviewer
Julia Gusman
BI Consultant
Altis Consulting (Information Technology and Services, 1-10 employees)
Score 10 out of 10
Vetted Review
Verified User
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.
November 05, 2014

Three Years with Pentaho and No Regrets

KP
Kenneth Panacy
Database Engineer
Online-Buddies, Inc. (Internet, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Likelihood to Recommend
Do you need to integrate data from multiple sources? Pentaho is great for this. Previously, we were SSHing files around and importing with numerous cron scripts.

Are your Finance and Marketing teams constantly asking for one-off queries? Pentaho puts this power in THEIR hands so they can pull and arrange the data they want into whatever view they want.

Do you want to pay too much for a full-featured BI solution? Pentaho is very reasonably priced, and even has a free version!
November 04, 2014

Pentaho the best BI integrator

Deepak Paramanand | TrustRadius Reviewer
Deepak Paramanand
Technical Lead
Razorsight Software Pvt. Ltd. (Information Technology and Services, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Integration is best with Pentaho. If you want to overlay your product capability with Pentaho's BI Server, Data Integration, Reporting Engine, Workflow capabilities then Pentaho is the only answer. Other tools provide each of these very well, but if you have already built your product and dont want to buy Informatica, Cognos/Microstratey and SPSS/SAS then Pentaho is the way to go.
Pentaho is Java based, so no shortage of skilled Java resources who can help you integrate. We did not spend time building our own reporting engine, Data Visualization layer, Security layer, workflow capabilities. We simply used our proven transactional product and used Pentaho to fill our gaps.
November 04, 2014

Pentaho: a strong open source BI suite

Nathan Smith | TrustRadius Reviewer
Nathan Smith
Systems Analyst
Olathe Medical Center (Government Administration, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
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.
September 16, 2014

Pentaho Report Designer Integated with Odoo v7!

Adam O'Connor | TrustRadius Reviewer
Adam O'Connor
OpenERP Software Implementation Engineer
Ursa Information Systems Incorporated (Information Technology and Services, 1-10 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Pentaho is great for companies that don't have huge budgets but want a powerful reporting tool that they can get and use for free. It is great for developers that know SQL and can learn to use a non-intuitive interface and are motivated to work through a very outdated interface.
Return to navigation