PacktLib: Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server 2008 R2 Master Data Services

Credits

Foreword

About the Authors

About the Reviewers

www.PacktPub.com

Preface

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

Master Data Services Overview

Master Data Services overview

Master Data Services architecture

Master Data Manager

Summary

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

Creating and Using Models

MDS object model overview

Models

Version Management

Introduction to versions

Creating and managing versions

Validating versions

Locking, unlocking, and committing versions

Managing Flags

Transactions

Summary

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

Business Rules and Workflow

Introduction to MDS business rules

Conditions and actions

Business rules user interface

Creating business rules

Notifications

Workflow and SharePoint

Summary

Extracting Data from Master Data Services

Introduction

Subscription Views

Delivering master data using BizTalk

Summary

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

Master Data Services Security

Master Data Services security overview

User and Group Administration

User and Group Permissions

Summary

Index