190 likes | 386 Views
Introducing SQL Server Master Data Services. Donald Farmer Microsoft. What is Master Data?. What is Master Data Management?. Why do you need MDM?. Add 15 attributes to product xrb019 Information workers can’t edit dimensions. ERP - USA. Resolve XYZ Corp’s Address
E N D
Introducing SQLServer Master Data Services Donald Farmer Microsoft
Why do you need MDM? • Add 15 attributes to product xrb019 • Information workers can’t edit dimensions ERP - USA • Resolve XYZ Corp’s Address • Does product xrb019 = fft019? • Difficulty coordinating multiple systems • Difficulty managing dimensions • Or both ERP - Europe Warehouse or Analytic App
Data Platform Vision • Enterprise Data Platform Services Entity Data Model • Platform For All Data Integration Reporting Master Data Analysis Sync Query Search • Dynamic Development FILE RDBMS OLAP XML Mobile and Desktop • Pervasive Insight CloudStorage Datacenter Enabling customers of all sizes to derive value from ALL data, birth through archival
MDS Management & Stewardship Interface Master Data Services - WCF LOB Application Custom Application WF Workflows SQL Server 2008 R2 Change Notification Service Broker Email Notification SQL Mail Staging & Subscriptions Bulk Operations
Choose your problem So choose your project carefully …
Choose your problem Products are a good place to start …
Common Evolution Pattern Analytic App Master Data Services LOB App(s) 1 1 2 3 3 3 3 3 Critical dimension loaded to MDS. From MDS to analytic apps. Users manage hierarchies and attributes in MDS portal See the benefits of MDS. Begins pushing Master Data back to LOB App. Organization integrates more LOB apps, more analytic apps, and other domains