Bookshelf Home | Contents | Index | PDF     

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
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.

Table 6 lists the standardization operations that are supported by Informatica Identity Resolution.

Table 6. Standardization Operations Supported by Informatica Identity Resolution
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 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.

  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.

    
Siebel Data Quality Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.