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
  10. Troubleshooting

Validating the Database Schema

Validating the Database Schema

Use the schema validation utility to validate the database schema for any errors. The utility identifies the customized Supplier 360 resources and the custom objects that do not conform to the naming guidelines. Manually fix the errors before you upgrade Supplier 360.
  1. Open a command prompt, and go to the following directory:
    <MDM installation directory>/app/tsr/bin
  2. Run the following command:
    • On Windows.
      validate-schema-tsr.bat
    • On UNIX.
      validate-schema-tsr.sh
    If you don't use
    MDM - Customer 360
    in the same environment, you don't have to run the script to validate the database scheme.
  3. At the prompts, enter the following parameters:
    Parameter
    Description
    MDM Hub installation directory
    Press Enter to use the default path or type the fully-qualified path to the directory where you installed the MDM Hub.
    MDM - Supplier 360 installation directory
    Press Enter to use the default path or type the fully-qualified path to the directory that contains the application files.
    Supplier 360 Operational Reference Store
    Database ID of the
    Supplier 360
    Operational Reference Store.
    MDM Hub user name
    MDM Hub user name to access the
    Supplier 360
    Operational Reference Store.
    Password
    Password for the user name.
    If you use a WebLogic application server, you are prompted to enter the WebLogic console password.
  4. To validate another database schema, press
    y
    , and enter the following parameters:
    Parameter
    Description
    Supplier 360 Operational Reference Store
    Database ID of the
    Supplier 360
    Operational Reference Store.
    MDM Hub user name
    MDM Hub user name to access the
    Supplier 360
    Operational Reference Store.
    Password
    Password for the user name.
  5. If you do not want to validate another database schema, press
    n
    .

0 COMMENTS

We’d like to hear from you!