Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Pre-Installation Tasks
  4. Hub Store Installation
  5. Hub Server Installation
  6. Hub Server Post-Installation Tasks
  7. Process Server Installation
  8. Process Server Post-Installation Tasks
  9. ActiveVOS Post-Installation Tasks for the Application Server
  10. ActiveVOS Post-Installation Tasks for the Business Entity Adapter
  11. Resource Kit Installation
  12. Resource Kit Post-Installation Tasks
  13. Troubleshooting the MDM Hub
  14. Uninstallation

Installation Guide for Microsoft SQL Server with IBM WebSphere

Installation Guide for Microsoft SQL Server with IBM WebSphere

Import the Metadata into the MDM Hub Master Database

Import the Metadata into the MDM Hub Master Database

After you create the
MDM Hub Master Database
, import the initial metadata into the
MDM Hub Master Database
. The initial metadata includes repository tables and other objects that the
MDM Hub
requires in the
Hub Store
.
If you change the folder names in the distribution directory, metadata import fails.
  1. Open a command prompt, and navigate to the following directory:
    <
    MDM Hub distribution directory
    >/database/bin
  2. To import the initial metadata, run the following command:
    sip_ant.bat import_system
  3. Answer the prompts described in the following table:
    The prompts display default text in brackets. Press
    Enter
    to use the default value and go to the next prompt.
    Prompts
    Description
    Enter the database type (ORACLE, MSSQL, DB2)
    Database type.
    Specify
    MSSQL
    .
    Enter the database host name [localhost]
    Name of the host that is running the database.
    Enter the database port number
    [1433]
    Port number that the database listener uses.
    Default is
    1433
    .
    Connect URL [jdbc:sqlserver://localhost:1433]
    Connect URL for Microsoft SQL Server. Default is
    jdbc:sqlserver://localhost:1433
    .
    Enter master database name [cmx_system]
    Name of the MDM Hub Master Database schema. Default is
    cmx_system
    .
    Enter master database user password
    Password to access the MDM Hub Master Database.
    Enter locale name from the list: de, en_US, fr, ja, ko, zh_CN. [en_US]
    Operating system locale. Default is
    en_US
    .
  4. After you import the initial metadata, review the following log files for errors:
    • seed.log
      . Contains database errors.
      The
      seed.log
      file is in the following directory:
      <
      MDM Hub installation directory
      >/database/bin/mssql
    • sip_ant.log
      . Contains user input errors.
      The
      sip_ant.log
      file is in the following directory:
      <distribution directory>/database/bin

0 COMMENTS

We’d like to hear from you!