Bookshelf Home | Contents | Index | PDF     

Data Quality Guide for Oracle Customer Hub > Configuring Data Quality with Oracle Data Quality Servers > 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 IIR (<data_type>). Table 52 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.

Table 52. Data Types Supported by IIR
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 53 lists the standardization operations that are supported by IIR.

Table 53. Standardization Operations 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.

      
Data Quality Guide for Oracle Customer Hub Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.