It is a knowledge-driven solution that provides both computer-assisted and interactive ways to manage the integrity and quality of your data sources.
DQS also provides you with profiling that is integrated into its data-quality tasks, enabling you to analyze the integrity of your data. DQS consists of Data Quality Server and Data Quality Client, both of which are installed as part of SQL Server 2016. Data Quality Server is a SQL Server instance feature that consists of three SQL Server catalogs with data-quality functionality and storage. For information about installing DQS, see Install Data Quality Services. If you want to upgrade your existing version of DQS to SQL Server 2016, see Upgrade DQS is a new feature in SQL Server 2012 that provides you with a knowledge-driven data cleansing solution. For more information about DQS, see Introducing Data Quality Services. DQS is available now as part of the SQL Server 2012 RTM release. You can download SQL Server 2012 RTM from here. For detailed information about installing and configuring DQS, see the DQS Installation Guide and watch the installation video. Monitoring enables you to verify that your data quality solution is doing what it was designed to do. For more information, see DQS Administration. Knowledge Base: Data Quality Services is a knowledge-driven solution that analyzes data based upon knowledge that you build with DQS. This enables you to create data quality processes that continually enhances the knowledge about your data and in so doing, continually improves the quality of your data. DQS provides the following features to resolve data quality issues. Data Cleansing: the modification, removal, or enrichment of data that is incorrect or incomplete, using both computer-assisted and interactive processes. Profiling is a powerful tool in a DQS data quality solution. You can create a data quality solution in which profiling is just as important as knowledge management, matching, or data cleansing. For more information, see Data Profiling and Notifications in DQS. DQS provides the following features to resolve data quality issues. Data Cleansing: the modification, removal, or enrichment of data that is incorrect or incomplete, using both computer-assisted and interactive processes. DQS enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling. You can also leverage the cloud-based services of reference data providers in a DQS data-quality project. DQS provides the following features to resolve data quality issues. Data Cleansing: the modification, removal, or enrichment of data that is incorrect or incomplete, using both computer-assisted and interactive processes. The data-quality solution provided by Data Quality Services (DQS) enables a data steward or IT professional to maintain the quality of their data and ensure that the data is suited for its business usage. Data quality is not defined in absolute terms. It depends upon whether data is appropriate for the purpose for which it is intended. DQS identifies potentially incorrect data, and provides you with an assessment of the likelihood that the data is in fact incorrect. Other Versions. SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data. DQS enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers. For information about installing DQS, see Install Data Quality Services. If you want to upgrade your existing version of DQS to SQL Server 2016, see Upgrade DQS is a knowledge-driven solution that provides both computer-assisted and interactive ways to manage the integrity and quality of your data sources. DQS enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling. Data quality is not defined in absolute terms. It depends upon whether data is appropriate for the purpose for which it is intended. DQS identifies potentially incorrect data, and provides you with an assessment of the likelihood that the data is in fact incorrect. DQS is a part of the SQL Server product, and comprises a Data Quality Server and a dedicated Data Quality Client application. DQS also provides a DQS Cleansing component in Integration Services for an integrated easy-to-use cleansing experience. DQS is available now as part of the SQL Server 2012 RTM release. You can download SQL Server 2012 RTM from here. For detailed information about installing and configuring DQS, see the DQS Installation Guide and watch the installation video. Yes, DQS is a knowledge-driven solution that is based on Quality Specific Knowledge Bases that reside in SQL Server. The DQS knowledge base stores comprehensive quality-related knowledge in the form of data domains. DQS is available now as part of the SQL Server 2012 RTM release. You can download SQL Server 2012 RTM from here. For detailed information about installing and configuring DQS, see the DQS Installation Guide and watch the installation video.
https://msdn.microsoft.com/en-us/library/ff877925.aspx http://social.technet.microsoft.com/wiki/contents/articles/3919.data-quality-services-dqs-faq.aspx https://msdn.microsoft.com/en-us/library/ff877917.aspx https://msdn.microsoft.com/en-us/library/ff877917.aspx https://msdn.microsoft.com/en-us/library/ff877917.aspx https://technet.microsoft.com/en-us/library/ff877917(v=sql.110).aspx https://msdn.microsoft.com/en-us/library/ff877925.aspx https://technet.microsoft.com/en-us/library/ff877917(v=sql.110).aspx http://social.technet.microsoft.com/wiki/contents/articles/3919.data-quality-services-dqs-faq.aspx http://social.technet.microsoft.com/wiki/contents/articles/3919.data-quality-services-dqs-faq.aspx
what is dqs