Microsoft SQL Server 2012 Master Data Services 2/E e-bog

Deploy and Maintain an Integrated MDS ArchitectureHarness 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 ServicesBuild custom MDS models and entityspecific staging tablesLoad and cleanse data from disparate sourcesLogically group assets into collections and hierarchiesEnsure integrity using versioning and business rulesConfigure security at functional, object, and attribute levelsExtend functionality with SOA and Web servicesFacilitate collaboration using the MDS Excel Add-InExport data to subscribing systems through SQL views