Skip to content

Latest commit

 

History

History
40 lines (26 loc) · 2.02 KB

enable-data-quality-services-integration-with-master-data-services.md

File metadata and controls

40 lines (26 loc) · 2.02 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic
Enable Data Quality Services Integration
In the Master Data Services add-in for Excel, matching functionality is provided by Data Quality Services (DQS).
CordeliaGrey
jiwang6
12/13/2019
sql
master-data-services
conceptual

Enable Data Quality Services Integration with Master Data Services

[!INCLUDE SQL Server Windows Only - ASDBMI]

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], matching functionality is provided by Data Quality Services (DQS). This functionality must be enabled to be used.

Prerequisites

  • A [!INCLUDEssMDSshort] web application and database must exist.

  • The Data Quality Services feature and the Data Quality Client must be installed on the same [!INCLUDEssNoVersion] instance that hosts the MDS database. For more information, see Install Data Quality Services.

To enable Data Quality Services integration

  1. Open [!INCLUDEssMDScfgmgr].

  2. In the left pane, click Web Configuration.

  3. On the Web Configuration page, select the website and web application.

  4. In the Enable DQS Integration section, click Enable integration with Data Quality Services.

  5. On the confirmation dialog box, click OK.

See Also

Data Quality Matching in the MDS Add-in for Excel
Master Data Services Add-in for Microsoft Excel
Install Master Data Services