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.
Preview in Mapt

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.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$23.10
RRP $32.99
Save 29%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$23.10
$54.99
$29.99p/m after trial
RRP $32.99
RRP $54.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Microsoft SQL Server 2008 R2 Master Data Services Book Cover
Microsoft SQL Server 2008 R2 Master Data Services
$ 32.99
$ 23.10
MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook Book Cover
MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
$ 29.99
$ 21.00
Buy 2 for $35.00
Save $27.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

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

Recommended for You

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook Book Cover
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
$ 26.99
$ 18.90
Microsoft Tabular Modeling Cookbook Book Cover
Microsoft Tabular Modeling Cookbook
$ 32.99
$ 23.10
Practical Data Analysis Book Cover
Practical Data Analysis
$ 29.99
$ 21.00
SQL Server Analysis Services 2012 Cube Development Cookbook Book Cover
SQL Server Analysis Services 2012 Cube Development Cookbook
$ 35.99
$ 25.20
Microsoft SQL Server 2012 Performance Tuning Cookbook Book Cover
Microsoft SQL Server 2012 Performance Tuning Cookbook
$ 35.99
$ 25.20
Getting Started with SQL Server 2012 Cube Development Book Cover
Getting Started with SQL Server 2012 Cube Development
$ 29.99
$ 21.00