mds enables users to curate sets of objects. this capability is powerful in a wide variety of...
TRANSCRIPT
MDS Overview
Yair HelmanPricipal Group ManagerMaster Data ServicesMicrosoft Corporation Microsoft
SQL Server 2012®
®
What is Master Data?
• Master Data is the set of data objects that are at the center of business activities (Customers, Products, Cost Centers, Locations, Assets, Tasks …) requiring• Continuous quality management • Central curation• Ease of access for business users• Effective sharing (producing and consuming)
• Master Data contains different attributes for distinct usage (marketing, finance, operations, business groups…)
MDS enables users to curate Sets of Objects. This capability is powerful in a wide variety of scenarios
across all organization levels
Main Scenarios
Data Solutions
Provides storage and management of the objects and metadata used as the application knowledge
• Object mappings
• Reference Data / managed object lists
• Metadata management / data dictionary
Data Warehouse / Data Marts Mgmt
Operational Data ManagementEnable business users
to manage the dimensions and hierarchies of DW / Data Marts
• BI scenarios
Central data records mgmt and consumption sourced by other operational systems
A company has adopted 6 “best of breed” systems from different vendors. They need to be able to propagate the correct customer information to each system in a consistent way.MDS provides a platform for central schema, integration points and validation for SI/ISV/Internal IT to develop a custom solution
Main ScenariosData Management Solutions
Data Warehouse/ Data Marts Mgmt
Enable business users to manage the dimensions and hierarchies of DW / Data Marts
• BI scenarios
Canonical form System A System B
Product ID
Product Name Color Size ID Name Price ID Name
The IT department has built a data warehouse and reporting platform, but business users complain about the correctness of the dimensions and lack of agility in making updates.MDS empowers the business users to manage dimensions themselves while IT can govern the changes
Provides storage and management of the objects and metadata used as the application knowledge
• Object mappings
• Reference Data / managed object lists
• Metadata management / data dictionary
Table containing information on mapping objects between different systems. ETL processes are referencing the table making transformation decisions. MDS enables business users to manage the objects mapping
Versioning
ValidationAuthoring business rules to ensure data
correctness Modeling
Entities, Attributes, Hierarchies
Enabling Integration & Sharing
MDS Capabilities
MDSRole-based Security
and Transaction Annotation
Master Data Stewardship
External (CRM, ..)Excel DWH
Loading batched data
through Staging Tables
Consuming data through
Views
Registering to changes
through APIs
Excel Add-In
Web UIData Matching
(DQS Integrated)
Workflow / Notifications
MDS Architecture
MDS Database
Entity BasedStaging Tables
Subscription Views
IIS Service
MDS Service
Excel Add-InWEB-UI
External System
CRM/ERP
Workflow / Notifications
DWH
Excel Cleansing and Matching
(DQS) SSIS
BizTalk / Others
SSIS
BI OLAP
External System
WCF
PW Pivot
BizTalk / Others
MDS Roadmap
Building the foundationV1 product
Empowering IW through Excel Add-in and improved Web UIEnhanced performance and scalabilityImproved quality (usability, robustness, security)
A ServiceEnhance curationEnhanced collaboration and sharing Improved data qualityFurther empowering business users through simplified, advanced modeling capabilitiesBetter productivityImproved productivity through external IP (data types and models)Sharing and reuse
SQL 2008R2
SQL2012
Post SQL2012
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.