OneLake Setup Guidelink
Follow our setup guide to connect your OneLake destination to Fivetran.
Prerequisiteslink
To connect OneLake to Fivetran, you need a Microsoft Fabric account.
Setup instructionslink
Register application and add service principal link
Log in to the Azure portal.
In the navigation menu, select Microsoft Entra ID (formerly Azure Active Directory).
Go to App registrations and click + New registration.
Enter a Name for your application.
In the Supported account types section, select Accounts in this organizational directory only and click Register.
Make a note of the Application (client) ID and Directory (tenant) ID. You will need them to configure Fivetran.
Create client secret link
Select the application you registered in Step 1.
On the navigation menu, click Certificates & secrets and then click + New client secret.
In the Add a client secret pane, enter a Description for the client secret.
In the Expires drop-down menu, select an expiry period for the client secret.
Click Add.
Make a note of the client secret. You will need it to configure Fivetran.
Create workspace link
Log in to your Microsoft Fabric account.
Click Synapse Data Engineering.
On the navigation menu, click Workspaces and then click + New workspace.
Enter a Name for the workspace and click Apply.
Add service principal to workspace link
Select the workspace you created in Step 3 and then click Manage Access.
Click + Add people or groups.
Specify the name of the service principal you created in Step 1.
In the drop-down menu, select Contributor.
Click Add.
Create lakehouse link
On the navigation menu, click Create.
In the Data Engineering section, click Lakehouse.
Enter a unique Name for your lakehouse and click Create.
Finish Fivetran configuration link
- Log in to your Fivetran account.
- Go to the Destinations page and click Add destination.
- Enter a Destination name of your choice and then click Add.
- Select OneLake as the destination type.
- In the destination setup form, enter the Workspace Name you created in Step 3.
- Enter the Lakehouse Name you created in Step 5.
- Enter the Tenant ID and Client ID you found in Step 1.
- Enter the Secret Value you found in Step 2.
- Choose your Data processing location.
- Choose your Cloud service provider and its region as described in our Destinations documentation.
- Choose your Time zone.
- (Optional for Business Critical accounts) To enable regional failover, set the Use Failover toggle to ON, and then select your Failover Location and Failover Region. Make a note of the IP addresses of the secondary region and safe-list these addresses in your firewall.
- Click Save & Test.
Fivetran tests and validates the OneLake connection. On successful completion of the setup test, you can sync your data using Fivetran connectors to the OneLake destination.
In addition, Fivetran automatically configures a Fivetran Platform Connector to transfer the connector logs and account metadata to a schema in this destination. The Fivetran Platform Connector enables you to monitor your connectors, track your usage, and audit changes. The connector sends all these details at the destination level.
IMPORTANT: If you are an Account Administrator, you can manually add the Fivetran Platform Connector on an account level so that it syncs all the metadata and logs for all the destinations in your account to a single destination. If an account-level Fivetran Platform Connector is already configured in a destination in your Fivetran account, then we don't add destination-level Fivetran Platform Connectors to the new destinations you create.
Setup testlink
Fivetran performs the Read and Write Access test to check the accessibility of your OneLake workspace and to validate the OneLake credentials you provided in the setup form.
NOTE: The test may take a couple of minutes to complete.
Related articleslink
description Destination Overview
settings API Destination Configuration