Siebel Data Quality Administration Guide > Installing Data Quality Products > Process of Installing the Oracle Data Quality Address Validation Server >
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 Informatica Identity Resolution (<data_type> ). Table 5 lists the data types that are supported by Informatica Identity Resolution. For an example ssadq_cfgasm.xml file, see Sample Configuration Files.
Table 5. Data Types Supported by Informatica Identity Resolution
|
|
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. Table 6 lists the standardization operations that are supported by Informatica Identity Resolution.
Table 6. Standardization Operations Supported by Informatica Identity Resolution
Standardization Operation |
|
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
- Open the ssadq_cfgasm.xml file in a text editor.
- Use the following syntax to map a Siebel CRM business component field name to a supported Informatica Identity Resolution 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 Informatica Identity Resolution Organization data type, and defines camel as the standardization operation.
Repeat this step as required.
- Save the ssadq_cfgasm.xml file and copy it to the SDQConnector folder on Siebel Server for the changes to take effect:
siebsrvr/SDQConnector
- 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.
|