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
28 April 2012
22 April 2012
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
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.
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.
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
Enter, confirm (and remember) a Database Master Key password:
Wait a couple of miniutes:
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.
Connected:
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 |
Subscribe to:
Posts (Atom)