Next Meeting: Fri, Feb 24 2017
Let's Get Meta: ETL Frameworks Using Biml - Kate Grass
Event Type: In-Person
Online Meeting URL: None
UTC : Fri, Feb 24 2017 18:30 - 20:00
Event Time : Fri, Feb 24 2017 11:30 - 13:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Feb 24 2017 18:30 - 20:00
7471 Pan American
Albuquerque, New Mexico
Let's Get Meta: ETL Frameworks Using Biml
Kate Grass, President Grass Williams Enterprises, Inc.
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.
Kate Grass is a digital nomad who has worked with SQL Server in the manufacturing, nonprofit and service sectors. Her experience runs the gamut from Database Design to Application and Report Development to ETL and Business Intelligence with a generous mix of other skills in between.
After over 15 years in Arizona, she took her passion for all things data and said goodbye to the office life. She now lives and works in an RV, traveling around the United States with her husband and two dogs. As President and SQL Consultant for Grass Williams Enterprises, she is thrilled that every day is "Take your Dog to Work Day" and that the view out the office window is ever-changing.