Knowledge-based data cleansing and matching that delivers credible, consistent data
Integrating data from multiple, heterogeneous data sources can bring enormous benefits; however, there are many challenges. The data might have innumerous end user data entry errors, different data standards, less rigid constraints, or might be integrated from third parties over whom you have no control. Incorrect data can result in the business not trusting the underlying data to make the right business decisions causing the entire project to lose credibility. Finally, typical data quality solutions in the market have either been very expensive or labor intensive.
Help ensure data quality
Microsoft SQL Server 2022 Data Quality Services (DQS) is a new offering as part of SQL Server 2022 allowing customers to cleanse, match, standardize, and enrich their data to deliver trusted information for business intelligence, data warehouse, and transaction processing workloads. End users can even cleanse their personal files in unmanaged documents. SQL Server Data Quality Services (DQS) provide an approachable data quality solution for organizations of all sizes to help improve the quality of their data.
It is a user-driven, computer-assisted solution to identify incorrect or incomplete data and modify, remove, or enrich that data to resolve data quality issues.
Empower Business Users
The best knowledge of your data comes from the users of the data, not the IT department. DQS embraces the expert business users through a straightforward wizard-based tool to build knowledge that will populate the data quality knowledge base and enhance subsequent data cleansing operations.
Data stewards can quickly provide an assessment of the likelihood that data is incorrect through a straightforward wizard-based too to add further rules to the knowledge base.
Knowledge-driven data quality
DQS is a knowledge-driven solution. Knowledge can be provided out-of-the box, be generated by your users, or be integrated from the Windows Azure Marketplace Data Market.
By integrating DQS with the Windows Azure Marketplace DataMarket you can automatically send data to the cloud and have your data cleansed or enhanced. Microsoft has signed and certified an ecosystem of providers who have data quality knowledge bases made available in the Windows Azure Marketplace Data Market. These providers have their services pre-integrated from within the DQS product itself allowing users to activate their services seamlessly from the product user interface with very little friction. This gives customers access to a wealth of IP instantly without more work needed.
Complete Enterprise Information Management (EIM) Platform
Finally, SQL Server 2022 has made significant investments for Data Quality Services (DQS) and Master Data Services (MDS) providing the foundation for an end-to-end Enterprise Information Management (EIM) platform. You can integrate DQS as a component of SQL Server Integration Services (SSIS) and into Master Data Services (MDS) workflows.
The SSIS data cleansing transformation applies rules that have already been configured in DQS to a data flow. This allows users to send data from a SSIS workflow to cleanse before sending to the target destination.
Master Data Services (MDS) is the SQL Server solution for master data management. DQS has been integrated into MDS to perform data de-duplication within MDS workflows ensuring the accuracy of master data across the enterprise.
All of these capabilities for a complete EIM platform are provided to customers as a core part of the SQL Server Enterprise database license at no additional cost.