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.

Speaker

Rasmus is the Data Warehouse Architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and

Rasmus Reinholdt Nielsen's Sessions

Building a meta-driven near realtime ETL solution with BIML