Skip to main content
Pentaho Documentation

Set Up Database Connections

In order to fetch logging data from the online database, you must define a database connection and populate the Operations Mart. Installing the DI Operations Mart defines two default database connections: live_logging_info: connects to the online database used for the sample jobs and transformations, and PDI_Operations_Mart connects to the off-line DI Operations Mart database. The connection information needs to match your databases. This procedure explains how to define your database connections.

  1. From within Spoon, close any jobs or transformations you might have open.
  2. Select Tools > Repository > Explore from the drop-down menu. The Repository Explorer window opens.
  3. Select the Connections tab.
  4. Select the live_logging_info entry. Edit the entry by clicking the pencil icon in the upper-right corner. The database connection window opens.
  5. Enter the information for the connection that fetches the online logging data. If you need to have multiple connections to fetch the online logging information, create new connections and enter the information for each connection.
  6. Repeat steps 3 and 4 for the PDI_Operations_Mart connection.
The database connections for the DI Operations Mart are defined.