Table of Contents

Search

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

Installation and Configuration Guide

Installation and Configuration Guide

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
Customer 360
resources and the custom objects that do not conform to the naming guidelines. Manually fix the errors before you upgrade
Customer 360
.
  1. Open a command prompt, and go to the following directory:
    <MDM installation directory>/app/tcr/bin
  2. Run the following command:
    • On Windows.
      validate-schema-tcr.bat
    • On UNIX.
      validate-schema-tcr.sh
  3. At the prompts, enter the following parameters:
    Parameter
    Description
    MDM Hub installation directory
    Fully qualified path to the directory where you installed MDM Hub.
    MDM - Customer 360 installation directory
    Fully qualified path to the directory that contains the Customer 360 files.
    Customer 360 Operational Reference Store
    Database ID of the
    Customer 360
    Operational Reference Store.
    MDM Hub user name
    MDM Hub user name to access the
    Customer 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.
    The utility validates the database schema. You can find the validation report as an HTML file in the following directory:
    <MDM installation directory>/app/tcr/upgrade/report
  4. To validate another database schema, press
    y
    , and enter the following parameters:
    Parameter
    Description
    Customer 360 Operational Reference Store
    Database ID of the
    Customer 360
    Operational Reference Store.
    MDM Hub user name
    MDM Hub user name to access the
    Customer 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!