Installation and Configuration Guide

Back Next

Configuring the Data Mart Database Connection

Before you can generate reports or populate charts that are available as external links, you must configure the data mart database connection.

Go to the following directory:

<MDM installation directory>/app/tsr/datamart/lib

If the directory does not contain the following files, copy them from the

<MDM installation directory>/hub/server/lib

directory:

log4j-api-2.17.2.jar

log4j-core-2.17.2.jar

log4j-1.2-api-2.17.2.jar

ojdbc7.jar

sqljdbc4.jar

. For Microsoft SQL Server.

siperian-common.jar

commons-validator-1.4.0.jar

At a command prompt, navigate to the following directory:

<MDM installation directory>/app/tsr

/datamart

Run the following command:

java -jar populate_datamart.jar config

At the prompt, type C to configure the database connection.

Answer the prompts described in the following table:

Prompt	Description
Connection Name	Enter a unique name for the connection. If the name exists, it will be overwritten.
Type of Connection	Enter the type of connection to the data mart. Currently only DB is supported.
Database vendor	Enter the database to connect with, such as Oracle or IBM DB2 or MS SQL.
User	Enter the database user.
Password	Enter the database password.
Token	Reserved for future use
Host Name	Enter the database host name.
Port	Enter the database port.
Database Name	Enter the database name/SID.