Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Microsoft SQL Server 2008 R2 Master Data Services
Jul, 2011 | 360 pages
No titles found
Table of Contents (18 chapters)
Microsoft SQL Server 2008 R2 Master Data Services
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Credits
Foreword
Foreword
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Master Data Management
Master Data Management
Master data
The need for Master Data Management
Master Data Management overview
Data quality
Operational and analytical Master Data Management
Different approaches to Master Data Management
Data governance
Data stewardship
Politics and organizational changes
Summary
References
2
Master Data Services Overview
Master Data Services Overview
Master Data Services overview
Master Data Services architecture
Master Data Manager
Summary
3
Installing and Configuring Master Data Services
Installing and Configuring Master Data Services
Planning for a Master Data Services installation
Installing Master Data Services
Master Data Services Configuration Manager
Installing sample models
Summary
4
Creating and Using Models
Creating and Using Models
MDS object model overview
Models
5
Version Management
Version Management
Introduction to versions
Creating and managing versions
Validating versions
Locking, unlocking, and committing versions
Managing Flags
Transactions
Summary
6
Importing Data into Master Data Services
Importing Data into Master Data Services
The staging load process
Populating MDS step 1—populating the staging tables
Creating new members
Creating new collections
Adding members to collections
Updating member attributes
Deleting a member (or collection)
Populating MDS step 2—invoking the staging process
Populating MDS step 3—validating the model
Clearing the staging tables
Errors in the staging process
Automating the MDS load process with SSIS
Summary
7
Business Rules and Workflow
Business Rules and Workflow
Introduction to MDS business rules
Conditions and actions
Business rules user interface
Creating business rules
Notifications
Workflow and SharePoint
Summary
8
Extracting Data from Master Data Services
Extracting Data from Master Data Services
Introduction
Subscription Views
Delivering master data using BizTalk
Summary
9
Application Programming Interface
Application Programming Interface
Introduction to the MDS API
Getting started with the Web Services API
MDS assemblies
Creating an MDS SharePoint Web Part
SharePoint workflow integration
Summary
10
Master Data Services Security
Master Data Services Security
Master Data Services security overview
User and Group Administration
User and Group Permissions
Summary
Index
Index

Chapter 2. Master Data Services Overview

In this chapter, we will provide an overview of SQL Server 2008 R2 Master Data Services (MDS), outlining the main features of the product as well as covering the architecture. In addition to covering the architecture, the purpose of this chapter is to get the reader comfortable with navigating around the main MDS interface, namely Master Data Manager , before we launch into the detailed modeling topics in further chapters.

In this chapter, we will cover the following:

  • Master Data Services overview

  • Master Data Services architecture

  • Master Data Manager

Previous Section
End of Section 1
Next Section