Enterprise Information Management and BizTalk Integration
Download
1 / 8

Enterprise Information Management and BizTalk Integration - PowerPoint PPT Presentation


  • 161 Views
  • Uploaded on

Enterprise Information Management and BizTalk Integration. Johan Hedberg Microsoft MVP Integration. Mikael Colliander System Engineer Microsoft Data Plattform. Agenda. Introduction to Enterprise Information Management (EIM) and SQL Server Master Data Services ( MDS) Break with food/snack

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Enterprise Information Management and BizTalk Integration' - gram


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Enterprise Information Management and BizTalk Integration

  • Johan Hedberg

  • Microsoft MVP

  • Integration

  • Mikael Colliander

  • System Engineer

  • Microsoft Data Plattform


Agenda

  • Introduction to Enterprise Information Management (EIM) and SQL Server Master Data Services (MDS)

  • Break with food/snack

  • BizTalk Server and MDS


Integration projects today
IntegrationProjects Today

At least in theory…

…one version of the truth

!


Integration projects today1
IntegrationProjects Today

Too often in practice…

70%


Sql server 2012 eim components technologies
SQL Server 2012 EIM ComponentsTechnologies

Data Movement

SSIS

Spell Checking

DQS

Reference Tables

MDS


Data architecture basic data flow
Data Architecture – Basic Data Flow

Staging Tables

  • Subscription Views

MDS Tables

Data Export

Data Import

MDS Database


Data architecture custom data flow
Data Architecture – Custom Data Flow

Staging Tables

  • Subscription Views

MDS Tables

Staging Tables

  • DQS (Cleansing & Matching)

  • Data MERGE and Translation

Staging Tables

  • External Systems

  • External Systems

Data Export

Data Import

MDS Database


Demo

  • Overview working with Enterprise Information Management in SQL Server 2012.


ad