Microsoft OneLake

Microsoft OneLake (opens new window) is a single, unified, logical data lake for the whole organization. It comes automatically with every Microsoft Fabric tenant.

Prerequisites

You must complete the following steps before you can establish a Microsoft OneLake connection in Workato:

1

Sign in to the Azure portal (opens new window) and go to Microsoft Entra ID.

REQUIRED ROLES

Ensure your account has the required roles (opens new window), such as Application Developer, Cloud Application Administrator, or Global Administrator.

2

Switch to the correct tenant (if applicable) by clicking Account profile > Switch directory and selecting the tenant where you plan to register the app.

3

Go to App registrations and click New registration.

4

Enter a Name and specify the Supported account types. Enter https://workato.com/oauth/callback as a Redirect URI and set the platform to Web.

5

Click Register.

6

On the Overview page, copy the Application (client) ID and the Directory (tenant) ID.

7

Go to Certificates & secrets > New client secret, enter a Description, set the expiration, and click Add. Copy the secret Value and store it securely.

SCOPES

You don't need to assign API permissions as this connector requests only the required scopes.

How to connect to Microsoft OneLake

1

Click Create > Connection.

2

Search for and select Microsoft OneLake as your connection on the New connection page.

3

Provide a unique name for your connection in the Connection name field.

Connect to Microsoft OneLake

4

Use the Location drop-down menu to select the project or folder where you plan to save your connection.

5

Enter the Client ID and Client secret for the app you created in the Azure portal.

6

Specify the Account type of the app you created in the Azure portal.

7

If you selected Single tenant as the Account type, enter a Tenant ID.

8

Click Connect.