Azure Data Lake Analytics connection manager

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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.

Note

While Microsoft Entra ID is the new name for Azure Active Directory (Azure AD), to prevent disrupting existing environments, Azure AD still remains in some hardcoded elements such as UI fields, connection providers, error codes, and cmdlets. In this article, the two names are interchangeable.

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.