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

Create the Operational Reference Store

Create the Operational Reference Store

Create an Operational Reference Store with the schema name
supplier_hub
. When entering database parameters, use the parameters that you specified when you created the Oracle database instance.
You must use the name supplier_hub. If you use a different name, the integration with Product 360 does not work.
  1. Navigate to the following directory:
    <MDM installation directory>/hub/server/bin
  2. Run one of the following commands:
    • On Windows.
      sip_ant.bat create_ors
    • On Linux.
      sip_ant.sh create_ors
  3. Enter values for the Operational Reference Store parameters.
    The prompts display default text in brackets. Press
    Enter
    to use the default value and go to the next prompt.
    Parameter
    Description
    Oracle Connection Type
    Enter the type that you specified for the Oracle database instance.
    Operational Reference Store DB host name
    Enter the IP address of the host running Oracle.
    Operational Reference Store DB port number
    Enter the port number that Oracle uses.
    Operational Reference Store DB service name
    If the Oracle Connection Type=service, enter the name of the Oracle service that you specified for the Oracle database instance.
    Oracle Net connect identifier
    Enter the TNS name that you specified for the Oracle database instance.
    Connect URL
    Use the default URL unless you are required to change the URL for business reasons or technical reasons.
    Operational Reference Store DB user name (schema name)
    Enter
    supplier_hub
    .
    Operational Reference Store DB user password
    Enter a password to assign to the supplier_hub user.
    Locale name
    Enter the language to use.
    DBA user name
    Enter the user name for the Oracle database instance.
    DBA password
    Enter the password for this user.
    MDM index tablespace
    Use the default value. Creates a tablespace to contain the index components for the Operational Reference Store.
    MDM temporary tablespace
    Use the default value. Creates a tablespace to contain the temporary components for the Operational Reference Store.
    Oracle temporary tablespace
    Use the default value. Creates a tablespace to contain the temporary components for the database instance.
    The script triggers the process that creates the Operational Reference Store.
  4. If the process fails, check the log file for errors:
    <MDM installation directory>/hub/server/bin/sip_ant.log

0 COMMENTS

We’d like to hear from you!