Enterprise Information Management and BizTalk Integration
This presentation is the property of its rightful owner.
Sponsored Links
1 / 8

Enterprise Information Management and BizTalk Integration PowerPoint PPT Presentation


  • 124 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Enterprise Information Management and BizTalk Integration

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

Enterprise Information Management and BizTalk Integration

  • Johan Hedberg

  • Microsoft MVP

  • Integration

  • Mikael Colliander

  • System Engineer

  • Microsoft Data Plattform


Enterprise information management and biztalk integration

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


Enterprise information management and biztalk integration

Demo

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


  • Login