Startseite | Impressum

Master Data Management

Die "SQL Server 2008 R2 Master Data Services" zählen zu den wesentlichen Neuerungen im SQL Servers 2008 R2 neben Business Intelligence. Microsoft verfolgt mit den Master Data Services das Ziel die Stammdaten (Kunden, Produkte) unterschiedlicher Unternehmensanwendungen an zentraler Stelle aktuell, korrekt, ohne Duplikate und konsistent verwalten lassen

Im bieten den SQL Server 2008 R2 Master Data Services folgende Funktionen:

>> Ein Master Data Hub, über den sich Stammdaten und ihre Hierarchien verwalten lassen. Ein Rollen-basierendes Sicherheitsmodell soll den Zugriff detailliert steuern helfen.
>> Ein flexibles Datenmodell, das sich vom Administrator an die speziellen Anforderungen im Unternehmen anpassen lässt.
>> Anhand von Geschäftsregeln können Unternehmen die Aktualisierung von Stammdaten steuern.
>> Anwender können automatisiert per E-Mail über Verletzungen von Geschäftsregeln informiert werden.
>> Versionierung aller Datensätze und Hierarchien.
>> Hierarchieverwaltung über ein Drag-and-drop-Interface.
>> Granuläres Sicherheitsmodell und Verwaltung der Benutzerdaten über das Active Directory.

Wer wissen möchte was MDM ist oder was MDS von Microsoft mit SQL Server 2008 R2 bringt findet hier Infos:
MDM Artikel:
The What, Why, and How of Master Data Management
Master Data Management (MDM) Hub ArchitectureSQL Server 2008 R2 Master Data Services

Public website: http://www.microsoft.com/sqlserver/2008/en/us/mds.aspx
MSDN Forum: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=519&SiteID=1

Kirk’s blog: http://sqlblog.com/blogs/knightreign/default.aspx
Roger’s blog: http://blogs.msdn.com/rogerwolterblog/default.aspx

White papers zu Master Data Services SQL 2008 R2

New Master Data Services white papers are available on MSDN.

This series of technical articles describes Organizational Approaches to Master Data Management, for SQL Server 2008 R2.

* Master Data Management from a Business Perspective
* Master Data Management from a Technical Perspective
* Bringing Master Data Management to the Stakeholders
* Implementing a Phased Approach to Master Data Management
Download a PDF version or an XPS version of this article from the Microsoft Download Center.


Master Data Management from a Business Perspective
This article helps business stakeholders understand how to determine the master data management needs of their organization. After reading this article, business stakeholders should be empowered to define a high level vision for implementing a master data management solution within their organization.



Master Data Management from a Technical Perspective
This article provides a technology-centric view of master data management concepts, including possible implementation techniques. After reading this paper, information technology professionals should be able to accurately define the master data management problem for their organizations and have a vision for what the solution may be. They should be able to engage the business and recognize the proper role that IT must play in this process long term.

Bringing Master Data Management to the Stakeholders
This article provides information about the organizational challenges of implementing a master data management solution. Data governance and data stewardship provide a central role in the success of master data management within an organization. The right combination of people, processes, and policies can play as important a role as any software implementation. Working with the stakeholders to generate acceptance and ownership can go a long way to creating a successful master data management project.

Implementing a Phased Approach to Master Data Management
This article provides common ways to approach master data management so that it has the best chance of being successful. These examples include implementing a departmental solution that spreads across an organization and implementing a global project based on regions.

  Microsoft Business Intelligence Portal von New Elements GmbH