Meta Driven ETL Frameworks with Biml
Kate ran a webinar for the Women in Technology(WIT) on Jan 25th, 2017 discussing her experience creating ETL Frameworks using Meta and Biml. You can watch the webinar recording below:
Description of LET’S GET META: ETL FRAMEWORKS USING BIML
Do you have SSIS projects that have grown unwieldy, become difficult to troubleshoot or suffer from performance issues? Or maybe you’re getting ready to start a new ETL project and want to learn more about how you can gain efficiency while adding value to your solution? In this session we’ll discuss the concept of an ETL framework and the potential elements that can be incorporated within one. We will look at the advantages of implementing a framework based on metadata and look at some database design options for storing that metadata. To start you off on your framework building journey, we’ll introduce Biml and BimlScript and provide some simple code demos to showcase how Biml can be used to help automate your SSIS package generation. This session will be geared for those with a beginner to intermediate knowledge of SSIS and SQL. While we won’t be teaching Biml in great detail, you’ll get an overview of the technology and pointers on where to learn more.