Cleansing your Customer Data using Dun & Bradstreet DQS service

Starting today you can use SQL Server Data Quality Service (DQS) to cleanse data using Dun & Bradstreet (D&B) extensive business information data. This is done using DQS Reference Data Service (RDS) functionality. You can subscribe to the D&B Company Cleanse & Match for Microsoft SQL Server Data Quality Service from Windows Azure Marketplace, then…

2

Extending timeout setting for Reference Data Services (RDS)

DQS, by default, uses connection timeout of 1 minutes when connecting to external Reference Data Services (RDS) provider.  You can modify the timeout setting, using the following steps: Run the following query on SQL Server where DQS is installed: SELECT [ID] ,[SERVICE] ,[NAME] ,[UPDATE_TIME] ,[DESCRIPTION] ,[VALUE] ,[REVISION] FROM [DQS_MAIN].[dbo].[A_CONFIGURATION] where id=916   Click on the value…

0

How to add Reference Data Services in Data Quality Services (DQS)

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality solution. You can define knowledge manually; acquire it from data samples of your organization, or knowledge provided by third party services. We call this Reference Data Services (RDS). DQS makes it easy to cleanse and enrich your data using leading reference data service providers…