Event Driven ETL

05/06/2019 - Ordina
Blarenberglaan 3B 2800 Mechelen

So you’ve been doing your datawarehousing in its traditional sense. You have your ETL set up to start after business hours, load all the new and updated data to have your datawarehouse ready and up-to-date for your business users when they start work the next day.

Now, you’re asked to take things to the next level, they want to track data changes when they occur during the day so the DWH is always reporting on the latest data. Event-driven ETL to the rescue, as any type of event in the source system will need to trigger only that specific subsection of your ETL so it doesn’t try to load your entire DWH every time one source changes.

In this session we’ll explore the possibilities to set up a metadata-based solution to start specific subsegments of your ETL for any source system event and guide you through how a possible framework would be set up to facilitate this.

Speakers

Jan van Humbeek

Senior Microsoft BI consultant and Competence Center Lead working for Ordina Belgium

Jan Van humbeek is a Senior Microsoft BI consultant and Competence Center Lead working for Ordina Belgium.

Over the years, he’s gathered a lot experience with all the core BI components the SQL Server stack has to offer.

Currently he holds most SQL Server MCSA & MCSE certifications and also renews his MCSE Data Management and Analytics yearly.

He is always eager to continue learning and to share his knowledge and experiences.
His main focus is lifting data to higher quality standards and improving on the implemented BI processes.

Aside from his technical interest & skills, he also has a deep fondness for Data Vault and Anchor Modeling architectures.

Subscribe