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
- 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:
|
|
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:
|
|
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:
|
|
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 |
- Apply the Informatica Address Doctor Version 5 license in the ssaasmv5.xml file as follows:
- Open the ssaasmv5.xml file which is located in the
InformaticaIR/ssaas/ad5 folder.
- 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>
- Save the ssaasmv5.xml file.
|