Wednesday, October 15, 2014

1 Data Quality Services

MSFT introduce DQS from SQL 2012. The main goal is to help to clean the data easily.

After I install the DQS service from SQL Server installation media. I try to connect to DQS through the DQS client but get the error below.

This is because I didn’t configure it.

image

Go to start –> Microsoft SQL Server 2014 –> Data Quality Services –> SQL Server 2014 Data Quality Server Installer

image

This will execute the installation process

image

After the installation, three databases will be created.

image

Then we can use DQS Client to connect

image

image

Below screenshot is taken from Microsoft Virtual Lab : Exploring Master Data Services and Data Quality Services in SQL Server 2014 and Excel 2013

image

image

image

image

image

Reference

http://technet.microsoft.com/en-us/sqlserver/hh780961

1 comments:

  1. Your blog is too good. And your way of mention is so nice. Thanks for sharing this blog. if you want any Historical Options data with split and dividend adjusted stock of history on option able stocks, ETFs and Indices then Click here

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates