SQLBits 2017

Get Near Realtime ETL with Service Broker

Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.