Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips













































   Got a SQL tip?
            We want to know!

Introduction to Master Data Services in SQL Server 2008

MSSQLTips author Tim Cullen By:   |   Read Comments (2)   |   Related Tips: More > Master Data Services
Problem

So, between all of my company's recent growth and more acquisitions looming in the horizon, I feel like the company's data is getting out of hand. There are numerous databases housing the same information and it's getting quite difficult to keep everything in line. I've heard from a number of departments who want a more centralized approach to handling customer data, but I don't know where to begin. Can you steer me in the right direction?

You just ran into one of the biggest headaches for DBA's. If we've seen it once we've seen it a thousand times, data starts out in a spreadsheet in each department and then each department wants their own database. Then "it" happens, a client orders product and the order is shipped to the wrong location. The salesperson said he updated the shipping address in the database, but the Shipping Department shipped the product to an address from their database that hasn't been updated in months.

Solution

What we're talking about here is Master Data Management and there are a number of ways to handle it. Microsoft has a new answer to Master Data Management...Master Data Services, thanks to the acquisition of Stratature. Master Data Services will be released in SQL Server 2008 R2, but before we dive into the innards of Master Data Services, let's talk about the principles of Master Data Management.

What Is Master Data Management?

In simple terms, Master Data Management (MDM) is a process through which consistent, clean, up-to-date data is managed within an organization; however, "simple terms" does not mean "simple to implement". The fact of the matter is that Master Data Management is a process that starts out small and progresses as lessons are learned by the company. A number of factors are involved when evaluating data for consideration as "master data". It's probably easier to sift through your data and decide what isn't master data. One of the first steps in implementing a Master Data Management System is to decide that a Master Data Management process is actually needed!! In most cases the answer will be yes, but implementation of a MDM can be quite costly, both in terms of development as well as personnel hours, so it would be prudent to spend time justifying the need.

Who Should Be Involved With Implementation of a MDM?

Other than the DBA, personnel who understand the data and its sources should be involved in the planning and implementation process. They are considered data stewards. Other people include management and important stakeholders in the data, since there are financial and personnel considerations when developing and implementing a master data management program.

What Are the Important Buzzwords With Master Data Services?

Most of the "buzzwords" you'll hear when dealing with Master Data Services are used in other data modeling techniques:









So What's A Good Way to Get Started At Reviewing Our Data?

Perhaps the first place to look is for tables that are stored in multiple databases. Examples may include, but are not necessarily limited to, information on state and territories, zip codes, and domain-based information like colors, sizes, and contact types. The next bit of data to review could be the essential data required for identifying your customers, as well as the data required to get your products to clients, including contact names, company addresses, and phone numbers.

Are There Any Limitations For Installing and Using Microsoft's Master Data Services?

Before you get too excited about using Master Data Services there are some limitations for installing and using it. First, Master Data Services will only be available for SQL Server 2008 R2 DataCenter, Enterprise, and Developer editions. Second, it will only be available for x64 versions of SQL Server. Lastly, the minimum framework it requires is the .NET Framework 3.5 SP1.

Next Steps


Last Update: 6/4/2010


About the author
MSSQLTips author Tim Cullen
Tim Cullen has been working in the IT industry since 2003 and currently works as a SQL Server Reports Developer.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Comments and Feedback:
Tuesday, May 20, 2014 - 11:41:38 AM - sajeev Read The Tip

Is MDS avaliable with SQL Server 2008 (NOT SQL 2008 R2). If it is avialbale how can i install MDS, is it seperate installation or it along with SQL Server set up?

 


Tuesday, May 20, 2014 - 12:17:01 PM - Tim Cullen Read The Tip

Unfortunately it is only available in 2008 R2 and later.



Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email Notify for updates



Comments
Get free SQL tips:

*Enter Code refresh code


 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.