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 |
|---|
_1 | Folder that contains the 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.