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.