Azure Data Lake Storage Setup Guide Beta

Follow our setup guide to connect Azure Data Lake Storage (ADLS) to Fivetran.

---

Prerequisites

To connect a Azure Data Lake Storage to Fivetran, you need the following:

• An ADLS Gen2 account with Administrator permissions
• An ADLS Gen2 container
• Permissions to create an Azure service principal

---

Setup instructions

Create storage account

1. Log in to the .

2. Follow the instructions in to create a storage account.

   NOTE: While creating the storage account, make sure you have checked the Enable hierarchical namespace checkbox in the Advanced tab of the Create storage account page.

Create ADLS container

1. Go to the storage account you created in .

2. In the navigation menu, go to Containers and click + Container.

3. In the New container pane, enter a Name for your container and make a note of it. You will need it to configure Fivetran.

4. In the Public access level drop-down menu, select an access level for the container.

5. Click Create.

   

Register an application and add a service principal

1. In the navigation menu, select Azure Active Directory.

2. Go to App registrations and click + New registration.

   

3. Enter a Name for the application.

   

4. In the Supported account types section, select Accounts in this organizational directory only and click Register.

5. Make a note of the Application (client) ID and Directory (tenant) ID. You will need them to configure Fivetran.

   

Create client secret

1. Select the application you registered in .

2. In the navigation menu, go to Certificates & secrets and click + New client secret.

   

3. Enter a Description for your client secret.

4. In the Expires drop-down menu, select an expiry period for the client secret.

5. Click Add.

6. Make a note of the client secret. You will need it to configure Fivetran.

   

Assign role to container

1. Go to the container you created in and select Access Control (IAM).

   

2. Click Add, then select Add role assignments.

   

3. In the Role tab, select Storage Blob Data Contributor and click Next.

4. In the Member tab, select User, group, or service principal.

5. Click + Select members.

6. In the Select members pane, select the service principal you added in and then click Select.

7. Click Review + assign.

Complete Fivetran configuration

1. Log in to your Fivetran account.

2. Go to the , and then click Add Destination.

3. On the Add Destination To Fivetran page, enter a Destination name of your choice.

4. Click Add.

5. Select ADLS as the destination type.

6. In the destination setup form, enter the Storage Account Name.

7. Enter the Container Name you noted in .

8. (Optional) Enter the Prefix Path of your ADLS container.

9. Enter the Tenant ID and Client ID you found in .

10. In the Secret Value field, enter the client secret you found in .

11. Choose your Data processing location.

12. Choose your Cloud service provider and its region as described in our .

13. Choose your Time zone.

14. (Optional for Business Critical accounts) To enable , set the Use Failover toggle to ON, and then select your Failover Location and Failover Region. Make note of the IP addresses of the secondary region and safelist these addresses in your firewall.

15. Click Save & Test.

Fivetran the Azure Data Lake Storage connection. On successful completion of the setup tests, you can sync your data using Fivetran connectors to the Azure Data Lake Storage destination.

Setup test

Fivetran performs the Read and Write Access test to check the accessibility of your ADLS Gen2 container and to validate the ADLS credentials you provided in the setup form.

NOTE: The test may take a couple of minutes to complete.

---

Related articles