A new Master Data Services whitepaper is now published:
Master Data Services (MDS) Operations Guide
Summary: SQL Server Master Data Services (MDS) provides a central data hub that ensures the integrity of information and consistency of data is constant across different applications. With MDS, you can implement a master data management (MDM) hub to manage the master data that is stored in an enterprise database.
This article provides guidance about how to install, configure and manage SQL Server 2012 Master Data Services. You also learn how to deploy a Master Data Services model and create a SQL Server Integration Services (SSIS) solution to monitor MDS.
Published: October 2013
Applies to: SQL Server Master Data Services (MDS), SQL Server Integration Services (SSIS)
Some snaps and snips from the DocX
SQL Server Master Data Services provides a central data hub that ensures the integrity of information and consistency of data is constant across different applications. With MDS, you can implement a master data management (MDM) hub to manage the master data that is stored in an enterprise database.
Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation and restructuring of internal business processes along with the implementation of MDM technology. The result of a successful MDM solution is reliable, centralized data that can be analyzed to uncover insights for better business decisions.
With the right training, most business-domain experts can implement an MDS solution. In addition, you can use MDS to manage any domain; it is not specific to managing lists of customers, products, or accounts. When MDS is first installed, it does not include the structure for any domains—you define the domains you need by creating domain specific models.
Other MDS features include hierarchies, granular security, transactions, data versioning, and business rules.
Master Data Services includes the following components and tools:
- Master Data Services Configuration Manager, a tool you use to create and configure Master Data Services databases and web applications.
- Master Data Manager, a web application you use to perform administrative tasks, such as creating a domain model or business rules, and that user’s access to update data.
- MDSModelDeploy.exe, a tool to create packages containing your model objects and data to deploy to other environments.
- Master Data Services web service, which developers can use to extend or develop custom solutions for Master Data Services.
- Master Data Services Add-in for Excel, which you use to manage data and create new entities and attributes.
I've not yet seen a shop implement MDS, though I'd love to as I sounds like it would solve a number of real world problems... Must remember to point some people I know at this to see if there's any interest.