Download Microsoft SQL Server 2012 Master Data Services 2 E online

Microsoft SQL Server 2012 Master Data Services 2/E

Tyler Graham

Format: Paperback

Language: English

Pages: 416

Publisher: McGraw-Hill Education; 2 edition (October 30, 2012)

ISBN: 0071797858

Format: PDF / Kindle / ePub

Size: 9.6 MB

Downloadable formats: PDF


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

Similar books