Siebel Data Quality Administration Guide > Configuring Data Quality > Data Quality User Properties >

DQ Sync Services - Business Service User Properties


The DQ Sync Services business service is used when synchronizing data between the Siebel application and Oracle Data Quality Matching Server (Informatica Identity Resolution). The Siebel application uses it to insert records into the NSA table belonging to the Oracle Data Quality Matching Server.

Data quality uses the DQ Sync Services business service user properties listed in Table 18.

Table 18. DQ Sync Services - Business Service User Properties
Name
Value
Comment

Account Integration Object Name

SyncAccount

These business service user properties specify the Integration Objects and Components used by the Siebel application to synchronize with Oracle Data Quality Matching Server (Informatica Identity Resolution).

Account Address Component Name

Account_Business Address

Contact Integration Object Name

SyncContact

Contact Address Component Name

Contact_INS Personal Address

Prospect Integration Object Name

SyncProspect

ISS System Name

siebeldq

These business service user properties specify the default Informatica Identity Resolution system name and IDT table names.

Account IDT Name

IDS_01_IDT_ACCOUNT

Contact IDT Name

IDS_01_IDT_CONTACT

Prospect IDT Name

IDS_01_IDT_PROSPECT

Account Record Length

1090

These business service user properties specify the Account record fields, data type, and length.

Account_DeDupFlds

Name|DUNS Number|Id

Account_DataType

W|W|C

Account_ExtLen

200|120|30

Contact Record Length

1850

These business service user properties specify the Contact record fields, data type, and length.

Contact_DeDupFlds

Birth Date|Cellular Phone #|Email Address|First Name Last Name|Home Phone #|Middle Name|Account|Id|Social Security Number|Work Phone #

Contact_DataType

W|W|W|W|W|W|W|C|W|W

Contact_ExtLen

120|120|120|200|120|200|200|30|120|120

Prospect Record Length

1770

These business service user properties specify the Prospect record fields, data type, and length.

Prospect_DeDupFlds

Account|Cellular Phone #|City|Country|Email Address|First Name Last Name|Home Phone #|Middle Name|Postal Code|Social Security Number|State|Street Address|Work Phone #|Id

Prospect_DataType

W|W|W|W|W|W|W|W|W|W|W|W|W|C

Prospect_ExtLen

200|120|120|60|120|200|120|200|40|120|40|200|200|30

Account_Business Address_DeDupFlds

City|Country|Postal Code|State|Street Address|Address Id

These business service user properties specify the Account Business Address record fields, data type, and length.

Account_Business Address_DataType

W|W|W|W|W|C

Account_Business Address_ExtLen

200|120|120|40|200|60

Contact_INS Personal Address_DeDupFlds

INS Personal City|INS Personal Country|INS Personal Postal Code|INS Personal State|INS Personal Street Address|INS Personal Address Id

These business service user properties specify the Contact INS Personal Address record fields, data type, and length.

Contact_INS Personal Address_DataType

W|W|W|W|W|C

Contact_INS Personal Address_ExtLen

120|40|40|40|200|60

Filter Characters

<Enter characters separated by a single space>

NOTE:  The following special characters are removed automatically from all data (so do not specify them in the DQ Sync Services Business Service user property):
^ (code separator)
| (code separator)
\r (carriage return)
\n (new line)
\t (horizontal tab)
\f (form feed)

This business service user property is used to specify any special characters that need to be removed from data sent to the Oracle Data Quality Matching Server.

NOTE:  Enter all filter characters separated by a single space. For control characters, enter the ASCII code in the following format: ^nnn (where nnn is the code in decimal).

IIR Server on Little Endian Operating System

Yes

This business service user property is used to specify the Endian of the Operating System where the Oracle Data Quality Matching Server is installed.

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