Wednesday, October 30, 2013

Mastering MDS with the Master Data Services Operations Guide whitepaper

Blog do Ezequiel - Master Data Services Operations Guide released

A new Master Data Services whitepaper is now published:
http://msdn.microsoft.com/en-us/library/dn520800

...

Master Data Services (MDS) Operations Guide

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)

To review the document, please download the Master Data Services (MDS) Operations Guide Word document and the associated MDS Operations GuideSample.zip file.

Some snaps and snips from the DocX

image

SQL Server 2012 Master Data Services (MDS)

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.

1 comment:

Aline Bernstein said...

This sounds like one of those things that is great in theory but has a big Ugh factor in setting up a simple demo. If only I knew someone who was accustomed to spinning up quick PoC's. Let me see, do I know anyone like that....?