Data Integration at Microsoft: Technologies and Solution Patterns

Download

Right click “Save as…”

Slides (view online)
There are many reasons to contemplate data integration: constructing a data warehouse, achieving master data management, getting synchronization and consistency, system migration or consolidation, and B2B data acquisition and sharing. At the same time, there are several technical approaches to solving these problems: Bulk or batch movement, federated queries, replication and message or event orient movement. Microsoft offers many products and features that can solve parts of these problems with specific technologies: Microsoft SQL Server Integration Services (SSIS), SQL Server Service Broker, SQL Server Replication, Distribute Query, Microsoft BizTalk Server, and Master Data Services. Taken as a whole, Microsoft products can solve your data integration problems but no single product or feature can solve all of them. This session gives an overview of these problem types, the technology choices, the Microsoft products, and helps you think about what products to use in which situations and especially in which combination to make data integration a reality.

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.