Automating the data matching process in SQL Server Data Quality Services (DQS)

OH22 data has just released a free SSIS transform task for SQL Server Data Quality Services (DQS) matching. The solution is published on codeplex. With this custom transform task, you can use the Knowledge Base (KB) created in DQS to automate data matching through SSIS.     In this article, I am going to walk through using…

23

Matching related and duplicate Customer Records using SQL Server Data Quality Services (DQS)

SQL Server Data Quality Services (DQS) enables you to match records using your matching rules defined in DQS Knowledge Base. There are two common use cases where you would like to match related records. One is to identify duplicate in your records, such as same customers appear as separate records in your dataset. Another common…

3

Cleansing Customer Data Using Data Quality Services (DQS)

SQL Server 2012 Data Quality Services (DQS) enables you to cleanse data using your own Knowledge Base. In this blog article, I am going to show how to create a simple Knowledge Base which you can use to cleanse your customer data. The steps for using DQS to cleanse data is as follows: A. Create…

15

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