Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation


Pentaho products are a comprehensive platform used to access, integrate, manipulate, visualize, and analyze your data. Whether data is stored in a flat file, relational database, Hadoop cluster, NoSQL database, analytic database, social media streams, operational stores, or in the cloud, Pentaho products can help you discover, analyze, and visualize data to find the answers you need, even if you have no coding experience. Advanced users with programming experience can use our extensive API to customize reports, queries, transformations to extend functionality.

Pentaho products include both web-based components and design tools. The components and tools you use depend on your workflow and what your environment supports.

Web-based Components

Use the Pentaho web-based components to share business intelligence solutions by analyzing data, creating reports, and building integrated dashboards.

These components include:

  • User Console

    The Pentaho User Console (PUC) is a design environment for accessing Analyzer, Interactive Reports, and Dashboard Designer. Pentaho User Console also offers system administration features for configuring your Pentaho Server.

  • Analyzer

    Analyzer helps you visualize data to make informed business decisions. You can create geographic, scatter chart, heat grid, and multi-chart visualizations. You can also filter data, add query parameters, configure drill-down links, apply conditional formatting, and generate hyperlinks.

  • Interactive Reports

    Interactive Reports is a design interface used to create both simple and on-demand operational reports without relying on IT or report developers. You can quickly add elements to your report and format them any way you like.

  • Dashboard Designer

    Dashboard Designer is used to choose layout templates, themes, and content to create visually attractive dashboards that help decision makers gain critical knowledge at a glance. You can combine a wide variety of content including Interactive Reports, Analyzer visualizations, and collaborative content.

  • CTools

    CTools is a community-driven framework for creating dashboards by using web technologies such as JavaScript, CSS, and HTML. You can easily create dynamic dashboards for users to explore and understand large amounts of data using a variety of charts, tables, and other components.

  • Data Source Wizard

    The Data Source Wizard helps you define a data source that contains your information and guides you through the creation of your first relational or multidimensional models for use in creating reports and analysis.

  • Data Source Model Editor

    The Data Source Model Editor helps you adjust and refine relational and multidimensional data models. You can drag fields to their appropriate locations, mix and match fields from different tables, add fields to more than one category, or remove a field.

Design Tools

Use Pentaho design tools to develop and refine how your data values are reported, modeled, transformed, and stored.

These tools include:

  • Data Integration

    Pentaho Data Integration (PDI) provides access to an Extraction, Transformation, and Loading (ETL) engine that captures the right data, cleanses the data, and stores data using a uniform format that is accessible and relevant to end users and IoT technologies.

  • Report Designer

    Report Designer is used to generate detailed, pixel-perfect reports using virtually any data source. It enables business intelligence professionals to create highly detailed, print-quality reports based on adequately prepared data.

  • Aggregation Designer

    Aggregation Designer provides a simple interface that allows you to create aggregate tables from levels within the dimensions you specify. Use this tool to improve the performance of your Pentaho Analysis (Mondrian) OLAP cubes.

  • Metadata Editor

    The Metadata Editor simplifies report building. Use the Metadata Editor to build Pentaho metadata domains and models. A Pentaho Metadata Model maps the physical structure of your database into a logical business model.

  • Schema Workbench

    Schema Workbench allows you to edit and create multidimensional (Mondrian) models. You can create Mondrian models graphically or define them by hand-coding XML files.

Supported Technologies

Reference material for supported components and JDBC drivers.