Configuring SSIS DQS Domain Value Import

In the previous blog article, I described how to use the free SSIS DQS Domain Value Import from OH22 data to automate importing values into a DQS Knowledge Base domain. In this article, I will go over the optional configuration to import invalid/error value types as well as to set synonyms. First, let’s quickly recap the domain…

7

Automating DQS Domain Value Import

There are times when you may want to update a DQS Knowledge Base through an automated process. For example, you add new products in your ERP system and you would like to make sure the new product names are added to DQS Knowledge Base automatically. A free codeplex project, SSIS DQS Domain Value Import, from OH22…

0

Handling error in SSIS DQS Domain Value Import

In the previous blog article, I described how to use SSIS DQS Domain Value Import. An error may occur during the execution of the project due to problems with the data. There are several available configuration options to deal with the error, related to: Flow Execution Status Logging Knowledge Base publication Flow Execution Status In…

1

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 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

Upgrading DQS to SQL Server 2012 Service Pack 1 (SP1) Release

This post provides information about the Data Quality Services (DQS) improvements in the SQL Server 2012 Service Pack 1 (SP1) release, and step-by-step instructions to upgrade your current installation of DQS to the SP1 release. The steps to upgrade from the SQL Server 2012 RTM or any of the cumulative update (CU) releases to the SP1 release…

1

Excessive database growth issue fixed in DQS in the CU2 Release for SQL Server 2012

The Cumulative Update 2 (CU2) release for SQL Server 2012 is out, and it fixes a DQS issue where the DQS_PROJECTS database use to grow excessively during the knowledge discovery or the cleansing activity. For detailed information about this issue, see http://support.microsoft.com/kb/2685743. You can download and install CU2 release from here: http://support.microsoft.com/kb/2703275. Note: Before installing…

3

DQS on the Twelve Days of SQL Server 2012

Call to Action: When you’re done reading this article and checking out the resources it references, please take a moment to comment and let the DQS team know what additional resources you would like provided. If there’s a topic you would like covered in a blog post or webcast or demo, we want to know…


Significant Performance Improvements in DQS with the Cumulative Update 1 (CU1) Release for SQL Server 2012

DQS performance has significantly improved with the release of Cumulative Update 1 (CU1) for SQL Server 2012. The latest DQS Performance Best Practices Guide with the updated performance numbers and other useful information is now available on the Microsoft Download Center: http://www.microsoft.com/download/en/details.aspx?id=29075. Below are the comparative DQS performance numbers between the SQL Server 2012 RTM and CU1 releases: Data…

2