Allen is a Data Platform Consultant. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been a Data Platform MVP Award for twelve years.
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.