Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

SQL Server 2012 RC0 - What's New in DQS?

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
First published on MSDN on Nov 29, 2011

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 http://msdn.microsoft.com/en-us/library/hh479581(SQL.110).aspx .

  • 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 http://msdn.microsoft.com/en-us/library/hh510403(SQL.110).aspx .

  • 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 http://msdn.microsoft.com/en-us/library/hh510405(SQL.110).aspx .


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 http://msdn.microsoft.com/en-us/sqlserver/ff898410.aspx page for some useful content to begin with – troubleshooting information, getting started videos, and more. For the full details refer to http://msdn.microsoft.com/en-us/library/ff877925(v=sql.110).aspx .


Ready to install? Check the http://msdn.microsoft.com/en-us/library/gg492277(v=SQL.110).aspx for a clean installation, or the http://social.technet.microsoft.com/wiki/contents/articles/5635.aspx to upgrade your CTP3 installation.


Feedback and comments are welcome!


The DQS Team

Updated Mar 25, 2019
Version 2.0
No CommentsBe the first to comment