Home > Business Intelligence, Data Quality, Denali > Introduction and Installation of Data Quality Services for Denali

Introduction and Installation of Data Quality Services for Denali

Data Quality Services (DQS)  enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling

DQS is not installed automatically with Microsoft SQL Server Denali CTP3.  You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it.

Basically DQS contains following two comportments

  • Data Quality Server

Installed on top of the SQL Server 2012 Database Engine, and includes three databases which are used in DQS.

  • Data Quality Client

A standalone application that enables you to connect to Data Quality Server, and provides you with a highly-intuitive graphical user interface to perform data-quality operations, and other administrative tasks.

After installation of Data Quality Server with below mentioned steps we will achieve following things on your SQL Server Instance

  • Following databases are created in SQL Server Instance
    • DQS_MAINContains DQS stored procedures, the DQS engine, and published knowledge bases
    • DQS_PROJECTSContains the data quality project information
    • DQS_STAGING_DATA This is staging area where you can copy your source data to perform DQS operations, and then export your processed data
  • Following logins gets created which are used by DQS
    • ##MS_dqs_db_owner_login##
    • ##MS_dqs_service_login##
  • Following roles are created in DQS_MAIN database. If a Master Data Services database is present in the same SQL Server instance as Data Quality Server, a user mapped to the Master Data Services login is created, and is granted the dqs_administrator role on the DQS_MAIN database
    • dqs_administrator
    • dqs_kb_editor
    • dqs_kb_operator
  • The DQInitDQS_MAIN stored procedure is created in the master database.
  • DQS_install.log file is created to record the actions performed on running the DQSInstaller.exe file.

Data Quality Server Installation Steps

  • Locate & execute the DQSInstaller.exe Normally this file is available at C:\Program Files\Microsoft SQL Server\MSSQL11.<instance_name>\MSSQL\Binn. Double click the DQSInstaller.exe
  • You are prompted to type at least 8 characters long password for the database master key. The database master key is required to encrypt the reference data service provider keys that will be stored in the DQS_MAIN database when you set up reference data providers in Data Quality Services (DQS) later.
  • Provide a password, confirm the password, and then press ENTER to continue with the installation.
  • Sit back & relax while DQSInstaller install & configure all things for you.
  • A completion message is displayed. Press any key to close the command prompt window.

Now time to verify DQS installation. Click >> Start >> Microsoft SQL Server Denali CTP3>>Data Quality Client

Connect to your SQL Server Instance where you installed DQS Server.

Explore Data Quality Services with Knowledge Base Management, Data Quality Projects & Administration.

Reference Install Data Quality Services

Will post more Knowledge Base Management, Data Quality Projects & Administration.

Stay tuned….

Sandip Shinde

  1. Anonymous
    May 25, 2012 at 3:24 am

    Nice article… Need to see how it handles on SQL Cluster

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: