Creating a Universal Matching Service - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
First publish date
2007
Last updated
2024-03-04
Published on
2024-03-04T22:52:13.486265

A universal matching service is a service that can use any of your match rules to perform matching and can accept any input fields. The service takes a match rule name as an input option, allowing you specify the match rule you want to use in the API call or web service request. The service does not have a predefined input schema so you can include whatever fields are appropriate for the type of records you want to match. By creating a universal matching service you can avoid having separate services for each match rule, enabling you to add new match rules without having to add a service.

This procedure shows how to create a universal matching service and includes an example of a web service request to the universal matching service.

  1. In Enterprise Designer, create a new service dataflow.
  2. Drag an Input stage, a Transactional Match stage, and an Output stage to the canvas and connect them so that you have a dataflow that looks like this:
    Stages in dataflow
  3. Double-click the Transactional Match stage.
  4. In the Load match rule field, select any match rule. For example, you can select the default Household match rule.

    Even though you will specify the match rule in the service request, you have to configure the Transactional Match stage with a default match rule in order for the dataflow to be valid. If you do not select a match rule the dataflow will fail validation and you will not be able to expose it.

  5. Click OK.
  6. Double-click the Output stage.
  7. Choose to expose the fields MatchRecordType and MatchScore.
  8. Click OK.
    Note: There is no need to expose any fields in the Input stage since input fields will be specified as user-defined fields in the service request.
  9. Click Edit > Dataflow Options.
  10. Click Add.
  11. Expand Transactional Match and check the box next to Match Rule.

    This exposes the match rule option as a run-time option, making it possible to specify the match rule in the service request.

  12. Click OK then click OK again to close the Dataflow Options window.
  13. Save and expose the dataflow.

You now have a universal match service that you can use to perform matching using any of the match rules defined in the Match Rules Management tool in Enterprise Designer. When calling the service, specify the match rule in the MatchRule option and specify the input fields as user-defined fields.