DILM Suite + Azure Data Factory Integration Runtime

DILM Suite was designed to support enterprise data engineering / data integration with SSIS. But the solutions, utilities, and tools work well with Azure Data Factory Integration Runtime (ADF IR, or “SSIS in the cloud”). As I mentioned in my post titled The Cloud Costs Money, leaving ADF Integration Runtime running can get pricey – …
Continue reading DILM Suite + Azure Data Factory Integration Runtime

The Recording for Designing a Custom ADF SSIS Execution Framework is Available

The recording the Summer-O’-ADF webinar titled Designing a Custom ADF SSIS Execution Framework is now available (registration required)! Enjoy! :{>  

Updates to Three DILM Suite Applications

It’s been a busy couple weeks here at Enterprise Data & Analytics in Farmville. I just published updates to not one, not two, but three – yes, three! – applications that are part of the Data Integration Lifecycle Management Suite, or DILM Suite. SSIS Framework Community Edition To prepare for Thursday’s (12 Jul 2018) webinar titled …
Continue reading Updates to Three DILM Suite Applications

Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime

The next free webinar in my Summer-O’-ADF series of free webinars is titled ADF Controller Design Pattern with the SSIS Integration Runtime. It’s scheduled for Thursday 5 Jul 2018 at noon EDT. It will be recorded in case you miss it. “Previously on the Summer-O’-ADF Series…” </DonLaFontaine> In my previous webinar, The Azure Data Factory Controller Design …
Continue reading Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime

It’s Biml 2018 Release Day!

Scott Currie and the team at Varigence announce the release of BimlFlex 2018, BimlStudio 2018, and BimlExpress 2018! This much-anticipated release includes awesome features for experienced Biml professionals as well as for data engineers new to automating processes! BimlFlex 2018 BimlFlex is a mature and complete data engineering automation framework. Out of the box, BimlFlex …
Continue reading It’s Biml 2018 Release Day!

Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun

Andy’s Summer-o’-ADF continues with another free (yes, FREE) webinar!   Abstract Join me as I begin to explore a brand new topic: Azure Data Factory Design Patterns. This first webinar in the series is titled The Azure Data Factory Controller Design Pattern. In this demo-tastic session I show how to apply the pattern described in …
Continue reading Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun

The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available

  The recording of my free webinar – Introduction to Lifting and Shifting SSIS to the Cloud – is now available (registration required). Abstract How does an enterprise lift and shift SSIS projects from SSIS Catalogs on-premises to the Azure Data Factory Integration Runtime? What are the best practices? Do SSIS lifecycle management tools exist to …
Continue reading The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available

ADF Execute SSIS Package Activity

The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity

Lift and Shift SSIS Part 1: Deploy Integration Runtime SSIS

What if I told you, “You can quickly and easily deploy Integration Runtime SSIS projects to Azure Data Factory?” You can! As shown in the image, you can simply right-click the SSIS project name in SQL Server Data Tools (SSDT) Solution Explorer and click Deploy to deploy the project to the Azure Data Factory (ADF) …
Continue reading Lift and Shift SSIS Part 1: Deploy Integration Runtime SSIS

Lift and Shift SSIS Part 0: Creating the ADF Integration Runtime

Let’s face it: All the cool kids are playing in the cloud. And why wouldn’t they be? Microsoft Azure gets new features every week… sometimes every day! One shiny feature is Azure Data Factory Integration Runtime (ADFIR) which is new in Azure Data Factory version 2. In this post I will show you one way to …
Continue reading Lift and Shift SSIS Part 0: Creating the ADF Integration Runtime