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 updated using Service Broker messages from your OLTP database.