Azure Data Lake Analytics connection manager

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

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:

  • Azure Active Directory (Azure AD) User Identity
  • Azure AD Service Identity

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

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.

    a. If you select the Azure AD 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 Azure Active Directory.

    Note

    When you select the Azure AD User Identity authentication option, multi-factor authentication and Microsoft account authentication are not supported.

    b. If you select the Azure AD Service Identity authentication option:

    i. Create an Azure AD application and service principal to access the Data Lake Analytics account. For more information about this authentication option, see Use portal to create Active Directory application and service principal that can access resources.
    ii. Assign appropriate permissions to let this Azure AD application access your Data Lake Analytics account. Learn how to grant permissions to your Data Lake Analytics account by using the Add User wizard.
    iii. Provide values for the Application ID, Authentication Key, and Tenant ID fields.
    iv. 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.