Book description
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
Table of contents
- Cover Page
- Microsoft SQL Server 2008 R2 Master Data Services
- Copyright Page
- Contents
- Foreword
- Acknowledgments
- Introduction
- Chapter 1 Introduction to Master Data Services
- Chapter 2 Installation and Configuration
- Chapter 3 Starting an MDS Project
- Chapter 4 Creating Your Model
- Chapter 5 Integrating Master Data Services with Other Systems
- Chapter 6 Working with Hierarchies and Collections
- Chapter 7 Working with Master Data
- Chapter 8 Using Business Rules
- Chapter 9 Creating Versions of Data
- Chapter 10 Using Metadata
-
Chapter 11 Implementing Security
- Security Overview
- Users and Groups
- Administrators
- Testing Permissions
- Functional Area Permissions
-
Model Object Permissions
- Quick Facts About Model Object Permissions
- Best Practice for Model Object Permissions
- Procedure: How to Assign Model Object Permissions
- Procedure: How to Delete Model Object Permissions
- Access to Entities
- Access to Leaf Member Attributes
- Access to Individual Attributes
- Access to an Explicit Hierarchy
- Access to Collections
- Access to Other Model Objects
- Deny Permissions
- Navigational Access
- Deleting Permissions
- Hierarchy Member Permissions
- Determining Which Permissions Apply
- Setting Security by Using Web Services
- Summary
- Chapter 12 Publishing Data to External Systems
- Chapter 13 Extending MDS with Web Services
- Index
Product information
- Title: Microsoft SQL Server 2008 R2 Master Data Services
- Author(s):
- Release date: March 2011
- Publisher(s): McGraw-Hill
- ISBN: 9780071756242
You might also like
book
Microsoft® SQL Server 2008 Management and Administration
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, …
book
Microsoft SQL Server 2005, Compact Edition
SQL Server Compact Edition is a slimmed down version of SQL Server that you can use …
book
A Developer’s Guide to SQL Server 2005
"I come from a T-SQL background, so when I first laid my eyes on SQL Server …
book
Data Mining with Microsoft® SQL Server® 2008
Understand how to use the new features of Microsoft SQL Server 2008 for data mining by …