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

sexta-feira, 23 de março de 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"
        }
    }
}

 

Conta gratuita

Obtenha $200 em créditos Azure e 12 meses de serviços populares gratuitamente

Início gratuito

Visual Studio

Assinantes ganham até $1800 por ano de serviços do Azure

Ative Agora

Inicializações

Join Microsoft for Startups and get free Azure services

Saiba mais