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

New live, online ADF and SSIS course deliveries have been scheduled!. Learn more at Enterprise Data & Analytics' Training page.
Next up: Master the Fundamentals of Azure Data Factory is 22 Aug 2022.

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.

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! SSIS running too slow? Want to migrate to the cloud? Need help with that data warehouse project? Contact me. At Enterprise Data & Analytics, we are here to help!

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

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close