Free Sample
+ Collection

Microsoft SQL Server 2008 R2 Master Data Services

Jeremy Kashel, Tim Kent, Martyn Bullerwell

Written by two leading Microsoft SQL Server specialists, this book will empower you to manage and maintain the data used for critical business decisions through an understanding of Master Data Services. A comprehensive, totally practical tutorial.
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849680509
Paperback360 pages

About This Book

  • Gain a comprehensive guide to Microsoft SQL Server R2 Master Data Services (MDS) with this book and eBook
  • Explains the background to the practice of Master Data Management and how it can help organizations
  • Introduces Master Data Services, and provides a step-by-step installation guide
  • Covers all features of Master Data Services, including hierarchy management, importing/exporting data, the MDS API, and business rules
  • Includes practical examples that guide the reader on how to use each feature of the product

Who This Book Is For

If you are a business and systems analyst or database administrator who wants to manage and maintain your business master data and improve data quality with Microsoft SQL Server Master Data Services, then this book is for you. A basic understanding of Microsoft SQL Server is required. However, knowledge of Master Data Services is not necessarily required.

Table of Contents

Chapter 1: 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
Chapter 2: Master Data Services Overview
Master Data Services overview
Master Data Services architecture
Master Data Manager
Chapter 3: 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
Chapter 4: Creating and Using Models
MDS object model overview
Chapter 5: Version Management
Introduction to versions
Creating and managing versions
Validating versions
Locking, unlocking, and committing versions
Managing Flags
Chapter 6: 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
Chapter 7: Business Rules and Workflow
Introduction to MDS business rules
Conditions and actions
Business rules user interface
Creating business rules
Workflow and SharePoint
Chapter 8: Extracting Data from Master Data Services
Subscription Views
Delivering master data using BizTalk
Chapter 9: 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
Chapter 10: Master Data Services Security
Master Data Services security overview
User and Group Administration
User and Group Permissions

What You Will Learn

  • Understand the foundational concepts of Master Data Management and SQL Server
  • Learn how to install and configure Master Data Services
  • Create and populate your first Model
  • Learn how to create and manage Hierarchies and Collections
  • Extend your Models with User-defined Meta Data
  • Control your Master Data Environment through the use of Versions and Flags
  • Discover how to import data from a variety of source systems by using SQL Server Integration Services (SSIS)
  • Extend your solution with business rules, e-mail notifications, and SharePoint workflow
  • Create custom solutions by utilizing the Master Data Services API
  • Feed different source systems by using Subscription Views and BizTalk Server
  • Secure your Master Data Services Models with comprehensive MDS security

In Detail

Microsoft SQL Server Master Data Services (MDS) enables organizations to manage and maintain business data used to make critical business decisions. MDS is a Master Data Management (MDM) application, which standardizes and streamlines the critical data entities of an organization, essentially centralizing your master data.

A focused, practical tutorial, this book will show you how to manage and maintain your organization's master data and improve data quality with Microsoft SQL Server 2008 R2 Master Data Services. Using credible techniques and an end-to-end approach, this book will take you through the steps required to implement Master Data Management, enabling business users to standardize and streamline their business data.

This book will enable you to manage and maintain your organization's master data with Microsoft SQL Server 2008 R2 Master Data Services, covering each feature in a step-by-step manner. The book starts with an overview of Master Data Management. You will then move on to an overview of Microsoft SQL Server 2008 R2 Master Data Services (MDS). The book then dives deep into topics such as installing, configuring, and maintaining Master Data Services, creating and using Models, Version Management, Business Rules, and importing Data into Master Data Services amongst others.


Read More