Skip to main content
Version Pentaho
Hitachi Vantara Lumada and Pentaho Documentation

Configure the Design Tools and Utilities

  1. Last updated
  2. Save as PDF

Before using design tools and utilities, you need to perform configuration tasks for each workstation running these tools. Depending on how these tools and utilities were installed, they might be located on different machines other than the Pentaho Server.

BA Design Tools

The following table describes the BA design tools and their uses:

Design Tool What It Does
Aggregation Designer Optimizes the multidimensional Mondrian data model.
Metadata Editor Creates relational data models and refines the models created with the Data Access Wizard.
Report Designer

Interactive Reporting is a web-based design interface which is used to create both simple and on-demand operational reports without depending on IT or report developers.
Schema Workbench Creates multidimensional Mondrian data models and refines the models created with the Data Access Wizard.

As a Pentaho administrator, you will need to know how to start and stop the BA design tools. Your IT administrator specifies the data connections for these tools.

PDI Design Tools and Utilities

PDI Client (Spoon) allows users to design and manage complex ETL workloads with a graphical user interface.

Kitchen, Pan, and Carte are command line tools for executing jobs and transformations modeled in Spoon. 

You will need to know how to perform the following tasks for the PDI design tools and utilities: