Typical use cases

The typical use case for each of these tools is rather simple: data is here, it needs to be moved there. The rest is just details. While the classic uses of these technologies are ETL, master data management, and asynchronous processing, they should also be considered for any application that needs to move and transform data in places where simple log shipping or replication will not meet the need or does not provide all the functionality required (for example, diverse data sources).

While each of these tools can be extended to most data-movement scenarios, there are times when one is served better with other tools. The classic case of the need for an Enterprise Service Bus (ESB) application or the need to move data through a ...

Get Applied Architecture Patterns on the Microsoft Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.