Microsoft SQL Server 2012 Master Data Services 2/E

Front Cover
McGraw Hill Professional, Oct 16, 2012 - Computers - 416 pages
0 Reviews
Deploy and Maintain an Integrated MDS Architecture

Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012 Master Data Services, Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide.

  • Install Microsoft SQL Server 2012 Master Data Services
  • Build custom MDS models and entityspecific staging tables
  • Load and cleanse data from disparate sources
  • Logically group assets into collections and hierarchies
  • Ensure integrity using versioning and business rules
  • Configure security at functional, object, and attribute levels
  • Extend functionality with SOA and Web services
  • Facilitate collaboration using the MDS Excel Add-In
  • Export data to subscribing systems through SQL views
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction to Master Data Services
1
Installation and Configuration
11
Starting an MDS Project
41
Creating Your Model
55
Integrating Master Data Services with Other Systems
97
Working with Hierarchies and Collections
125
Working with Master Data
159
Using Business Rules
189
Creating Versions of Data
235
SQL Server 2012 MDS Addin for Excel
255
Implementing Security
281
Publishing Data to External Systems
325
Extending MDS with Web Services
337
Advanced Modeling
361
Index
371
Copyright

Other editions - View all

Common terms and phrases

About the author (2012)

Tyler Graham is Director of Industry Solutions for the Profisee Group, a master data management software company focused on delivering enterprise-grade MDM capabilities on the MDS platform. He moved to Profisee after completing the latest release of Master Data Services as a Senior Program Manager for Microsoft. He has spent more than ten years in the data management space and is a frequent speaker at conferences.

Bibliographic information