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.