Microsoft SQL Server 2008 R2 Master Data Services

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.

Microsoft SQL Server 2008 R2 Master Data Services

Progressing
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.
$32.99
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook
$29.99 p/month

Subscribe Now

Instantly access this course right now and get the skills you need in 2016

With unlimited access to a constantly growing library of over 3,500 courses, a subscription to Mapt gives you everything you need to get that next promotion or to land that dream job. Cancel anytime.

+ Collection
Free Sample

Book Details

ISBN 139781849680509
Paperback360 pages

Book Description

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.

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

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

Authors

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

Book Details

ISBN 139781849680509
Paperback360 pages
Read More

Read More Reviews