Modifying Configuration Parameters for Oracle Data Quality Address Validation Server

The ssadq_cfgasm.xml file contains the global configuration parameters for Oracle Data Quality Address Validation Server. You must modify ssadq_cfgasm.xml in order to map Siebel CRM business components (<bc_field>) to data types supported by IIR (<data_type>). The following table lists the data types that are supported by IIR. For an example ssadq_cfgasm.xml file, see Sample Configuration Files for Oracle Data Quality Matching Server.

Data Type	Meaning
Nobility	For example: Lord, Sir, and so on.
Title	For example: Mr. Mrs, Dr, and so on.
FName	First name
MName	Middle name
LName	Last name
Function	For example: Manager, Director, and so on.
Building	Building name
SubBuilding	Sub building name
HouseNumber	House number
Street1	Street address line 1
Street2	Street address line 2
POBox	Post office box number
DeptLocality	For example: URB, Colonia.
Locality	For example: County
Province	For example: State
Zip	Postal code
Country	Country name

In addition to providing field mappings, the ssadq_cfgasm.xml file defines a standardization operation (<std_operation>) for each field, which controls how the field will be standardized.

The following table lists the standardization operations that are supported by IIR.

Standardization Operation	Description
Upper	Convert text to upper case.
Lower	Convert text to lower case.
Camel	Convert text to camel case (upper case for first letter only)

Use the following procedure to modify configuration parameters for Oracle Data Quality Address Validation Server. This task is a step in Process of Installing the Oracle Data Quality Address Validation Server.

To modify configuration parameters for Oracle Data Quality Address Validation Server

1. Open the ssadq_cfgasm.xml file in a text editor.

2. Use the following syntax to map a Siebel CRM business component field name to a supported IIR data type:

   <Parameter>
    <datacleanse_mapping>
       <mapping>
           <bc_field>AccountName</bc_field>
           <data_type>Organization</data_type>
           <std_operation>Camel</std_operation>
       </mapping>
    </datacleanse_mapping>
   </Parameter>
   

   This example maps the Siebel CRM business component field name AccountName to the supported IIR Organization data type, and defines camel as the standardization operation.

   Repeat this step as required.

3. Save the ssadq_cfgasm.xml file and copy it to the SDQConnector folder on Siebel Server for the changes to take effect:

   siebsrvr/SDQConnector 
   

4. To integrate with the Informatica Address Doctor Version 5 postal directories, add the following tag to the ssadqasm_cfg.xml file located in siebelserver/SDQConnector:

   <Parameter>
       <asm_version>V5</asm_version>
   </Parameter>
   

   When enabling data cleansing, you must add the country LOV value according to how the country is returned by the postal directory after cleansing. For example, if Country USA looks like “UNITED STATES” post cleansing, then you must add the LOV value UNITED STATES to the Country picklist.

   Note: An upgrade from Informatica Identity Resolution 2.7.04 to 2.8.07 should be treated like a new setup. In such cases, install Informatica Identity Resolution 2.8.07 on a new port, create a new system, perform the initial load, start the synchronizer to make it operational, and then delete the current Informatica Identity Resolution 2.7.04 setup.