Edit

Share via

Azure Data Lake Store Connection Manager

  • Article

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

A SQL Server Integration Services (SSIS) package can use the Azure Data Lake Store Connection Manager to connect to an Azure Data Lake Storage Gen1 account with one of the two following authentication types:

  • Microsoft Entra user identity
  • Microsoft Entra service identity

The Azure Data Lake Store 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.

Prerequisites

To ensure that the Azure Data Lake Store Connection Manager and the components that use it - that is, the Data Lake Storage Gen1 source and the Data Lake Storage Gen1 destination - can connect to services, make sure you download the latest version of the Azure Feature Pack here.

Configure the Azure Data Lake Store Connection Manager

  1. In the Add SSIS Connection Manager dialog box, select AzureDataLake, and then select Add. The Azure Data Lake Store Connection Manager Editor dialog box opens.

  2. In the Azure Data Lake Store Connection Manager Editor dialog box, in the ADLS Host field, provide the Data Lake Storage Gen1 host URL. For example: https://test.azuredatalakestore.net or test.azuredatalakestore.net.

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

    1. If you select the Azure Active Directory User Identity authentication option, do the following things:

      1. Provide values for the User Name and Password fields.

      2. 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 Storage Gen1 data, 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.

    2. If you select the Azure Active Directory Service Identity authentication option, do the following things:

      1. Create a Microsoft Entra application and service principal to access the Data Lake Storage Gen1 data.

      2. Assign appropriate permissions to let this Microsoft Entra application access your Data Lake Storage Gen1 resources. For more information about this authentication option, see Create a Microsoft Entra application and service principal that can access resources.

      3. Provide values for the Client Id, Secret Key, and Tenant Name fields.

      4. To test the connection, select Test Connection.

  4. Select OK to close the Azure Data Lake Store 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.