Skip to content

Latest commit

 

History

History
58 lines (40 loc) · 3.74 KB

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

File metadata and controls

58 lines (40 loc) · 3.74 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords
Azure Data Lake Analytics connection manager
A SQL Server Integration Services (SSIS) package can use the Azure Data Lake Analytics connection manager to connect to a Data Lake Analytics account.
yanancai
yanacai
maghan
05/18/2018
sql
integration-services
conceptual
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.