实现 Data Quality Services 与 Master Data Services 的集成Enable Data Quality Services Integration with Master Data Services

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

Master Data ServicesMaster Data Services用于 Excel 的外接程序Add-in for Excel中,匹配功能由 Data Quality Services (DQS) 提供。In the Master Data ServicesMaster Data Services用于 Excel 的外接程序Add-in for Excel, matching functionality is provided by Data Quality Services (DQS). 此功能必须启用后才能使用。This functionality must be enabled to be used.

先决条件Prerequisites

  • Master Data ServicesMaster Data Services Web 应用程序和数据库必须存在。A Master Data ServicesMaster Data Services web application and database must exist.

  • Data Quality Services 功能和数据质量客户端必须安装在承载 MDS 数据库的同一个 SQL ServerSQL Server 实例上。The Data Quality Services feature and the Data Quality Client must be installed on the same SQL ServerSQL Server instance that hosts the MDS database. 有关详细信息,请参阅 Install Data Quality ServicesFor more information, see Install Data Quality Services.

启用 Data Quality Services 集成To enable Data Quality Services integration

  1. 打开 Master Data Services 配置管理器Master Data Services Configuration ManagerOpen Master Data Services 配置管理器Master Data Services Configuration Manager.

  2. 在左窗格中单击 “Web 配置”In the left pane, click Web Configuration.

  3. “Web 配置” 页上,选择网站和 Web 应用程序。On the Web Configuration page, select the website and web application.

  4. “启用 DQS 集成” 部分中,单击 “启用与 Data Quality Services 的集成”In the Enable DQS Integration section, click Enable integration with Data Quality Services.

  5. 在确认对话框中,单击 “确定”On the confirmation dialog box, click OK.

另请参阅See Also

MDS Add-in for Excel 中的数据质量匹配 Data Quality Matching in the MDS Add-in for Excel
Master Data Services Add-in for Microsoft Excel Master Data Services Add-in for Microsoft Excel
安装 Master Data ServicesInstall Master Data Services