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

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)

Data Quality Services, DQS, SQL Utility
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

Leave a Reply