Developing a delimited data object mapping

You must create a mapping between the delimited data object Person element from the source to the TCRMService element on the target.

About this task

There are two options to copy values from a Person delimited data source to a corresponding target MDM Person object:

  • Use the Move refinement to copy values that do not need to be transcoded or modified.
  • Use the Assign refinement to assign a constant value to a target element or attribute. This option is only available for assigning values to simple type fields such as strings or integers. To create an Assign mapping:
    1. Select the target element or attribute to which you wish to assign a value.
    2. Right-click the target element or attribute and select Create Assign.
    3. Use the Properties view to assign the correct value to the target element or attribute.

To develop a delimited data object mapping:

Procedure

  1. Open the PersonRequest.map generated in the MDMDFDLMappingSample project in the Graphical Data Mapper.
  2. Refer to the addPerson mapping reference table for the mapped attributes between the Person delimited object and the MDM Person object.
  3. Create a local map between the source Person data object and the target TCRMService/TCRMTx/TCRMObject/TCRMPersonBObj.
  4. Click on the local map, then map the source Person object to TCRMPersonBObj.
  5. Map the person name fields in the source Person object to the TCRMPersonBObj object’s DisplayName field:
    1. In the source table, locate FIRST_NAME and LAST_NAME.
    2. In the target table, locate DisplayName.
    3. Drag and drop FIRST_NAME from the source table into DisplayName in the target.
    4. Drag and drop LAST_NAME from the source table to the move mapping created by the previous step.
    5. In the Connection Selection Helper window, choose Primary Connection. The move map will turn into a Concat map.
    6. Right click on Concat, then choose Show in > Properties View to display the properties of the Concat map.
    7. For the Default Delimiter, choose the Space character option to set the default delimiter to be a space character. The table will now appear as follows:
      Input Delimiter
      FIRST_NAME (Space character)
      LAST_NAME (Space character)
    8. Remove the (Space character) delimiter beside the LAST_NAME field. The table will now appear as follows:
      Input Delimiter
      FIRST_NAME (Space character)
      LAST_NAME  
  6. Map the person name fields in the source Person object to the PersonNameBObj fields in the TCRMPersonBObj:
    1. In the source table, locate FIRST_NAME and LAST_NAME.
    2. In the target table, locate TCRMPersonNameBObj.
    3. Drag and drop FIRST_NAME from the source table into TCRMPersonNameBObj in the target.
    4. Drag and drop LAST_NAME from the source table to the local map created earlier in this procedure.
    5. In the Connection Selection Helper window, choose Primary Connection. The local map will turn into a join map.
    6. Click Join and map the FIRST_NAME to TCRMPersonNameBObj/GivenNameOne.
    7. Map the LAST_NAME to TCRMPersonNameBObj/LastName.
    8. In the target, locate NameUsageType, then right-click and select Create Assign.
    9. Use the Properties view to assign the value to be 1 to denote that the name usage corresponds to the Legal Name.
    10. Click the Up arrow to move back one level in the mapping editor.
  7. Map the BIRTH_DATE field in the source Person object to the BirthDate field in the TCRMPersonBObj:
    1. In the source table, locate BIRTH_DATE.
    2. In the target table, locate BirthDate.
    3. Drag and drop BIRTH_DATE in the source to BirthDate in the target.

  8. Map the GENDER field:
    1. In the source table, locate GENDER.
    2. In the target table, locate Gender.
    3. Drag and drop GENDER in the source to GenderType in the target.

  9. Map the Identification field:
    1. In the source table, locate Identification.
    2. In the target table, locate TCRMPartyIdentificationBObj.
    3. Drag and drop Identification from the source table into TCRMPartyIdentifiicationBObj in the target table. This will result in a local map connection.
    4. Click on the local map.
    5. Drag and drop the Identification field in the source table to the IdentificationNumber field in the target table.
    6. Right-click on IdentificationType in the target table, then choose Create Assign.
    7. Use the Properties view to assign the value to be 8 to denote that the identification type corresponds to "passport".
    8. Click the Up arrow to move back one level in the mapping editor.
  10. Map the HOME_PHONE field:
    1. In the source table, locate HOME_PHONE.
    2. In the target table, locate TCRMPartyContactMethodBObj.
    3. Drag and drop HOME_PHONE from the source table into TCRMPartyContactMethodBObj in the target table. This will result in a local map connection.
    4. Click on the local map.
    5. Drag and drop the HOME_PHONE field in the source table to the TCRMContactMethodBObj/ReferenceNumber field in the target table.
    6. Right-click on ContactMethodUsageType in the target table, then choose Create Assign.
    7. Use the Properties view to assign the value to be 1 to denote that the contact method usage type corresponds to "home phone".
    8. Right-click on ContactMethodType in the target table, then choose Create Assign.
    9. Use the Properties view to assign the value to be 1 to denote that the contact method type corresponds to "phone".
    10. Click the Up arrow to move back one level in the mapping editor.
  11. Map the BUSINESS_PHONE field:
    1. In the source table, locate BUSINESS_PHONE.
    2. In the target table, locate TCRMPartyContactMethodBObj.
    3. Drag and drop BUSINESS_PHONE from the source table into TCRMPartyContactMethodBObj in the target table. This will result in a local map connection.
    4. Click on the local map.
    5. Drag and drop the BUSINESS_PHONE field in the source table to the TCRMContactMethodBObj/ReferenceNumber field in the target table.
    6. Right-click on ContactMethodUsageType in the target table, then choose Create Assign.
    7. Use the Properties view to assign the value to be 1 to denote that the contact method usage type corresponds to "business phone".
    8. Right-click on ContactMethodType in the target table, then choose Create Assign.
    9. Use the Properties view to assign the value to be 2 to denote that the contact method type corresponds to "phone".
    10. Click the Up arrow to move back one level in the mapping editor.
  12. Map the address fields from the source to the TCRMPartyAddressBObj:
    1. Right-click on AddressUsageType in the source table, then choose Create Assign.
    2. Use the Properties view to assign the value to be 1 to denote that the address usage type corresponds to "primary residence".
    3. Drag and drop ADDRESS_LINE_ONE in the source table to AddressLineOne in the target table (under TCRMPartyAddressBObj/TCRMAddressBObj).
    4. Drag and drop ADDRESS_LINE_TWO in the source table to AddressLineTwo in the target table (under TCRMPartyAddressBObj/TCRMAddressBObj).
    5. Drag and drop CITY in the source table to City in the target table (under TCRMPartyAddressBObj/TCRMAddressBObj).
    6. Drag and drop STATE_CODE in the source table to ProvinceStateValue in the target table (under TCRMPartyAddressBObj/TCRMAddressBObj).
    7. Drag and drop COUNTRY in the source table to CountryValue in the target table (under TCRMPartyAddressBObj/TCRMAddressBObj).
    8. Drag and drop ZIP_CODE in the source table to ZipPostalCode in the target table (under TCRMPartyAddressBObj/TCRMAddressBObj).
  13. Map the source keys from the source field to the TCRMAdminContEquivBObj:
    1. Locate SOURCE_SYSTEM in the source table.
    2. Locate AdminSystemType under TCRMAdminContEquivBObj in the target table.
    3. Drag and drop the source table’s SOURCE_SYSTEM to the AdminSystemType in the target table.
    4. Locate SOURCE_KEY in the source table.
    5. Locate AdminPartyId under TCRMAdminContEquivBObj in the target table.
    6. Drag and drop the source table’s SOURCE_KEY to the AdminPartyId in the target table.
  14. Save the map.
  15. Open mapping.mdmxmi.
  16. Generate the mapped service implementation.

Last updated: 13 Sep 2017