ETL Automation for the MS Data Platform with Biml

Summary:

Are you still building manual SSIS packages? Are you struggling with a transformation of on-prem SSIS to Azure Data Factory? Are you bored from repeating the same steps over and over again? Then this session is just for you!

Join data experts Ben Weissman and Kevin Kline as we explore how the Business Intelligence Markup Language (Biml) can help us to automatically build SSIS packages from meta data, explore clever uses of Biml automation, and how we can use the very same information to spit out all the JSON we need to make this an ADF pipeline. You will leave with the tools, demos, and approaches to implement this at your organization right away!

Interested in additional SentryOne webinars? Check our webinar library.

Available On Demand

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Ben Weissman

Managing Director, Solisyon GmbH

Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousingfield. He is a Data Platform MVP, MCSE Data Management and Analytics, MPP Big Data, MPP AI, MPP Data Science, and MPP Data Analytics. He is also the firstBimlHeroCertified Expert in Germany, a co-author of TheBimlBook, and a Certified Data Vault Data Modeler.

Ben has been involved in about 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun!

Together with his team atSolisyon, Ben provides training, implementation, and consultancy for SQL/BI developers and data analysts in (upper-) mid-market companies around the globe.

Cathrine Wilhelmsen

Senior BI Consultant, Inmeta

Cathrine loves teaching and sharing knowledge. She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.

Webinar: