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.
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.
Once the pre-requisites are installed, click on MDS installer once again and it will install DQS just fine.
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.
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:
- SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS
- SQL SERVER – Why Do We Need Data Quality Services – Importance and Significance of Data Quality Services (DQS)
Reference: Pinal Dave (https://blog.sqlauthority.com)