Get Near Real-Time ETL with Service Broker
ITPro Today
September 14, 2015
![Get Near Real-Time ETL with Service Broker Get Near Real-Time ETL with Service Broker](https://eu-images.contentstack.com/v3/assets/blt07f68461ccd75245/blt5e6afa29c5c4c175/661d3c7fcccca1a8c27fa2c7/emvideo-limelight-mediaId_2827d90e8382404ea4266b3e42d67a7f_0_0_0.jpeg?width=1280&auto=webp&quality=95&format=jpg&disable=upscale)
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.
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like