Transcript Master Data BizTalk - Biztalkusergroup.se

Master Data = Data Distribution?
Subscribing
Subscribing
System
Subscribing
System
System
Best of Breed
System
Subscribing
Subscribing
System
Subscribing
System
System
Integration &
Distribution
Subscribing
Subscribing
System
Subscribing
System
System
Best of Breed
System
Best of Breed
System
SQL Master Data Services
“Master Data Services (MDS) is the SQL Server solution
for master data management (MDM); the efforts made
by an organization to discover and define nontransactional lists of data, with the goal of compiling
maintainable master lists”
What Master Data Services is
• It is a central data store
• It contains data staging tables and data export views
• It does not contain any integration capabilities in itself
Basic MDS Architecture
Subscription
Views
Staging Tables
MDS Tables
What Master Data Services is not
• It is not data distribution
• It is not data sync from a (another) master system
• Datamodell
•
•
Tabeller
Vyer
• Förändringar i 2012
MDS Future and evolution
Post SQL2012
SQL2012
A Service
Enhance curation
SQL 2008R2
Building the foundation
V1 product
Empowering IW through Excel
Add-in and improved Web UI
(Silverlight)
Enhanced performance and
scalability
Improved quality (usability,
robustness, security)
Improved Integration through
readability enhancements
Enhanced collaboration and sharing
Improved data quality (DQS)
Further empowering business users
through simplified, advanced modeling
capabilities
Better productivity
Improved productivity through external
IP (data types and models)
Sharing and reuse
• Förändringar i 2012
• Yttre stage tabeller för att rensa data innan man tar in det i MDS
staging
Data Architecture – Custom Data Flow
External Systems
External Systems
Data MERGE and
Translation
DQS (Cleansing &
Matching)
Staging Tables
Staging Tables
Subscription
Views
Staging Tables
MDS Tables
Data Architecture – Basic Data Flow
Subscription
Views
Staging Tables
MDS Tables
Data Architecture – Basic Data Flow
Subscription
Views
Staging Tables
MDS Tables
• Förändringar i 2012
• Yttre stage tabeller för att rensa data innan man tar in det i MDS
staging
• SSIS är en integrationsplattform
SQL Server Integration Services (SSIS)
“SSIS is an Extract, Transform, Load (ETL) framework that
allows you to integrate different data sources using a
workflow like designer and a set of tasks.”
• Förändringar i 2012
• Yttre stage tabeller för att rensa data innan man tar in det i MDS
staging
• SSIS är en integrationsplattform
• Data från “SAP” kommer genom export till en fil från “SAP”
• Data in sker i nattliga batchar
• Men events då?
MDS WCF Architecture
WEB-UI
Workflow/
Notifications
Excel Add-In
External Systems
MDS WCF Architecture
BizTalk
External Systems
Demo
• Stage/Import data with BizTalk Server
• Export/Sync data with BizTalk Server
• Lookup data with BizTalk Server
MDS Architecture
WEB-UI
Excel Add-In
Workflow/
Notifications
Subscribing
Systems
External Systems
Subscription
Views
Staging Tables
DQS (Cleansing &
Matching)