Azure Data Factory Adds Managed Identity Support to Data Flows

ADF users can now build Mapping Data Flows utilizing Managed Identity (formerly MSI) for Azure Data Lake Store Gen 2, Azure SQL Database, and Azure Synapse Analytics (formerly SQL DW). These added security features, combined with ADF's existing support for Azure Trusted Services, will allow you to now build ETL pipelines using ADLS Gen 2 storage accounts as sources and sinks without requiring public endpoints.

Here are documentation links to configure your data factory to use MSI with ADLS Gen 2, SQL DB, and Synapse Analytics (SQL DW):

https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-data-lake-storage#managed-identity

https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database#managed-identity

https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse#managed-identity