| title | Enable Data Quality Services Integration |
|---|---|
| ms.custom | seo-lt-2019 |
| ms.date | 12/13/2019 |
| ms.prod | sql |
| ms.reviewer | |
| ms.technology | install |
| ms.topic | conceptual |
| ms.assetid | ab32938d-a80e-4106-80d4-94b2de3d67dc |
| author | lrtoyou1223 |
| ms.author | lle |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
In the [!INCLUDEssMDSshort][!INCLUDEssMDSXLS], matching functionality is provided by Data Quality Services (DQS). This functionality must be enabled to be used.
-
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.
-
Open [!INCLUDEssMDScfgmgr].
-
In the left pane, click Web Configuration.
-
On the Web Configuration page, select the website and web application.
-
In the Enable DQS Integration section, click Enable integration with Data Quality Services.
-
On the confirmation dialog box, click OK.
Data Quality Matching in the MDS Add-in for Excel
Master Data Services Add-in for Microsoft Excel
Install Master Data Services