United States   Change   |   All Microsoft Sites

Home

SQL Server 2008 R2 Master Data Services

MDM Homepage

MDM Homepage

Overview

Microsoft SQL Server 2008 R2 Master Data Services enables organizations to start with simple solutions for analytic or operational requirements, and then adapt the solutions to additional requirements incrementally.   We support multiple uses of the same data.

Top Features

  • Master Data Hub that provides central management of master data entities and hierarchies and provides a comprehensive role based security model that ensures fine-grained, secure access to master data.

  • Flexible Data Model completely defined in a metadata driven data model. Data administrators are free to define the data model in any way that satisfies the needs of their organization. As new business entities appear or current business entities change, the master data hub data model can change to accommodate the new business requirements.

  • Business Rules that ensure the quality of data entered in the master data hub. The business rules engine is efficient and flexible.

  • Human workflow that notifies assigned owners of business rule violations by email. Notifications can be sent for every violation or grouped together for periodic notification.

  • Versioning of all data entities and hierarchies. New versions can be created by an administrator whenever they are required.

  • Hierarchy Management supports both level-based and ragged parent child hierarchies and is managed by an intuitive drag and drop interface.

  • Security model is flexible and can be enforced at a very granular level.  Security is integrated with Active Directory.

MDM Explorer

MDM Explorer

Project "Bulldog"

In June 2007, Microsoft announced the acquisition of Stratature, a privately held company based in Alpharetta, Georgia, and a leading provider of master data management (MDM) software. This was the first step in Microsoft establishing a presence in the master data management space, and will accelerate Microsoft’s delivery of technology in the MDM market. The Microsoft MDM product codename is “Bulldog”. Bulldog includes Microsoft process and standards applied to the Stratature code base as well as several important new capabilities. Microsoft customers want a solution that leverages their technology investment, integrates with their software assets, is easy to install and maintain, and provides a low total cost of ownership. Bulldog will meet these requirements while building on a long‐term vision for master data management at Microsoft.

On initial scoping, it was determined that 'Bulldog' would ship as part of Microsoft Office SharePoint in the O14 wave.  At TechEd 2009, we announced a change in packaging for the new MDM capabilities. Project 'Bulldog' will now ship as part of the next release of SQL Server codenamed ‘Kilimanjaro’ as 'SQL Server Master Data Services.'

This means that in addition to new capabilities such as Self Service BI and multi-server management, SQL Server ‘Kilimanjaro’ will also provide customers with a rich platform for MDM through SQL Server Master Data Services. Customers who have purchased Software Assurance (SA) should view this as net new value and innovation that they will have access to as a result of their investments in SA.

Additional Resources

 

Take the next step

Download the Essential Backpack
MSDN Developers Start Here