Data Integration and Analytics design tools

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

These tools include:

• 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

  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

  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

  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

  Edit and create multidimensional (Mondrian) models. You can create Mondrian models graphically or define them by hand-coding XML files.