Setting up access to your Azure One Lake data warehouse is not very complicated and just takes a couple of simple steps. 

Follow the steps below to set it up for yourself, if you are stuck somewhere, feel free to contact out support team at support@sarasanalytics.com. 

• First make sure that you meet all the Prerequisites.
• Then go to the destination and set up the resources.  
• Then come to Daton and set up the destination.

Prerequisites

• To integrate One Lake, you need a Microsoft Fabric and Daton account.

Set up on Azure One Lake

Task 1: Register an Application

1. Log in to the Azure portal.
2. In the search bar, look for App registrations.
3.  Go to App registrations and click New registration.
4. Enter the following specifications for your application in the Register an application section and click Register.
   1. Name for the App
   2. Select Accounts in this organizational directory only under Supported account types
5. Make a note of the Application (client) ID and Directory (tenant) ID that will appear once your application is registered. You will need them to configure Azure One Lake on Daton.

Task 2: Create your Client Secret

1. Select the application you registered in the above Task.
2. On the navigation menu, click Certificates & secrets and then click New Client Secret.
3. In the Add a client secret pane, enter a Description for the client secret, set the expiry time to 730 days, and click Add.
4. Copy the client secret that you just created. You will need it while integrating your db into Daton.

Task 3: Create workspace

1. Log in to your Microsoft Fabric account.
2. Click Synapse Data Engineering.
3. Navigate through Workspaces and then click New Workspace.
4.  Enter a Name for your workspace and click Apply.

Task 4: Add service principal to the workspace

1. Select the workspace you created in Task 3 and then click Manage Access.
    
2. Click Add people or groups and specify the name of the service principal you created in Task 1.
   
3.  In the drop-down menu, select Contributor and click Add.

Task 5: Create Lakehouse

1. On the navigation menu, click Create.
2. In the Data Engineering section, locate and click Lakehouse.
3.  Provide a unique name for your lakehouse and click Create to initiate the creation process. 
   

The steps laid out earlier in the document are a pre-requisite before you start configuring Azure One Lake as a destination in Daton.

Set up on Daton 

1. Log in to your Daton account and navigate to the Destinations page.

2. Click the Add New Destination button and select Azure One Lake from the list of options.

3. Enter the Integration Name and click Next. 

Provide a unique name for your Azure One Lake integration. This name will be used to create tables in the data warehouse and cannot be modified later.

4. Enter the following details to configure the connection to your Azure One Lake database and click Next.

1. Workspace Name: Add a unique name for your Workspace in Daton.
2. Azure One Lake Lakehouse Name: Add the Name of your Lakehouse as added in Task 5.
3. Azure One Lake Object Key Prefix: Add a name of your choice. This will be used to generate the file name in One Lake.
4. Azure One Lake Tenant ID: Add your Tenant ID as obtained in Task 1.
5. Azure One Lake Client ID: Add your Client ID as obtained in Task 1.
6. Azure One Lake Client Secret: Add your Client Secret as created in Task 2.

5. Select the Additional Key Elements option and click Submit.

1. If Yes, Select Optional Key Elements from the dropdown menu.
2. If No, proceed.
3. Select the Object Format of your choice from the dropdown menu.

Now hit the Submit Button. A message will confirm successful integration.

Your Azure One Lake database is now configured as a destination in Daton.