1. Data Quality Administration Guide
  2. sdq_dedup_realtime Function

sdq_dedup_realtime Function

This function is called to perform real-time data matching when match candidate acquisition takes place in Siebel CRM.

This function sends the data for each record as driver records and their candidate records. The function is called only once; multiple calls to the vendor library are not made even when the set of potential candidate records is huge. As all the candidate records are sent at once, all the duplicates for a given record are returned.

Item Description
Syntax 
int sdq_dedup_realtime (int session_id, SSchar* parameterList, SSchar* 
inputRecordSet, SSchar* outputRecordSet)
Parameters

  • session_id: The session ID obtained by initializing the session.

  • parameterList: An XML character string that contains the list of parameters and values that are specific to this function call. An XML example follows:

    <Data>
 <Parameter>
    <Name>RealTimeDedupParam1</Name>
    <Value>RealTimeDedupValue1</Value>
 </Parameter>

 <Parameter>
    <Name>RealTimeDedupParam2</Name>
    <Value>RealTimeDedupValue2</Value>
 </Parameter>
</Data>
Note: The parameterList parameter is set to NULL as all required parameters are already set at the session level.

  • inputRecordSet: An XML character string containing the driver record and candidate records. An XML example follows:

    <Data>
 <DriverRecord>
    <Account.Id>1-X42</Account.Id>
    <Account.Name>Siebel</Account.Name>
    <Account.Location>Headquarters</Account.Location>
 </DriverRecord>

 <CandidateRecord>
    <Account.Id>1-Y28</Account.Id>
    <Account.Name>Siebel</Account.Name>
    <Account.Location>Atlanta</Account.Location>
 </CandidateRecord>
 <CandidateRecord>

    <Account.Id>1-3-P</Account.Id>
    <Account.Name>Siebel</Account.Name>
    <Account.Location>Rome</Account.Location>
 </CandidateRecord>
</Data>

  • outputRecordSet: An XML character string populated by the vendor in real time that contains the duplicate records with the scores. An XML example follows:

    <Data>
 <DuplicateRecord>
    <Account.Id>SAME ID AS DRIVER </Account.Id> 
    <DQ.MatchScore></DQ.MatchScore> 
 </DuplicateRecord>

 <DuplicateRecord>
    <Account.Id>1-Y28</Account.Id>
    <DQ.MatchScore>92</DQ.MatchScore>
 </DuplicateRecord>

 <DuplicateRecord>
    <Account.Id>1-3-P</Account.Id>
    <DQ.MatchScore>88</DQ.MatchScore>
 </DuplicateRecord>
</Data>
Return Value

A return value of 0 indicates successful execution. Any other value is a vendor error code. The error message details from the vendor are obtained by calling the sdq_get_error_message function.