Installation and Configuration Guide

10.3 HotFix 1

Back Next

Inserting Reference Data

After you import the metadata, you can populate the tables with some reference data. By using reference data, you can complete the configuration steps faster, because you do not have to insert the rows into the tables manually.

At a command prompt, navigate to the following directory:

<MDM installation directory>/app/tsr

/hub/schema/reference-data

Use a database tool to run the following script:

Supplier_lookup_script_oracle.sql

Verify that the lookup records loaded successfully from the Hub Console.

In the Hub Console, in the Utilities workbench, click

Batch Group

Expand

BG_All_Lookup_Load

and select

Control & Logs

In the Logs for each job table, review the Status column to verify that the load was successful. The Total records column shows the number of records added. The columns to the right of the Total records column displays zeros if all records load successfully.

If the load was unsuccessful, try running the load. Select

BG_All_Lookup_Load

and click

Execute

Use a database tool to run the following script:

INSERT_C_REPOS_APP_CONFIG_ORACLE.sql

The table C_REPOS_APP_CONFIG is populated with reference data.

Import the Database Schema into the Operational Reference Store

Download Guide

Watch

Comments

Communities