1. Data Quality Administration Guide
  2. What’s New in This Release

14Upgrading to Informatica Identity Resolution 9.01

Upgrading to Informatica Identity Resolution 9.01

This chapter describes the changes that are required when upgrading your existing Oracle Data Quality Matching Server setup to Informatica Identity Resolution 9.01. It includes the following topic:

Upgrading to Informatica Identity Resolution 9.01

A new Cluster Id system field called CL ID is introduced by Informatica Identity Resolution 9.01. Consisting of 2 bytes, the CL ID field is added automatically to the end of each IDT table. To accommodate this change, you must configure a new CL ID field in DQ Sync Services so that Siebel can format the correct record length to insert into the Oracle Data Quality Matching Server NSA table.

Use the following procedure to upgrade your existing Oracle Data Quality Matching Server setup to Informatica Identity Resolution 9.01. This task is a step in Process of Configuring Data Synchronization Between Siebel and Oracle Data Quality Matching Server.

To upgrade to Informatica Identity Resolution 9.01

  1. Add new CL ID fields to the DQ Sync Services business service user properties.

    Note: Add the new CL ID field to the last field in your IDT table. For example, the last field in the Account IDT table is Account Business Address, so add the new CL ID field to the Account_Business_Address component (not to the parent Account object).

    • Add the following for Account:

      User Property Value

      Account Record Length

      1092

      Account_Business Address_DataType

      W|W|W|W|W|C|C

      Account_Business Address_DeDupFlds

      City|Country|Postal Code|State|Street Address|Address Id|CL ID

      Account_Business Address_ExtLen

      200|120|120|40|200|60|2

    • Add the following for Contact:

      User Property Value

      Contact Record Length

      1852

      Contact_INS Personal Address_DataType

      W|W|W|W|W|C|C

      Contact_INS Personal Address_DeDupFld

      INS Personal City|INS Personal Country|INS Personal Postal Code|INS Personal State|INS Personal Street Address|INS Personal Address Id|CL ID

      Contact_INS Personal Address_ExtLen

      120|40|40|40|200|60|2

    • Add the following for Prospect:

      User Property Value

      Prospect Record Length

      1772

      Prospect_DataType

      W|W|W|W|W|W|W|W|W|W|W|W|W|C|C

      Prospect_DeDupFlds

      Account|Cellular Phone #|City|Country|Email Address|First Name Last Name|Home Phone #|Middle Name|Postal Code|Social Security Number|State|Street Address|Work Phone #|Id|CL ID

      Prospect_ExtLen

      200|120|120|60|120|200|120|200|40|120|40|200|200|30|2

  2. Apply the Informatica Address Doctor Version 5 license in the ssaasmv5.xml file as follows:

    1. Open the ssaasmv5.xml file which is located in the InformaticaIR/ssaas/ad5 folder.

    2. Configure the Informatica Address Doctor Version 5 license as follows:

      • Go to the <ASM_ADv5_Config> tag.

      • Set the unlock_code value as follows:

        <ASM_ADv5_Config>
    <MAX_THREAD>1</MAX_THREAD>
    <MAX_ADOBJECTS>1</MAX_ADOBJECTS>
    <AD5_UNLOCK_CODE>
        <UNLOCK_CODE>unlock_code</UNLOCK_CODE>
     </AD5_UNLOCK_CODE>
</ASM_ADv5_Config>
        Note: If Informatica Identity Resolution 9.01 is being used on UNIX, the ssaasmv5.xml file has the following blank tag under <ASM_ADv5_CONFIG>, which must either be set with a proper value or completely removed from the ssaasmv5.xml file: <ENRICHMENT_OPTION> </ENRICHMENT_OPTION>

    3. Save the ssaasmv5.xml file.