Microsoft SQL Server 2012: Master Data Services, Second Edition
- 4h 23m
- Tyler Graham
- McGraw-Hill/Osborne
- 2012
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 entity specific 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
About the Author
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.
In this Book
-
Introduction to Master Data Services
-
Installation and Configuration
-
Starting an MDS Project
-
Creating Your Model
-
Integrating Master Data Services with Other Systems
-
Working with Hierarchies and Collections
-
Working with Master Data
-
Using Business Rules
-
Creating Versions of Data
-
SQL Server 2012 MDS Add-in for Excel
-
Implementing Security
-
Publishing Data to External Systems
-
Extending MDS with Web Services
-
Advanced Modeling
