Installing and Configuring Master Data Services | Microsoft SQL Server 2008 R2 Master Data Services

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Microsoft SQL Server 2008 R2 Master Data Services

4.3 (4)

Microsoft SQL Server 2008 R2 Master Data Services

4.3 (4)

Overview of this book

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

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

Master Data Services Overview

Master Data Services Overview

Master Data Services overview

Master Data Services architecture

Master Data Manager

Summary

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

Creating and Using Models

Creating and Using Models

MDS object model overview

Models

Version Management

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

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

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

Extracting Data from Master Data Services

Introduction

Subscription Views

Delivering master data using BizTalk

Summary

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

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 3. Installing and Configuring Master Data Services

Now comes the time for us to get Master Data Services installed. This chapter contains a step-by-step installation guide for MDS, as well as an explanation of the configuration settings. Finally, we will finish up by installing the samples that come with the product.

In this chapter, we will cover the following topics:

Planning for a Master Data Services installation
Installing Master Data Services
Master Data Services Configuration Manager
Installing sample models

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Microsoft SQL Server 2008 R2 Master Data Services

Search

Your notes and bookmarks