Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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] ...
  • Blog Post: Languages supported by DQS for Cleansing and Matching

    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...
  • Blog Post: 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...
  • Blog Post: Pattern Matching in DQS Domain Rules

    This post provides you information on how to use the pattern matching rules in DQS while creating domain rules. These are the four pattern matching rules in DQS: For a pattern matching rule: Any letter (A…Z) can be used as a pattern for any letter; case insensitive Any digit (0…9...
  • Blog Post: DQS supported in a SQL Server 2012 cluster

    The SQL Server 2012 Cumulative Update 1 (CU1) release enables support for DQS as part of a clustered SQL Server 2012 setup. Ensure that you install the CU1 release as mentioned under the Resolution section of the following KB article to enable cluster support for DQS: http://support.microsoft.com...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: DQS Performance and Best Practices

    Hi DQS users, I want to draw your attention to the Data Quality Services Performance Best Practices Guide that describes how to get the best performance out of DQS, especially when working with large data volumes. As a knowledge driven product, DQS requires relevant knowledge for doing a good job...
  • Blog Post: SQL Server 2012 RC0 - What's New in DQS?

    SQL Server 2012 RC0 is out there, with a bunch of new DQS features and improvements! In addition to usability improvements and bug fixes, we have introduced the following new features in this release: New Features Import knowledge from a cleansing project to a knowledge base – a new...
  • Blog Post: DQS Blog – TechEd Demo

    Hi everyone, I’ve been getting many requests to publish the files and KBs used in the DQS TechEd presentation (available here ). So I know it’s a bit late, but still – here it is… For those of you who haven’t viewed the presentation yet - the high level story is...
  • Blog Post: Learning Resources for Data Quality Services (DQS) in SQL Server "Denali" CTP3

    We have put together a comprehensive set of learning resources for DQS that you can use to quickly understand/learn things about DQS, install/configure it, and then use it. DQS FAQ We understand that you have a lot of questions about DQS, and that's why we have put together list of frequently...
  • Blog Post: 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...
  • Blog Post: Using the SSIS DQS Cleansing Component

    As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component. This component incorporates the DQS cleansing functionality into an SSIS data flow. When should I use the SSIS DQS Cleansing Component? The DQS Cleansing component can add value when: 1. Cleansing should be performed...
  • Blog Post: Installing and Configuring Data Quality Services

    After you’ve downloaded Denali CTP3, it’s time to install DQS! Here you can find some important information that will help you install and configure DQS successfully. Data Quality Services (DQS) contains three components: DQS server , DQS client , and a DQS Cleansing SSIS component...
  • Blog Post: Introducing Data Quality Services

    Welcome to the SQL Server Data Quality Services Team Blog! SQL Server Data Quality Services (DQS) is the new innovative data quality product delivered as part of SQL Server “Denali” release. DQS is a knowledge-driven data quality solution. I t enables you to build a knowledge base...
Page 1 of 1 (22 items)