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
Keywords: MICROSOFT SQL SERVER, MASTER DATA SERVICES, TYLER GRAHAM, SUZANNE SELHORN, MICROSOFT, MDS, MDM, DATA, SQL SERVER, SQL PASS, PROGRAMMING, INSTALLATION, MODEL, STAGING, HIERARCHY, COLLECTION, EXPLORER, BUSINESS RULES, VERSIONS, EXCEL ADD-IN, SECURITY, SUBSCRIPTION VIEWS, WEB SERVICES, MODELING, MAPPING, SAP R/3 HANDBOOK, IMPLEMENTING SAP ERP SALES & DISTRIBUTION, SAP NETWEAVER PORTAL TECHNOLOGY, BASIS ADMINISTRATION FOR SAP, BUSINESS INTELLIGENCE, BI, CRYSTAL REPORTS 2008 THE COMPLETE REFERENCE, BUSINESSOBJECTS XI THE COMPLETE REFERENCE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, VISUALIZING INFORMATION WITH MICROSOFT OFFICE VISIO 2007, MICROSOFT OFFICE 2007 BUSINESS INTELLIGENCE BUSINESS INTELLIGENCE WITH MICROSOFT OFFICE PERFORMANCEPOINT SERVER 2007, SUCCESSFUL BUSINESS INTELLIGENCE, SAP BUSINESS INFORMATION WAREHOUSE REPORTING, CRCP CRYSTAL REPORTS CERTIFIED PROFESSIONAL ALL-IN-ONE EXAM GUIDE, ORACLE CRM ON DEMAND REPORTING, ORACLE DISCOVERER 10G HANDBOOK, APPLIED SAP BI 7.0 WEB REPORTS, THE POWER TO PREDICT, RESHAPING YOUR BUSINESS WITH WEB 2.0, CRM AT THE SPEED OF LIGHT, EVENT PROCESSING, PRACTICAL MDX QUERIES, HANDS-ON MICROSOFT SQL SERVER 2008 INTEGRATION SERVICES, BUILDING INTEGRATED BUSINESS INTELLIGENCE SOLUTIONS WITH SQL SERVER 2008 R2 & OFFICE 2010, IBM COGNOS 8 BUSINESS INTELLIGENCE: THE OFFICIAL GUIDE, DATA WAREHOUSE DESIGN, ORACLE ESSBASE & ORACLE OLAP, STAR SCHEMA THE COMPLETE REFERENCE, PRACTICAL POWERPIVOT & DAX FORMULAS FOR EXCEL 2010, PRACTICAL MDX QUERIES FOR MICROSOFT SQL SERVER ANALYSIS SERVICES 2008, PRACTICAL SQL QUERIES FOR SQL SERVER 2008, PRACTICAL DMX QUERIES FOR MICROSOFT SQL SERVER ANALYSIS SERVICES 2008