Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.

Start free today

Continuous integration and deployment using Azure Data Factory

Play Continuous integration and deployment using Azure Data Factory
Sign in to queue


Gaurav Malhotra joins Scott Hanselman to discuss how you can follow industry-leading best practices to do continuous integration and deployment for your Extract Transform/Load (ETL) and Extract Load/Transform (ELT) workflows to multiple environments such as Dev, Test, Prod, and more.

For more information:



The Discussion

  • User profile image
    Koos van Strien

    Great stuff! However, when I (or my CI process) exports an ARM template with an SSIS Integration Runtime, the "catalogServerEndpoint" as well as the "catalogAdminUserName" are not parameterized, which makes it hard to release this artifact on multiple environments continuously.

    I could write a script to alter the JSON after publishing the ARM template, but IMHO that isn't the way to go :). Is there a way to get the endpoint & admin username parameterized by default as well?

Add Your 2 Cents