SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012

Data Quality Services is very interesting enhancements in SQL Server 2012. My friend and SQL Server Expert Govind Kanshi have written an excellent article on this subject earlier on his blog. Yesterday I stumbled upon his blog one more time and decided to experiment myself with DQS. I have basic understanding of DQS and MDS so I knew I need to start with DQS Client. However, when I tried to find DQS Client I was not able to find it under SQL Server 2012 installation.

I quickly realized that I needed to separately install the DQS client. You will find the DQS installer under SQL Server 2012 >> Data Quality Services directory.

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs1

The pre-requisite of DQS is Master Data Services (MDS) and IIS. If you have not installed IIS, you can follow the simple steps and install IIS in your machine.

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs2

Solarwinds

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs3

Once the pre-requisites are installed, click on MDS installer once again and it will install DQS just fine.

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs4

Be patient with the installer as it can take a bit longer time if your machine is low on configurations.

Once the installation is over you will be able to expand SQL Server 2012 >> Data Quality Services directory and you will notice that it will have a new item called Data Quality Client.  Click on it and it will open the client.

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs6

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs7

SQL SERVER - Installing Data Quality Services (DQS) on SQL Server 2012 dqs8

Well, in future blog post we will go over more details about DQS and detailed practical examples.

Here are relevant blog post to this topic:

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – Winners – Contest Win Joes 2 Pros Combo (USD 198)
Next Post
SQL SERVER – Reseting Identity Values for All Tables

Related Posts

6 Comments. Leave new

  • Is your first screen shot using the install media? Or on disk?

    Reply
  • Thank you for your blog that is very useful. Juste to be accurate, MDS and IIS are not pre-requisites for DQS. It can be installed without MDS. DQS (client and server) doesn’t need IIS : only the MDS Client needs it.

    Reply
  • Hi
    I have a quick query – It would be possible to have the Data Quality Client on a different VM right? I am yet to try out this feature. The reason for asking this question is, our organization have databases deployed on the Active/Active SQL Cluster where IIS is not allowed. Also all connections to the database from the application is done using integrated windows authentication. If we can use Data Quality services, we can avoid direct access of Data Steward accounts to the production database which will raise a security exception for further approval.

    Please reply

    Reply
  • Prabhakar Prasad
    October 1, 2015 6:31 am

    How do I find programmatically using WMI or registry if SQL Data Quality Services is installed

    Reply
  • How we can access DQS remotely.

    Reply
  • How we can access DQS from another computer?

    Reply

Leave a Reply

Menu