slide1
Download
Skip this Video
Download Presentation
Enterprise Information Management and BizTalk Integration

Loading in 2 Seconds...

play fullscreen
1 / 8

Enterprise Information Management and BizTalk Integration - PowerPoint PPT Presentation


  • 166 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
slide1

Enterprise Information Management and BizTalk Integration

  • Johan Hedberg
  • Microsoft MVP
  • Integration
  • Mikael Colliander
  • System Engineer
  • Microsoft Data Plattform
slide2

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

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