How to reuse a DQS Domain

Q: I have created a Domain in a Knowledge Base that I want to reuse it in other Knowledge Bases. Can I copy & paste a domain from one Knowledge Base into an other?

A: You can export and import a domain.
- Go to the domain you want to reuse.
- Right click the domain and select [Export] and then [Export Domain].
- Choose a location and filename and click [Save]
- Close the current Knowledge Base and open the new Knowledge base
- Click on the import domain button and select the exported file.

In this video example I 'copy' the Country Domain from the DQS sample Knowledge Base:

How to remove a Knowledge Base

Q: How do I remove a redundant DQS Knowledge Base?

A: Go to [Open Knowledge Base], Right-click your redundant Knowledge Base and select "Delete".



Data Quality Services Client : 11.0.2100.60
Data Quality Services Server : 11.0.2100.60

DQS performance hotfix

There is a new Hotfix available for DQS to boost the performance for large datasets (> 1.5 million records): http://support.microsoft.com/kb/2679368/en-us

FIX: Slow performance when you use DQS to perform a data cleansing against a large data source in SQL Server 2012. More info.

Don't forget to run DQSInstaller.exe-Upgrade after installation

Installing DQS

First installation
DQS is only available in the Enterprise Edition and in the Business Intelligence Edition. When installing SQL Server 2012 you can find Data Quality Services under Instance Features and Data Quality Client under the Shared Features.

DQS - Service and Client

Second installation
When you finished your SQL Server installation you need to do a second installation. In the start menu you will find in the Data Quality Services folder an installation shortcut.

Start menu - DQS

Clicking this will install DQS with a default collation (SQL_Latin1_General_CP1_CI_AS). If you want an other collation you need to install DQS via the command prompt:
dqsinstaller.exe –collation Finnish_Swedish_CS_AS

DQS installation 'interface'

Enter, confirm (and remember) a Database Master Key password:

Database Master Key password

Wait a couple of miniutes:

Finished

The result
If you open SQL Server Management Studio (SSMS) and explorer the instance where DQS was installed you see three new databases.

Connecting with Data Quality Client tool
Now you can use the Data Quality Client to connect to DQS. If you try to login to your local machine and you get a System.Data.SqlClient.SqlException (0x80131904), then you probably got multiple SQL instances or the windows service SQL Server (SQL2012) wasn't started.

Add intance name in case of multiple SQL intances

Connected:

Connected to local DQS