1 / 8

Enterprise Information Management and BizTalk Integration

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

gram
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Enterprise Information Management and BizTalk Integration • Johan Hedberg • Microsoft MVP • Integration • Mikael Colliander • System Engineer • Microsoft Data Plattform

  2. Agenda • Introduction to Enterprise Information Management (EIM) and SQL Server Master Data Services (MDS) • Break with food/snack • BizTalk Server and MDS

  3. IntegrationProjects Today At least in theory… …one version of the truth !

  4. IntegrationProjects Today Too often in practice… 70%

  5. SQL Server 2012 EIM ComponentsTechnologies Data Movement SSIS Spell Checking DQS Reference Tables MDS

  6. Data Architecture – Basic Data Flow Staging Tables • Subscription Views MDS Tables Data Export Data Import MDS Database

  7. 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

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

More Related