3 Replies Latest reply: Feb 27, 2014 9:55 PM by 017958e7-5505-4e43-8643-fa7e4320a288 RSS

Matching on multiple Email address - OEDQ

017958e7-5505-4e43-8643-fa7e4320a288 Newbie
Currently Being Moderated

Hello,

 


We are using EDQ tool for deduplication and data cleansing in realtime.

Real time is configured and working as expected on SVF (i.e. Single Value Fields like First Name, Last Name, Job Title etc).

However we would need deduplication and data cleansing to be done on the email address(es), which is stored in "Communication Address" business component.

 

We have tried couple of approaches but it is not working for mutiple email-address scenarion.

 

Has any one done implemented this kind of scenarion? If yes, then can the steps be shared please?

 

Regards,
Arjun

  • 1. Re: Matching on multiple Email address - OEDQ
    017958e7-5505-4e43-8643-fa7e4320a288 Newbie
    Currently Being Moderated

    More clarity on the requirement:-

    However we would need deduplication and data cleansing to be done for Contact(s) and their email address(es), email address(es) is stored in "Communication Address" business component. And Contact to Email Address is 1:M relation.

  • 2. Re: Matching on multiple Email address - OEDQ
    Nick Gorman Explorer
    Currently Being Moderated

    Hi,

     

    Assuming that you're using a version of Siebel that supports this feature 8.1.1.10 and later [preferably 8.1.1.11] then the high level steps should be as follows:

     

    Using Siebel Tools:

    - Modify DQ Integration Object to add 'Communication Address'

    - Modify the 'DeDuplication' Business Service to add 'Communication Address' to the list of child dedup objects for Conatcts

    - Compile the 'Contact Dedup IO' Integration Object and 'DeDuplication' Business Service

    - Undeploy and the redeploy

     

    In Siebel:

    - Modify third party vendor field mappings and add a new entry for Business Component Name: ‘Communication Address’, Operation: ‘DeDuplication’

    - In the field mappings section, map the 'Address' field to EDQ field 'email'

    - In vendor parameters add a new entry for 'Communication Address DeDup Record Type’ 

    - If you're using UCM then you'll also need to modify the following Integration Object data maps to add a map for 'Communication Address':

    • UCM Contact CIF IO to DQ IO (used by UCM Real-time Process)
    • UCM Contact SDH IO to DQ IO (used by UCM Batch Process)
    • UCM Contact SOAP IO to DQ IO (used by UCM Soap Process)

     

    EDQ Siebel Connector:

    - Modify dnd.properties and add new entries for ‘group.email’, 'group.email.concat' and 'group.email.delimiter' in the ‘Multiple child entity groupings’ section

     

     

    Note that adding new child email addresses won't automatically trigger parent (contact) key gen and deduplication. In order to do this you'll need to automatically update a field on the parent, e.g. last updated.

     

    regards,

    Nick

  • 3. Re: Matching on multiple Email address - OEDQ
    017958e7-5505-4e43-8643-fa7e4320a288 Newbie
    Currently Being Moderated

    Hi Nick,

     

    We have done a detailed analysis, which is as below.

     

    We have created a Contact and associated multiple addresses in Siebel.

     


    Again we have created the same Contact and associated multiple addresses, however there is a common address in between them.

     

    We found that,


    1. In Siebel connector log, the candidate contact record is incomplete i.e. only a limited inforamtion such as Email Address,last Name, First name is present, however there is no individualid [i.e. ROW_ID of that contact] in the data.

    2. We have captured the data in EDQ where externalid for the candidate record is null but it is present for driver record.

    3. For your reference we are attaching the field mappings for Contact and personal address (for deduplciation and daat cleansing).

    4. We have set the Support Multiple Child Entities Deduplication= Yes,


    PS:- If we set Support Multiple Child Entities Deduplication= No, then externaid is populated as expected and realtime is working fine. This we have tested on dummy rule.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points