|
Siebel Data Quality Administration Guide > Configuring Siebel Data Quality > Mapping Data Matching Connector Fields to Siebel Business Components >
Data Matching Field Mapping Syntax for the Universal Connector
For data matching field mappings for the Universal Connector, user property names are labeled as: Vendor_DeDuplication_key DeDuplication Field n where:
- Vendor_Deduplication_key is the value of the DeDuplication Connector vendor_name user property, for example, the DeDuplication Connector - Firstlogic user property has the value Dedup. The vendor_name value must match the value of the DeDuplication Data Type server parameter.
- n is a sequential integer starting from 1.
Each DeDuplication Field user property value consists of a pair of strings enclosed in double quotation marks and separated by a comma and a space: "external vendor field name", "Siebel business component field name"
For example, some of the field mappings for the Account business component are as shown in Table 22.
Table 22. Sample Universal Connector Data Matching Field Mappings for the Account Business Component
|
|
DeDuplication Connector Firstlogic |
"Dedup" |
Dedup DeDuplication Field 1 |
"Account.Name", "Name" |
Dedup DeDuplication Field 2 |
"Account.Location", "Location" |
Dedup DeDuplication Field 3 |
"Account.Street Address", "Street Address" |
Properties deprecated after 7.8.2 release |
match DeDuplication Field 1 |
"MATCH_FIELD_FIRM", "Name" |
match DeDuplication Field 2 |
"MATCH_FIELD_FIRMLOC", "Location" |
match DeDuplication Field 3 |
"MATCH_FIELD_UNPADDRLINE", "Street Address" |
CAUTION: Make sure there is a comma and a space between the two field values. Data matching and data cleansing can fail if this syntax is not adhered to.
For a list of the preconfigured field mappings for Firstlogic, see Preconfigured Field Mappings. To map a data matching connector field to a Siebel business component field
- Start Siebel Tools.
- In the Object Explorer, double-click the Business Component object to expand it, and then select the business component of interest.
- 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).
- 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.
|
