Installation and Configuration Guide

Back Next

Updating the Reference Data

After you upgrade

Customer 360

, update the reference data in the tables.

Before you update the reference data, if you have customized the reference data, update the lookup script to include the customization.

Open a command prompt, and navigate to the following directory:

<MDM installation directory>/app/tcr/data/reference-data

Run one of the following lookup scripts based on the database you use:

For Oracle.

C360_lookup_script_oracle.sql

For Microsoft SQL Server.

C360_lookup_script_MSSQL.sql

For IBM DB2.

C360_lookup_script_DB2.sql

To verify whether the lookup records are loaded successfully, perform the following tasks:

In the Utilities workbench of the Hub Console, 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 is successful.

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

BG_All_Lookup_Load

and click

Execute

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.