Data Director User Guide

10.3

Back Next

Data Import Example

For example, a data steward wants to import customer records from a Microsoft Excel spreadsheet. In the spreadsheet, column 1 contains first names and column 2 contains last names.

The Operational Reference Store contains a base object table called C_PARTY that has columns for the first name and the last name. The IDD application defines a Person subject area.

The data steward asks the MDM administrator to create a data import template to match the organization of the data in the source file. In the template, the developer defines an import profile for the Person subject area with the following mappings:

Map column 1 in the source file to the FIRST_NAME column in the C_PARTY base object.

Map column 2 in the source file to the LAST_NAME column in the C_PARTY base object.

The following code sample shows the import profile for this example:

<?xml version="1.0" encoding="UTF-8"?>
<DataImportTemplateConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
                          xsi:noNamespaceSchemaLocation="data-import-template.xsd">
	<ImportProfile name="IMPORT_SA_PERSON" displayName="Import profile for SA Person" 
                subjectArea="Person" effectivePeriodStart="6" effectivePeriodEnd="7" 
                effectiveDateFormat="dd.MM.yyyy">
  <PrimaryObject>
	  <Column index="1">C_PARTY|FIRST_NAME</Column>
	  <Column index="2">C_PARTY|LAST_NAME</Column>
				...
 	</PrimaryObject>
	</ImportProfile>
</DataImportTemplateConfig>

Rename Saved Search

Table of Contents

Data Director User Guide

Data Director User Guide

Data Import Example

Data Import Example