Siebel Data Quality Administration Guide > Configuring Siebel Data Quality > Mapping Data Cleansing Connector Fields to Siebel Business Component Fields >

Data Cleansing Field Mapping Syntax

For data cleansing field mappings, user property names are labeled as:

Vendor_DataCleanse_key name DataCleansing Field n


  • Vendor_DataCleanse_key is the value of the DataCleansing Connector vendor_name user property, for example, the DataCleansing Connector - Firstlogic user property has the value DataCleanse. The vendor_name value must match the value of the Data Cleansing Type server parameter.
  • n is a sequential integer starting from 1.

Each DataCleansing Field user property value consists of two field names enclosed in double quotation marks and separated by a comma and a space:

"Siebel Business Component Field", "Vendor Input Field"

Beginning with version, the field that you specify as the Vendor Input Field is also used as the Vendor Output Field for cleansed data.

CAUTION:  Make sure there is a comma and a space between the field values. Data cleansing can fail if this syntax is not adhered to.

For releases before, each user property value consists of two or three field names enclosed in double quotation marks and separated by a comma and a space:

"Siebel Business Component Field", "Vendor Input Field"


"Siebel Business Component Field", "Vendor Input Field", "Vendor Output Field"

The data cleansing field mappings use two and optionally three values. For some types of data, the connector can use the same field for input and output, while for other types of data the connector must use different fields for input and output. You need to consult with the third-party vendor to learn which field or fields to use. If you do not specify the Vendor output field, the Siebel application does not update the cleansed value to the field.

Examples of the data cleansing field mappings for the Account business component are shown in Table 23.

Table 23. Sample Universal Connector Data Cleansing Field Mappings for the Account Business Component
User Property Name

DataCleansing Connector Firstlogic


DataCleanse DataCleansing Field 1

"Name", "Account.Name"

DataCleanse DataCleansing Field 2

"Location", "Account.Location"

Properties deprecated after 7.8.2 release

namefirm DataCleansing Field 1

"Name", "drl_ifirmname1", "drl_firm_std1"

namefirm DataCleansing Field 2

"Location", "drl_ifirmloc1", "drl_firm_loc_std1"

To map a data cleansing connector field to a Siebel business component field

  1. Start Siebel Tools.
  2. In the Object Explorer, double-click the Business Component object to expand it, and then select the business component of interest.
  3. In the Object Explorer, click Business Component User Prop.

    TIP:   If the Business Component User Prop object is not visible in the Object Explorer, you can enable it in the Development Tools Options dialog box (View > Options > Object Explorer).

  4. In the Business Component User Properties list, create a new record for each field mapping using the syntax for the connector that you are using.
Siebel Data Quality Administration Guide Copyright © 2006, Oracle. All rights reserved.