Book Description

Packed with templates, checklists, and real-life examples, this user-friendly guide will provide you with the insights and guidance of an expert consultant, for a fraction of the price. You’ll follow a clearly laid out path from Change Management novice to confident and prepared change manager. You’ll be introduced to the Five Pillars of Change: Sponsorship, Stakeholder Management, Communication, Training, and Organization Design. You will work step-by-step through templates in each pillar to build and run a comprehensive Change Management plan tailor-made to your project and organization.

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

Who this book is for

Best Practices for Deploying and Managing Master Data Services (MDS) Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material presented in this comprehensive guide. Create a process-agnostic solution for managing your business domains Learn how to take advantage of the data modeling capabilities of MDS Manage hierarchies and consolidations across your organization Import data by using SQL Server Integration Services and T-SQL statements Ensure data accuracy and completeness by using business rules and versioning Employ role-based security at functional, object, and attribute levels Design export views and publish data to subscribing systems Use Web services to progrmmatically interact with your implementation

Best Practices for Deploying and Managing Master Data Services (MDS) Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material presented in this comprehensive guide. Create a process-agnostic solution for managing your business domains Learn how to take advantage of the data modeling capabilities of MDS Manage hierarchies and consolidations across your organization Import data by using SQL Server Integration Services and T-SQL statements Ensure data accuracy and completeness by using business rules and versioning Employ role-based security at functional, object, and attribute levels Design export views and publish data to subscribing systems Use Web services to progrmmatically interact with your implementation