Get Near Real-Time ETL with Service Broker

Speaker: Allen White ETL is typically done with a tool such as SSIS; but what if you need near real-time reporting? You need to get the updates in your OLTP database to the data warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this task simple and painless. This session will walk through the basic transformations to build a Kimball-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse

Register to view the full article

You have reached some of our most popular content! Register or log in to view.

Registering gives you access to more exclusive content like this article.