Transcript Introducing SQLServer Master Data Services

Donald Farmer
Microsoft
What is Master Data?
Key nouns of the business
Slow changing
Shared across systems
People
•
•
•
•
•
•
Customers
Vendors
Employees
Partners
Patients
…
•
•
•
•
Things
Places
Products
Parts
Documents
…
• Stores
• Oil Wells
• Geographical
Regions
• …
Abstract
•
•
•
•
•
Contracts
Warrantees
Time
Metrics
…
What is Master Data Management?
An authoritative view of master data
Creation and management
Software and processes
Between systems and across the enterprise
Why do you need MDM?
•Add 15 attributes to product xrb019
•Information workers can’t edit dimensions
Warehouse or
Analytic App
ERP - USA
•Resolve XYZ Corp’s Address
•Does product xrb019 = fft019?
•Difficulty coordinating multiple systems
•Difficulty managing dimensions
ERP - Europe
•Or both
Data Platform Vision
Services
Enterprise Data Platform
Reporting
Analysis
Platform For All Data
Dynamic Development
Query
Mobile and
Desktop
Integration
Master Data
FILE
RDBMS
OLAP
XML
Datacenter
Sync
Search
Cloud
Storage
Pervasive Insight
Enabling customers of all sizes to derive value from
ALL data, birth through archival
Introducing Master Data Services
Part of SQL Server 2008 R2
CTP November 2009
•More information at
•http://www.microsoft.com/mdm
MDS Management & Stewardship Interface
LOB Application
Master Data Services - WCF
Custom Application
WF Workflows
Change Notification
Service Broker
Email Notification
SQL Mail
Bulk Operations
Staging &
Subscriptions
SQL Server 2008 R2
Master Data Services - Features
Demoed Features
Master Data Portal
Attributes
Hierarchies
Versioning
Model Metadata
Other Features
Notifications
Workflow
Business Rules
Model Deployment
SharePoint Integration
Integration
Security
Master Data Methodology
Envision
Plan
Develop
Stabilize
Deploy
Choose your problem
MDM software is not the whole solution
You need changes in processes
You need changes in policies
So choose your project carefully …
Choose your problem
Does this domain add value?
Can this project be re-used?
Products are a good place to start …
MDM Project Drivers
Domains (Models)
Entities
Attributes
Hierarchies
Subscribing Systems
Security Profiles
Number and Complexity of Workflow Scenarios
Source Systems
Plan your project
Start small
Solve a real problem
Have a sponsor
Engage strong technical resources
Engage knowledgeable business
resources
Common Evolution Pattern
1
1
Master Data
Services
2
LOB App(s)
3
3
Analytic App
3
1. Critical dimension loaded to MDS. From MDS to analytic apps. Users manage
hierarchies and attributes in MDS portal
2. See the benefits of MDS. Begins pushing Master Data back to LOB App.
3. Organization integrates more LOB apps, more analytic apps, and other
domains
Deployment & Integration
question & answer