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 the following table.
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: ^ (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. |