Installation and Configuration Guide

Back Next

Configuring the Data Mart Database Connection

Before you can generate reports or populate charts, you must configure the data mart database connection.

Navigate to the following directory:

<MDM Installation Directory>/app/tcr/reporting/datamart/lib

If the directory is empty, copy the following files from the

<MDM installation directory>/hub/server/lib

directory to the

<MDM installation directory>/app/tcr/reporting/datamart/lib

directory:

log4j-1.2.16.jar

ojdbc7.jar

siperian-common.jar

commons-validator-<version number>.jar

Navigate to the following directory:

<MDM installation directory>/app/tcr/reporting/datamart

Extract the contents of the

populate_datamart.jar

file.

Open the following file in an editor:

<Directory containing extracted files>/META-INF/MANIFEST.MF

To the

Class-Path

parameter, add the following value:

lib/commons-validator-<version number>.jar

Save the file.

Open a command prompt.

Run the following command:

java -jar populate_datamart.jar config

At the prompt, type

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, the connection is 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, IBM DB2, or Microsoft SQL Server.
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.

When prompted to finish the configuration, enter

The connection information is saved in the following file:

<MDM installation directory>/app/tcr/reporting/datamart/config/mart-population-config.xml