Data Quality in SQL Server 2012 Part 2: Introducing Master Data Services


In the previous blog post, I introduced the concept of Master Data Management as a methodology to improve data quality by creating a “master” version of important information. Master Data Services is Microsoft’s technology for implementing Master Data Management. It is included in SQL Server 2008 R2 Enterprise and SQL Server 2012 Enterprise and Business Intelligence editions. For the sake of this series of posts, I’ll be focusing on the SQL Server 2012 version, since there are quite a few changes.

One of the most fundamental elements of a Master Data Services solution is defining what the master data should be. You have to define what data is important to the company. This information is referred to as entities. For example, you might decide that a customer should be an entity, or a product, or a service offering. Each of these entities then has various attributes, such as contact name, billing address and date of last contact for the customer example. Every individual customer would then be what’s called a member of the entity “Customer.”

A significant part of planning an MDS implementation is working out what these entities are and what are the key attributes associated to the entities. A significant part of the implementation itself is bringing in the members of these entities and making sure that the attributes are properly populated with accurate information.

Master Data Services provides the framework and tools to maintain this data model and these members going forward. There are some core tools that are included in Master Data Services to enable this.

Master Data Manager

 This, as the name implies, is for managing master data. This is the primary tool for Master Data Services, used for creating data models, uploading data, creating business rules and more. It’s a web-based tool, updated in SQL Server 2012 with a nice Silverlight interface.

Master Data Services Configuration Manager

Again, the same sums it up. This tool is used for configuring Master Data Services, specifically the databases and web services. You’ll need to have a database to store master data information, whether the source information, a synchronised copy or just a registry (as discussed in the previous post), and this is the tool you’ll use to set that up.

Master Data Services add-in for Excel

This add-in can be used for a lot of the same functions as the web tool, such as managing entities and uploading data. It’s intended to be accessible to end users while allowing more experience master data professionals to handle data in bulk.

There are other tools for developers around deploying data models and interacting with Master Data Services as a web service. Together, these tools form the technical component of a Master Data Management solution. As I mentioned in the previous post, it’s not enough to just focus on the technology part when implementing one of these solutions. It’s vital to processes by which data quality will be maintained and the people who will be doing it. As part of the planning of an MDS implementation, you should consider who among the users will be making use of each of these tools.  

Part 3: Introducing Data Quality Services

Comments (5)

  1. Harry says:

    Thank You

    The given information is very effective

    i will keep updated with the same

    <a href ="http://www.agrimawebservices.com">web services</a>

  2. Sai Phanindra T says:

    Thank you for the detailed presentation. This really helps us to design our training course more effectively reaching the audience easily – with your details plus adding our expertise on the technology.

    Ref: http://sqlschool.com/DQS-Training.html

    We shall keep updating our training program based on our expertise and hands-on (self R&D) on this awesome technology.

    Thanks Again!

  3. wewerwer says:

    http://www.screencast.com/t/dJki6FCVAPS
    https://www.pinterest.com/pin/50665564535278780/
    https://www.facebook.com/1493395047645501
    https://www.facebook.com/1490972807888824
    https://www.pinterest.com/pin/350647520966519631/
    https://www.facebook.com/1491571851161974
    https://www.facebook.com/1497195077269115
    https://www.facebook.com/1487868358202687
    https://www.pinterest.com/pin/50665564535280272/
    https://www.facebook.com/1483368035319129
    https://www.pinterest.com/pin/350647520966530973/
    https://www.facebook.com/1487840821538774
    http://www.screencast.com/t/8nH5GWAkkif
    https://www.pinterest.com/pin/350647520966519824/
    https://www.facebook.com/1491446037841222
    http://www.screencast.com/t/593BpiYPg
    https://www.pinterest.com/pin/148478118942136965/
    http://www.screencast.com/t/82nyAJC8
    http://www.screencast.com/t/xCLBdFm35oen
    http://www.screencast.com/t/9PbTypi56t
    https://www.pinterest.com/pin/84583299228836231/
    http://www.screencast.com/t/8c72lWPj
    http://www.screencast.com/t/Nd4BjmUW
    http://www.screencast.com/t/qaFEQl1fsTb
    https://www.pinterest.com/pin/160511174196344124/
    http://www.screencast.com/t/3tQTlQAxpxa
    https://www.pinterest.com/pin/19421842120367471/
    https://www.facebook.com/1496451404010149
    http://www.screencast.com/t/b5SV7BRotfd
    http://www.screencast.com/t/3ZDRZnbCTm
    https://www.facebook.com/1490805044572267
    http://www.screencast.com/t/vPvQ7LoIFBLz
    https://www.facebook.com/1490894091230029
    https://www.pinterest.com/pin/442830575838906427/
    https://www.pinterest.com/pin/19421842120367418/
    https://www.facebook.com/1490924644560307
    http://www.screencast.com/t/ZEYqkrmXRfd
    https://www.facebook.com/1496724927316130
    http://www.screencast.com/t/p5VnnWAe
    http://www.screencast.com/t/qEchwz71
    https://www.facebook.com/1496618693993420
    https://www.facebook.com/1484751275183128
    https://www.facebook.com/1493426654309007
    https://www.pinterest.com/pin/50665564535278845/
    https://www.facebook.com/1497199920601964
    http://www.screencast.com/t/NRq2LZsA79vy
    https://www.facebook.com/1496614507327172
    https://www.pinterest.com/pin/148478118942137391/
    http://www.screencast.com/t/ygml5UoNWS
    https://www.pinterest.com/pin/160511174196347869/