Skip navigation

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

23 March 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:


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

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


Free account

Get $200 in Azure credit and 12 months of popular services – free

Start for free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now


Join Microsoft for Start-ups and get free Azure services

Learn more