1 / 19

Introducing SQL Server Master Data Services

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

meris
Download Presentation

Introducing SQL Server Master Data Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing SQLServer Master Data Services Donald Farmer Microsoft

  2. What is Master Data?

  3. What is Master Data Management?

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

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

  6. Introducing Master Data Services

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

  8. Master Data Services - Features

  9. Demoed Features

  10. Other Features

  11. Master Data Methodology

  12. Choose your problem So choose your project carefully …

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

  14. MDM Project Drivers

  15. Plan your project

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

  17. Deployment & Integration

  18. question & answer

More Related