Table of Contents

Search

  1. Preface
  2. Introduction to Informatica MDM - Supplier 360
  3. Supplier 360 Installation Overview
  4. Before You Install
  5. Installing the Supplier 360 Components
  6. After You Install
  7. Business Processes for Supplier Management
  8. Customizing Supplier 360
  9. Upgrading MDM - Supplier 360

Configuring the Data Mart Database Connection

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.
  1. Go to the following directory:
    <MDM installation directory>/app/tsr/datamart/lib
  2. If the directory does not contain the following files, copy them from the
    <MDM installation directory>/hub/server/lib
    directory:
    • log4j-1.2.16.jar
    • ojdbc7.jar
    • sqljdbc4.jar
      . For Microsoft SQL Server.
    • siperian-common.jar
    • commons-validator-1.4.0.jar
  3. At a command prompt, navigate to the following directory:
    <MDM installation directory>/app/tsr
    /datamart
  4. Run the following command:
    java -jar populate_datamart.jar config
  5. At the prompt, type C to configure the database connection.
  6. 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.
  7. When prompted to finish the configuration, enter Y.
    The tool saves the connection information to the
    config/mart-population-config.xml
    file.

0 COMMENTS

We’d like to hear from you!