Allow ETL access to my data on Azure Blob Storage ETL can access data residing on Azure Blob Storage. This article details creating the Azure Blob Storage connection in ETL.

Get Azure storage account details to be used In ETL:

  1. Navigate to Azure Portal and choose Storage Accounts from the portal menu.
  2. Select the storage account you'd like to grant ETL access.
  3. Click All Settings.
  4. Click Access Keys.
  5. Follow the next steps to create a new connection in ETL using the info from your storage account access keys screen.

To create a Azure Blob Storage connection In ETL:

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. To create a connection, click New connection.thumbnail image
  3. Choose Azure Blob Storage.
  4. Fill in Account Name with the account name of your Azure storage account.
  5. Fill in Access Key with one of the access keys of your Azure storage account access keys.
  6. Click Test Connection. If the credentials are correct, a message that the connection test was successful appears.
  7. Click Create Azure Blob Storage Connection.
  8. The connection is created and appears in the list of your connections.
  9. Now you can create a package and test it on your actual data stored in Azure Blob Storage. thumbnail image

    To modify Azure Blob Storage connections in ETL:

    1. Click the Connections icon (lightning bolt) on the top left menu.
    2. Click a connection to modify or delete it. To exit the edit Azure Blob Storage connection window without changes, click connections at the top of the window.
    3. To delete a Azure Blob Storage connection, click on the three vertical dots on the far right of the connection listing and select the Delete connection option.

    thumbnail image