Siebel Data Quality Administration Guide > Upgrading to Informatica Identity Resolution 9.01 >

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 ODQ Matching Server NSA table.

Use the following procedure to upgrade your existing ODQ 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.