Loading...
Skip to content
AndyLeonard.blog() AndyLeonard.blog()
  • RSS
  • Twitter
  • LinkedIn
  • About Andy
  • SSIS and ADF Training
  • Mailing List
  • linktr.ee

DevOps and SSIS and Azure Data Factory

Posted on July 24, 2018Updated on July 24, 2018by Andy LeonardCategories:ADF, ADF Design Patterns, ADF Integration Runtime, Automation, Azure, Biml, Biml Academy, Biml Frameworks, BimlExpress Metadata Framework, Catalog Reports, Data Engineering, Data Integration Patterns, DevOps, DILM, DILM Suite, Framework Browser, SQL Server, SSIS, SSIS Academy, SSIS Best Practices, SSIS Catalog, SSIS Catalog Browser, SSIS Catalog Compare, SSIS Design Patterns, SSIS Frameworks, Training

I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source:

  • SSIS Framework Community Edition – free, open-source, and SSIS Catalog-integrated
    • Framework Browser – free
    • SSIS Framework Commercial and Enterprise Editions – for sale (please see edition feature comparisons)
  • Catalog Reports – free, open-source. I love the SSIS Catalog reports that ship with SSMS. I hate that they’re hard-coded into SSMS. This is an SSRS solution.
  • Basic SSIS Catalog Dashboard in Power BI – free, open-source
  • BimlExpress Metadata Framework – free, open-source
  • SSIS Catalog Browser – free
  • SSIS Catalog Compare – for sale and a new version is in Preview. You can see the Preview version in action in the free webinar recording Use SSIS Catalog Compare to Lift and Shift SSIS to ADF (registration required)

I recorded a series of free webinars about Azure Data Factory (ADF), Azure Data Factory Integration Runtime (ADF IR),  and ADF Design Patterns:

  • Use SSIS Catalog Compare to Lift and Shift SSIS to ADF
  • Designing a Custom ADF SSIS Execution Framework
  • ADF Controller Design Pattern with the SSIS Integration Runtime
  • The Azure Data Factory Controller Design Pattern

I’ve recently updated two training sites:

  • SSIS Academy
  • Biml Academy

:{>

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS, and Biml guy. I was cloud before cloud was cool. :{>

Training

Do you need to level-up your ADF and SSIS skills in a hurry? Sign up for the Premium Level – All Recordings for 1 Year and get started on a full year of ADF and SSIS training!

I still deliver consulting! Want to migrate enterprise SSIS to the cloud? Need help with that data warehouse project? SSIS running too slow? Contact me. At Enterprise Data & Analytics, we are here to help!

Let's meet to discuss your Azure Data Factory, SSIS, or Data Warehouse project; or schedule a demo of SSIS Framework or SSIS Catalog Compare.

  • RSS
  • Twitter
  • LinkedIn
© 2023 by AndyLeonard.blog(). All rights reserved.
Back to top