Importing reference data assets

After you import MDM assets, import reference data code values in bulk from CSV files into reference data assets.

The following table describes the files and folders in the extracted reference data directory:

File or Folder Name	Description
Customer_Reference_Data	The folder that contains the lookup code values folders for Customer 360. Contains the following folders: - Organization. The folder that contains the lookup code values for the Organization business entity. Lookup code values are in the following files and folders: - _1 . Contains the parent lookup code values. - _2 . Contains the child lookup code values. - _3 . Contains the sub-child lookup code values. - LoadReferenceData.py . Python script to import reference data. - Person. The folder that contains the lookup code values for the Person business entity. Lookup code values are in the following folders: - _1 . Contains the parent lookup code values. - _2 . Contains the child lookup code values. - LoadReferenceData.py . Python script to import reference data.
Location_Reference_Data	The folder that contains the lookup code values folders for the Location business entity. Lookup code values are in the following files and folders: - _1 . Contains the parent lookup code values. - _2 . Contains the child lookup code values. - LoadReferenceData.py . Python script to import reference data.
Product_Reference_Data	The folder that contains the lookup code values folders for the Product business entity. Lookup code values are in the following files and folders: - _1 . The folder that contains the code values. - LoadReferenceData.py . Python script to import reference data.
Supplier_Reference_Data	The folder that contains the lookup code values folders for the Supplier business entity. Lookup code values are in the following files and folders: - _1 . Contains the parent lookup code values. - _2 . Contains the child lookup code values. - LoadReferenceData.py . Python script to import reference data.

To import code values in bulk from CSV files that are available in the extracted reference data directory, run the LoadReferenceData.py Python script.

Prerequisites

Before you import reference data into MDM SaaS, ensure that you complete the following prerequisite tasks:

•Ensure that you have permission to import reference data.

•Install Python version 3 or later on your machine.

•To verify whether the cURL library files are preinstalled and to check the cURL library version, run the following command from a command prompt:

curl --version

Note: If cURL isn't available in your operating system, ensure that you install it.

You can download the cURL library for your operating system from the cURL website:

http://curl.haxx.se/download.html

Importing the reference data

To import all the reference data in bulk, run the Python script.

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

<Extracted extension package>/Reference Data

2Run the following command:

- On Windows.

python LoadReferenceData.py --podHostName <POD host name>.informaticacloud.com --userName <user name> --password <password> --region <POD region>

- On Linux.

python3 LoadReferenceData.py --podHostName <POD host name>.informaticacloud.com --userName <user name> --password <password> --region <POD region>

The jobs to import reference data code values run.

3To monitor the status of a job, click My Jobs in Reference 360.

The My Jobs page lists the job instances that are currently running, failed, and successfully completed.