Skip to main content
Pentaho Documentation

Data Integration Operations Mart

The DI Operations Mart enables you to collect and query Data Integration log data and then use BA server tools to examine log data in reports, charts, or dashboards.

Description

The DI Operations Mart is a centralized data mart that stores job or transformation log data for easy reporting and analysis. The data mart is a collection of tables organized as a data warehouse using a star schema. Together, dimension tables and a fact table represent the logging data. These tables need to be created in the DI Operations Mart database. Pentaho provides SQL scripts to create these tables for MySQL, Oracle, and PostgresSQL databases. A Data Integration job populates the time and date dimensions.

Note: For optimal performance, be sure to clean the operations mart periodically.

Getting Started

These procedures describe how to install, set up, and configure the DI Operations Mart to collect ETL logging information. These instructions only apply if you do not have the BA Server. If you are a Pentaho Business Analytics customer, these tables and connections are created automatically.