Skip to main content

Data Factory supports Azure AD authentication for SQL Database and SQL Data Warehouse

Published date: March 23, 2018

Azure Data Factory V2 now supports Azure Active Directory (Azure AD) authentication for Azure SQL Database and SQL Data Warehouse, as an alternative to SQL Server authentication. 

Two modes of Azure AD authentication have been enabled. For prerequisite steps, see the following ACOM links.

For SQL Database:

For SQL Data Warehouse:

Azure AD authentication has been enabled both through UI-based authoring and through JSON:

AAD

Sample JSON payload for linked service definition using service principal authentication:

{
    "name": "AzureSqlDbLinkedService",
    "properties": {
        "type": "AzureSqlDatabase",
        "typeProperties": {
            "connectionString": {
                "type": "SecureString",
                "value": "Server=tcp:<servername>.database.windows.net,1433;Database=<databasename>;Connection Timeout=30"
            },
            "servicePrincipalId": "<service principal id>",
            "servicePrincipalKey": {
                "type": "SecureString",
                "value": "<service principal key>"
            },
            "tenant": "<tenant info, e.g. microsoft.onmicrosoft.com>"
        },
        "connectVia": {
            "referenceName": "<name of Integration Runtime>",
            "type": "IntegrationRuntimeReference"
        }
    }
}

 

  • Azure Data Factory
  • Azure SQL Database
  • Azure Synapse Analytics
  • Features

Related Products