SQLBits 2015
Building a meta-driven near realtime ETL solution with BIML
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
With the outset in a real life solution, build to one of the largest
organizations in the World, this all demo session will take you through a
case of how to build a completely meta-driven SSIS solution relaying on
BIML and MDS to do the hard-work for you.
Being able to do this and have the system finding the fastest way to
load data automatically using system stored procedures enables you to
offer near real-time reporting to your users.
Topics covered in the session:
- BIML & SSIS
- MDS
- CDC
- System SPs (especially sp_depends)
- Near Real-time ETL, what it takes and how to do it.