Data Quality Services (DQS) supports performing data quality operations on your source data only if it is available in:
What if your source data is available on a remote SQL Server database or in some third-party databases such as Oracle or DB2 on a remote computer? Well, you can use the Linked Server feature in SQL Server to access data from these remote sources for DQS operations. The Linked Server feature in SQL Server enables you to remotely access data from diverse sources. For detailed information, see Linked Servers.
DISCLAIMER: Remote access of source data for DQS operations is not tested, and therefore officially not supported by Microsoft. You can use the information in this article at your own risk to use your source data in remote server for DQS operations.
In this article, we will illustrate how you can access data in a table in a remote SQL Server database for DQS operations by using linked servers.
IMPORTANT: For accessing your data from a remote SQL Server database for DQS operations using linked server, it is assumed that a DQS role is assigned to your Windows account and your Windows account has access to the source data in the remote SQL Server instance.
This section provides information about defining the remote server as a linked server in the SQL Server instance where DQS databases are available. To do so:
In this section, we will create a view in the DQS_STAGING_DATA to point to a table containing source data in a remote SQL Server instance that we linked to in step 1.
While performing knowledge discovery, cleansing, or matching activities using the Data Quality Client application, select the DQS_STAGING_DATA as your source database and the linked view that you created in step 3 as your source view in the mapping stage:
DQS Resources on TechNet Wiki
Kumar Vivek edited Original. Comment: Published the article.