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 feature that is available from the domain values screen, enabling you to import knowledge from cleansing projects back to your knowledge base (KB). For more information, see Import Cleansing Project Values into a Domain.
  • Have spelling mistakes in your data? You can now use the ever-favorite Office speller as part of the DQS client, with the familiar squiggle and user interface. For more information, see Use the DQS Speller.
  • Composite Domain rules can now be used to correct values, and not only detect rules violations.
  • Import values from excel – now you can import values together with their synonyms.
  • Have unstructured composite domain values? KB parsing is a new feature that takes advantage of your knowledge for a more accurate parsing. More details on this feature will be posted soon.
  • It’s possible now to modify server log settings through the client UI. For more information, see Configure Severity Levels for DQS Log Files.

Installation Improvements

  • DQSInstaller is now available from the Start menu for an easier DQS server installation.
  • There is no longer a need to explicitly run DQSInstaller with elevated privileges.
  • A new catalog is added during server installation – DQS_STAGING_DATA, as a default store for data processed by DQS. However, other catalogues can be used as well.
  • There is no longer a need to add the 2 DQS internal users to customer catalogues. Catalogues are seamlessly accessible by DQS using the user’s credentials.

And – this release includes significant performance improvements across the system.

Visit the Resource Center page for some useful content to begin with – troubleshooting information, getting started videos, and more. For the full details refer to DQS online help.

Ready to install? Check the DQS installation guide for a clean installation, or the upgrade instructions to upgrade your CTP3 installation.

Feedback and comments are welcome!

The DQS Team

Comments (2)

  1. BI Monkey says:

    I've tested the performance for DQS called by SSIS – findgings here: http://www.bimonkey.com/…/sql-server-data-quality-services-in-sql2012-rc0-part-1 – I think there is still work to do before this is a production ready system for larger data sets. I've raised a connect suggestion to reflect this (connect.microsoft.com/…/data-quality-services-dqs-cleansing-component-performance-too-slow)

    Cheers, James

  2. Jai says:

    I want to create a SSIS package that takes the parameter at run time and then finds this value in DQS and if this value do match to any record then send the output row in matched table. I have created the SSIS but when I send the value in DQS KB then it returns the unmatched output although the value exists in table. Please help me to resolve this task.

Skip to main content