Table 18. DQ Sync Services - Business Service User Properties
|
|
|
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. |