Installation and Configuration Guide

Back Next

Inserting Reference Data for Customer 360 Consent Management Extension

If you plan to install the consent management extension, you can populate the tables with reference data related to consent management.

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

<MDM Installation Directory>/app/tcr/extensions/GDPR/data/reference-data

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

For Oracle.

C360_GDPR_lookup_script_Oracle.sql

For Microsoft SQL Server.

C360_GDPR_lookup_script_MSSQL.sql

For IBM Db2.

C360_GDPR_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. The

Total records

column shows the number of records added. The columns to the right of the

Total records

column displays zeros if all the records load successfully.

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.