Data quality services

A solution to cleanse, match, and enrich data across the enterprise.

  • Improving Data Quality with the New Data Quality Services

    SQL Server Data Quality Services enables you to cleanse, match, standardize, and enrich data, so you can deliver trusted information for business intelligence, data warehouse, and transaction processing workloads.

    What's New in SQL Server 2012

    • Cleanse, match, standardize, and enrich data.
    • End-user created knowledge base.
    • Reference cloud providers with pre-built knowledge rules.

    Key Capabilities

    • Cleanse, Match, Standardize, And Enrich Data

      Rely upon a complete data quality solution to effectively enhance data by reducing data constraints and errors, increasing data standards, and making data quality accessible to everyone within an organization.

      • Cleanse, standardize, and enrich data with user-generated and third-party knowledge.
      • Eliminate data duplication through the matching process.
      • Perform data profiling to identify the quality of your source data.

    • Empower Business End Users To Define Their Own Cleansing Rules Specific To Their Business

      Data Quality Services was built for the business users who understand the data to build their own rules. IT retains oversight and is able to run the rules on the data. To cater to this model, DQS was designed with a simple, wizard-based user interface to populate the knowledge base with the data cleansing rules.

      • End-users directly define the rules and policies for data validation, cleansing, and matching.
      • Minimal setup and preparation time by IT.
      • Data quality results in minutes rather than months.

    • Utilize Cloud Reference Data Providers Who Already Have Pre-built Cleansing Rules

      Data Quality Services was designed to be both standalone as well as integrated with Windows Azure Marketplace for you to instantly access a breadth of third party services that have pre-built cleansing knowledge and rules for you to leverage.

      • Use third party reference data providers that have built-in seamless integration between Windows Azure Marketplace and Data Quality Services.
      • Partner offerings include MelissaData, InfoGroup, Loqate, Digital Trowel, StrikeIron.

    Related Solutions

    "With SQL Server 2012 Master Data Services and SQL Server 2012 Data Quality Services, our master data is automatically validated and refreshed in only a few hours. We can be sure that the data is accurate and more relevant to our customers’ business."

    Dalila Kerkouba
    Enterprise Exchange Domain Manager, IT Department

    Resources