Example of Batch Data Matching Using the Universal Connector

You must run batch mode key generation on all existing records before you run real-time data matching. The Universal Connector requires generated keys in the key tables first before you can run real-time data matching. The key generation is done within the deduplication task, which is the reason for running deduplication on all existing records first. For more information about batch data cleansing and matching, see Batch Data Cleansing and Data Matching.

The following procedure describes how to start a data matching batch job.

To perform batch mode data matching

  1. Follow the instructions in Generating or Refreshing Keys Using Batch Jobs.

  2. At the srvrmgr prompt, enter commands like those in the following table to perform data matching.

    Business Component Example of Server Manager Command

    Account

    run task for comp DQMgr with DqSetting="'Delete'", bcname=Account, bobjname=Account, opType=DeDuplication, objwhereclause="[Name] like 'search_string*'"

    Contact

    run task for comp DQMgr with DqSetting="'Delete'", bcname=Contact, bobjname=Contact, opType=DeDuplication, objwhereclause="[Name] like 'search_string*'"

    List Mgmt Prospective Contact

    run task for comp DQMgr with DqSetting="'Delete'", bcname="List Mgmt Prospective Contact", bobjname="List Mgmt", opType=DeDuplication, objwhereclause="[Name] like 'search_string*'"