Previous Install Semantic Search Manual Install Install Replication Distributor Next

 

Install Data Quality Services

FineBuild can install Data Quality Services as part of the SQL Server install process.

Data Quality Services is written by Microsoft. It was chosen to be included in FineBuild because it configures a core SQL 2012 component that provides a knowledge-driven data cleansing solution.

The Microsoft SQL Server install process will install the Data Quality Services Client and the Data Quality Services Server components, and some post-installation configuration is needed before the Server component is available for use. The FineBuild processing for Data Quality Services performs this configuration.

The RTM version of Data Quality Services cannot be configured for a Clustered install of SQL Server. It is recommended that you use at least RTM CU1 if you want to install Data Quality Services. The RTM CU1 version introduces support for installing on a cluster and numerous performance and schema improvements.

Data Quality Services home page http://blogs.msdn.com/b/dqs/
Data Quality Services download SQL 2012 CU1 can be downloaded from http://support.microsoft.com/kb/2679368
Data Quality Services tutorial http://blogs.msdn.com/b/dqs/archive/2011/07/21/learning-resources-for-dqs-in-sql-server-denali-ctp3.aspx
Data Quality Services FAQ http://social.technet.microsoft.com/wiki/contents/articles/3919.aspx#Q_1_What_is_data_quality
Data Quality Services video http://www.youtube.com/watch?v=XvEsVxpNadc

FineBuild Data Quality Services Install

Automated installation of Data Quality Services is performed by Process Id 4SM and is controlled by the parameters below:

Install Parameter Build SQL 2005 SQL 2008 SQL 2008 R2 SQL 2012
SetupDQ FULL N/A N/A N/A No
SetupDQ WORKSTATION N/A N/A N/A No
SetupDQ CLIENT N/A N/A N/A No


FineBuild also uses the following parameters to help install Data Quality Services:

Prameter Default Value Description
DQPassword /sapwd: value Password for DQS Administrator. This must comply with normal Windows password rules. It will default to the sa account password if not specified. The password should be recorded in the DBA Password Store.


FineBuild will not by default install Data Quality Services, because most sites do not need this functionality.
If you want FineBuild to install Data Quality Services, then you must add the following parameter when you run FineBuild:

/SetupDQ:Yes

If you are installing on a Cluster, FineBuild will automatically fail over SQL Server to run on the node you are working on in order that the Data Quality Services install can work.

The FineBuild install for Data Quality Services includes the following:


Manual Data Quality Services Install

The following steps show what you would have to do to configure Data Quality Services manually. FineBuild does all of this work for you automatically.

Setup Data Quality Databases

This section will create the Data Quality Services databases and install the DQS CLR routines. In the following commands, if a named instance has been installed, use the instance name in place of MSSQLSERVER

1) If you are installing on a Cluster, SQL Server must be running on the cluster node you are adding to the cluster.

2) Click on Start, then Run, and type CMD to open a Command Window.

3) Type in the drive letter used for the DrvProg parameter

4) Type the following command to navigate to the SQL Server programs folder.

CD "Program Files/Microsoft SQL Server/MSSQL._MSSQLSERVER_/MSSQL/Binn"


5) Run the following command to run the Data Quality Services server configuration program. The password must comply with normal Windows password requirements.

DQSInstaller -instance _MSSQLSERVER_ -catalog "DQS" -password "DQSPassword"

6) When the installation is complete, press Enter to close the DQSInstaller window.

Move Data Quality Log File

The DQS Installer log file is moved to the FineBuild log folder, so that all install log files are in one place.

1) Copy the following file:

Source Destination
DQS_install.log DrvProg:\Program Files\Microsoft SQL Server\FineBuildLogs


Setup Data Quality Security

The DBA sysadmin is given Administrator rights within DQS, and the DBA non-sysadmin group is given Operator rights.

1) Start SQL Server Management Studio (SSMS) and run the following commands to setup DQS Administrator rights

USE DQS_MAIN
GO
CREATE USER _GroupDBA_ FOR LOGIN [GroupDBA]}
EXEC {"SP_ADDROLEMEMBER @ROLENAME='dqs_administrator',"} @MEMBERNAME='GroupDBA'

2) Run the following commands to setup DQS Operator rights

USE DQS_MAIN
GO
CREATE USER _GroupDBANonSA_ FOR LOGIN [GroupDBANonSA]}
EXEC {"SP_ADDROLEMEMBER @ROLENAME='dqs_kb_operator',"} @MEMBERNAME='GroupDBANonSA'


Copyright © 2011 - 2013 Edward Vassie. License and Acknowledgements

Previous Install Semantic Search Top Install Replication Distributor Next

Last edited Mar 22, 2013 at 4:17 PM by EdVassie, version 14

Comments

No comments yet.