Thursday, July 20, 2017
 
Updates from DQS Team (Data Quality Service) @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

New Online Course for General Training on The Usage of DQS

Wednesday, January 25, 2017

Hello everyone, We’ve recently published a new online course via edX to provide general training on the usage of DQS.  In this course, you’ll learn why your data needs cleansing, the capabilities and features of DQS, what DQS solution looks like, and how data cleansing integrates with SSIS data flow. Please check it out and let...

Configuring SSIS DQS Domain Value Import

Monday, August 05, 2013

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

Automating DQS Domain Value Import

Monday, August 05, 2013

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

Handling error in SSIS DQS Domain Value Import

Saturday, August 03, 2013

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

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

Tuesday, June 25, 2013

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

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

Monday, June 17, 2013

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

Cleansing Customer Data Using Data Quality Services (DQS)

Friday, June 14, 2013

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

Cleansing your Customer Data using Dun & Bradstreet DQS service

Tuesday, June 11, 2013

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

Extending timeout setting for Reference Data Services (RDS)

Wednesday, April 10, 2013

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

Languages supported by DQS for Cleansing and Matching

Wednesday, March 13, 2013

Data Quality Services (DQS) internally stores the domain values in a knowledge base in the Unicode format, and uses the trigram algorithm, which is language agnostic, to compare the domain values with your source data for the cleansing and matching operations. Therefore, you can practically use DQS to cleanse and match data in all the...

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM