1. Introducing SQLServer Master Data Services Donald Farmer Microsoft

2. What is Master Data?

4. What is Master Data Management?

5. 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

6. 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

7. Introducing Master Data Services

8. 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

9. Master Data Services - Features

10. Demoed Features

11. Other Features

12. Master Data Methodology

13. Choose your problem So choose your project carefully …

14. Choose your problem Products are a good place to start …

15. MDM Project Drivers

16. Plan your project

17. 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

18. Deployment & Integration

19. question & answer