Blog Post

Analytics on Azure Blog
2 MIN READ

Azure Data Factory, SQL Managed Instance, and SSIS Implementation

PeterLo's avatar
PeterLo
Icon for Microsoft rankMicrosoft
Oct 06, 2025

This guide provides step-by-step instructions for enabling Azure Data Factory (ADF), connecting it with Azure SQL Managed Instance (SQLMI), provisioning SSIS runtime, running SSIS packages, and integrating with Microsoft Fabric (Power BI). It is intended for cloud solution architects and data engineering teams deploying enterprise-scale data solutions.

  1. Enabling the ADF Instance
  1. Granting Initial Access to the Data Engineering Team
  1. Connecting Azure SQL Managed Instance with ADF

 

 

 

 

 

 

      • Join the Azure-SSIS integration runtime to a virtual network.

 

      • Create a new subnet in the existing SQLMI VNET.
  1. Running SSIS Packages in ADF

 

 

  1. Sending Data to Fabric (Power BI)
    • Ingest Data
  1. Using ADF in Fabric for Mature, Deployment-Ready Workloads
    • ADF Integration in Fabric

References: All steps and best practices are sourced from official Microsoft Learn documentations mentioned in this documentation.

Published Oct 06, 2025
Version 1.0
No CommentsBe the first to comment