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