Skip to content

azure-data-lake-analytics-connection-manager.md

Latest commit

 

History

History
58 lines (40 loc) · 3.73 KB

azure-data-lake-analytics-connection-manager.md

File metadata and controls

58 lines (40 loc) · 3.73 KB
title Azure Data Lake Analytics connection manager
description A SQL Server Integration Services (SSIS) package can use the Azure Data Lake Analytics connection manager to connect to a Data Lake Analytics account.
author chugugrace
ms.author chugu
ms.reviewer
ms.date 05/18/2018
ms.service sql
ms.subservice integration-services
ms.topic how-to
f1_keywords
SQL13.DTS.DESIGNER.AFPADLSCM.F1
sql14.dts.designer.afpadlscm.f1

Azure Data Lake Analytics connection manager

[!INCLUDEsqlserver-ssis]

Important

Azure Data Lake Analytics will be retired on 29 February 2024. Learn more with this announcement.

A SQL Server Integration Services (SSIS) package can use the Azure Data Lake Analytics connection manager to connect to a Data Lake Analytics account with one of the two following authentication types:

  • Microsoft Entra user identity
  • Microsoft Entra service identity

The Data Lake Analytics connection manager is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.

[!INCLUDE entra-id]

Configure the connection manager

  1. In the Add SSIS Connection Manager dialog box, select AzureDataLakeAnalytics > Add. The Azure Data Lake Analytics Connection Manager Editor dialog box opens.

  2. In the Azure Data Lake Analytics Connection Manager Editor dialog box, in the ADLA Account Name field, provide the Data Lake Analytics account name. For example: myadlaaccountname.

  3. In the Authentication field, choose the appropriate authentication type to access the data in Data Lake Analytics.

    1. If you select the Azure Active Directory User Identity authentication option:

      i. Provide values for the User Name and Password fields.
      ii. To test the connection, select Test Connection. If you or the tenant administrator didn't previously consent to allow SSIS to access your Data Lake Analytics account, select Accept when prompted. For more information about this consent experience, see Integrating applications with Microsoft Entra ID.

    [!NOTE] When you select the Azure Active Directory User Identity authentication option, multifactor authentication and Microsoft account authentication are not supported.

    1. If you select the Azure Active Directory Service Identity authentication option:

    2. Create a Microsoft Entra application and service principal to access the Data Lake Analytics account. For more information about this authentication option, see Create a Microsoft Entra application and service principal that can access resources.

    3. Assign appropriate permissions to let this Microsoft Entra application access your Data Lake Analytics account. Learn how to grant permissions to your Data Lake Analytics account by using the Add User wizard.

    4. Provide values for the Application ID, Authentication Key, and Tenant ID fields.

    5. To test the connection, select Test Connection.

  4. Select OK to close the Azure Data Lake Analytics Connection Manager Editor dialog box.

View the properties of the connection manager

You can see the properties of the connection manager you created in the Properties window.