%3CLINGO-SUB%20id%3D%22lingo-sub-1132391%22%20slang%3D%22en-US%22%3EAzure%20Data%20Factory%20Adds%20Managed%20Identity%20Support%20to%20Data%20Flows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132391%22%20slang%3D%22en-US%22%3E%3CP%3EADF%20users%20can%20now%20build%20Mapping%20Data%20Flows%20utilizing%20Managed%20Identity%20(formerly%20MSI)%20for%20Azure%20Data%20Lake%20Store%20Gen%202%2C%20Azure%20SQL%20Database%2C%20and%20Azure%20Synapse%20Analytics%20(formerly%20SQL%20DW).%20These%20added%20security%20features%2C%20combined%20with%20ADF's%20existing%20support%20for%20Azure%20Trusted%20Services%2C%20will%20allow%20you%20to%20now%20build%20ETL%20pipelines%20using%20ADLS%20Gen%202%20storage%20accounts%20as%20sources%20and%20sinks%20without%20requiring%20public%20endpoints.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20are%20documentation%20links%20to%20configure%20your%20data%20factory%20to%20use%20MSI%20with%20ADLS%20Gen%202%2C%20SQL%20DB%2C%20and%20Synapse%20Analytics%20(SQL%20DW)%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-data-lake-storage%23managed-identity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-data-lake-storage%23managed-identity%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-sql-database%23managed-identity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-sql-database%23managed-identity%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-sql-data-warehouse%23managed-identity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-sql-data-warehouse%23managed-identity%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1132391%22%20slang%3D%22en-US%22%3E%3CP%3EADF%20users%20can%20now%20build%20Mapping%20Data%20Flows%20utilizing%20Managed%20Identity%20(formerly%20MSI)%20for%20Azure%20Data%20Lake%20Store%20Gen%202%2C%20Azure%20SQL%20Database%2C%20and%20Azure%20Synapse%20Analytics%20(formerly%20SQL%20DW).%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1132391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%20Cloud%20ETL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1170284%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Data%20Factory%20Adds%20Managed%20Identity%20Support%20to%20Data%20Flows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1170284%22%20slang%3D%22en-US%22%3E%3CP%3EMSI%20authentication%20is%20not%20supported%20when%20i%20use%20ADLS%20Gen2%20as%20staging%20layer%20for%20loading%20into%20sql%20datawarehouse.%20May%20i%20know%20when%20this%20feature%20will%20enabled%20for%20staging%20data%20sets%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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-identi...

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-ident...

1 Comment
Occasional Visitor

MSI authentication is not supported when i use ADLS Gen2 as staging layer for loading into sql datawarehouse. May i know when this feature will enabled for staging data sets ?