Pentaho is a business software company that provides data integration and business analytics software. Its primary products are Pentaho Data Integration, which provides data integration and ETL capabilities, and Pentaho Business Analytics, which provides business intelligence, reporting, and analytics capabilities. Pentaho supports data environments including on-premises, cloud, and hybrid deployments. The company is owned by LEO Software, an operating group of Constellation Software.
Overview Pentaho is owned by Leo Software, a division of Constellation Software Inc. and is a separate business unit. Pentaho started out as business intelligence (BI) software developed by the Pentaho Corporation in 2004. It comprises Pentaho Data Integration (PDI) and Pentaho Business Analytics (PBA). These provide data integration, OLAP services, reporting, information dashboards, data mining and extract, transform, load (ETL) capabilities.
Pentaho was acquired by Hitachi Data Systems in 2015 and in 2017 became part of Hitachi Vantara. In November 2023, Hitachi Vantara launched the Pentaho+ Platform, comprising the original Pentaho Data Integration and Pentaho Business Analytics software, and new Pentaho Data Catalog, and Pentaho Data Optimiser software products. Hitachi Vantara intends to extend the Pentaho+ platform with tools for Data Quality and Data Mastering. Most recently, in June of 2026, Pentaho was acquired by LEO Software.
Products
Pentaho Data Optimizer (PDO) Pentaho Data Optimizer allows organizations to manage, maintain and tier their data based on its business value, the cost of managing it, and regulatory requirements. It uses the auto-discovery features of the Pentaho Data Catalog to achieve this.
Pentaho Data Catalog (PDC) In March 2020 and June 2021 Hitachi Vantara acquired Waterline Data and Io-Tahoe respectively, and amalgamated both into its Pentaho Data Catalog (PDC). PDC automatically finds, analyzes, and tags structured and unstructured data and contextualizes it with business glossary terms and governance policies.
Pentaho Data Integration (PDI) & Pentaho Business Analytics (PBA). Pentaho Data Integration (PDI) and Pentaho Business Analytics (PBA) use a Java framework to create business intelligence solutions. Although most known for its Business Analysis Server (formerly known as Business Intelligence Server), the PDI/PBA software is indeed a couple of Java classes with specific functionality. On top of those Java classes one can build any business intelligence solution.
The only exception to this model is the ETL tool Pentaho Data Integration - PDI (formerly known as Kettle.) PDI is a set of software used to design data flows that can be run either in a server or standalone processes. PDI encompasses Kitchen, a job and transformation runner, and Spoon, a graphical user interface to design such jobs and transformations.
Features such as reporting and OLAP are achieved by integrating sub-projects into the PDI/PBA framework, like Mondrian OLAP engine and jFree Report. For some time by now those projects have been brought into Pentaho's curating. Some of those subprojects even have standalone clients like Pentaho Report Designer, a front-end for jFree Reports, and Pentaho Schema Workbench, a GUI to write XMLs used by Mondrian to serve OLAP cubes.
Pentaho offers enterprise and community editions of those PDI software. The enterprise software is obtained through an annual subscription and contains extra features and support not found in the community edition. PDI & PBA's core offering is frequently enhanced by add-on products, usually in the form of plug-ins, from the company and the broader community of users.
Server applications Pentaho Enterprise Edition (EE) and Pentaho Community Edition (CE). Product Offering Type Recent version (EE) Recent version (CE) DescriptionPentaho BA Platform EE, CE Server application 7.1 7.1 Commonly referred to as the BI Platform, and recently renamed Business Analytics Platform (BA Platform), makes up the core software piece that hosts content created both in the server itself through plug-ins or files published to the server from the desktop applications. It includes features for managing security, running reports, displaying dashboards, report bursting, scripted business rules, OLAP analysis and scheduling out of the box. Commercial plug-ins from Pentaho expand out-of-the-box features. A few open-source plug-in projects also expand capabilities of the server. The Pentaho BA Platform runs in the Apache Java Application Server. It can be embedded into other Java Application Servers. Pentaho Analysis Services (Mondrian) EE, CE Server application 3.7.0 3.6.1 Pentaho Analysis Services, codenamed Mondrian, is an open-source OLAP (online analytical processing) server, written in Java. It supports the MDX (multidimensional expressions) query language and the XML for Analysis and olap4j interface specifications. It reads from SQL and other data sources and aggregates data in a memory cache. Mondrian can be run separately from the Pentaho BI Platform, but is always bundled with the platform itself in both EE and CE versions. Pentaho Dashboard Designer (PDD) EE Server plug-in 5.0.6 - A commercial plug-in provided to enterprise edition (EE) subscribers. It allows users to create dashboards, which are collections of other content components displayed together with the goal of providing a centralized view of key performance indicators (KPI)s and other business data movements, letting users monitor them and make decisions. Content components are usually individual Information graphics, tables, OLAP views or reports. The plug-in simplifies dashboard creation through the use of layout templates, drag-and-drop interaction and a GUI for providing parameters and inputs to dashboard components. Pentaho Analysis (Analyzer) (PAZ) EE Server plug-in 5.0.6 - The Pentaho Analyzer plug-in provides a web-based, drag-and-drop OLAP viewer. It allows a user to visually create MDX queries by dragging parts of a previously defined Mondrian OLAP schema onto a canvas, where other activities can take place like filtering, sorting, creating calculated members from other measures, exporting the result table to PDF or MS Excel, and optionally graphing the data. It is also known to work on Apple iPads by using the Safari web browser. Pentaho Interactive Reporting (PIR) EE Server plug-in 5.0.6 - This plug-in enables users to create ad hoc reports in a visual drag-and-drop fashion. Pentaho Data Access Wizard EE, CE Server plug-in - - This plug-in is bundled with all servers and allows users to create new data sources for use throughout the system from other databases or CSV files uploaded to the server while using a setup wizard. During the steps of creating a data source users also are given a chance to create a data model describing how columns or fields relate to each other creating hierarchies of relationships like Time: Year, Quarters, Months, Weeks and Product Division, Category, Type etc. The resultant model is used by Mondrian and any other plug-in like Analyzer or Saiku to create new queries against the newly created data source. This component is part of what Pentaho introduces as agile BI, which simply means having a way to start from basic data and quickly iterate through steps to discover the proper way to structure, study and present the data.Michael Terallo, Pentaho Data Access Wizard Retrieved July 29, 2012 Pentaho Mobile EE Server piece 5.0.6 - A new addition since 4.5-GA suite that is a user interface adapted for use with the Apple iPad. It exposes all of the major functionality of OLAP analysis and running of reports and dashboards that allow greater interaction on a small, touchscreen. Mobile also adds features for bookmarking favorite content for easy access and the concept of opening several pieces of content in tabs.
Desktop/client applications