Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Set up Instructions for Azure Data Lake Storage Database

This subtopic covers instructions and essential notes on how to set up Azure Data Lake Storage as a destination on Daton.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      Need help with something?

      Talk to data expert

      Set up Instructions for Azure Data Lake Storage Database

      This subtopic covers instructions and essential notes on how to set up Azure Data Lake Storage as a destination on Daton.

      Setting up access to your Azure Data Lake Storage 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 establish a connection between Azure Data Lake Storage and Daton, the following prerequisites are required:

      • Azure ADLS Gen2 account with Administrator permissions and a Daton account.
      • An ADLS Gen2 container
      • Permission to create an Azure service principal

      Set up on Azure Data Lake

      Task 1: Create a Storage Account

      To create a new Storage Account:

      1. Log in to the Azure portal.
      2. On the Navigation Pane, click Storage Accounts.
      3. On the redirected page, click Create.
      4. Provide a unique Storage account name in the Basics tab. (This name will be used during integration in Daton)
      5. Follow the Microsoft Azure documentation for detailed information on creating a storage account.

      Task 2: Create an ADLS container

      1. Navigate to the storage account you generated in Task 1.
      2. Access Containers in the navigation menu and click Create Container.
      3. Within the New Container pane, input a Name for your container. (This name will be used during integration in Daton)
      4. Choose an access level for the container from the access level drop-down menu and click Create.

      Task 3: Register an Application and Add a Service Principal

      1. Navigate to Azure Active Directory in the navigation menu.
      2. Access App registrations and click New registration.
      3. Provide a Name for the application. 
      4. In the Supported Account Types section, choose Accounts in this organizational directory only, and then click Register.
      5. Your Application (client) ID and Directory (tenant) ID will be displayed. Take note of these as you will require them during the Daton configuration.

      Task 4: Create a Client Secret

      1. Choose the application you registered in Task 3.
      2. Navigate to Certificates & secrets in the navigation menu, and click New client secret.
      3. Provide a Description for the Client Secret.
      4. Select an expiry period for the client secret from the Expires drop-down menu and click Add.
      5. Take note of the client secret, as you'll need it for configuring Daton.
         

      Task 5: Assign a Role to the Container

      1. Select the Container created in Task 2 and select Access Control (IAM).
      2. Click Add, then select Add role assignments.
      3. On the Role tab, choose Storage Blob Data Contributor and proceed.
      4. Within the Member tab, opt for User, group, or service principal.
      5. Click Select members, pick the service principal added in Task 3, and then click Select.
      6. Click Review + Assign.

      The steps laid out earlier in the document are a pre-requisite before you start configuring Azure Data 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 Data Lake Storage from the list of options.
      3. Enter the Integration Name and click Next. Provide a unique name for your Azure Data 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 Data Lake Storage database and click Next.
        1. Azure Storage Account Name: Your Storage Account Name as specified in Task 1.
        2. Account Container Name: Add the Name of your Container as added in Task 2.
        3. Object Key Prefix: Add a name of your choice. This will be used to generate the file name in Azure Data Lake Storage.
        4. Tenant ID: Add your Tenant ID as obtained in Task 3.
        5. Client ID: Add your Client ID as obtained in Task 3.
        6. Client Secret: Add your Client Secret as created in Task 4.
      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 Data Lake Storage is now configured as a destination in Daton.

       
      daton integration azure data lake

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Setup Instructions for Amazon S3 Destination

      Table of Contents

      Prerequisites Set up on Azure Data Lake Task 1: Create a Storage Account Task 2: Create an ADLS container Task 3: Register an Application and Add a Service Principal Task 4: Create a Client Secret Task 5: Assign a Role to the Container The steps laid out earlier in the document are a pre-requisite before you start configuring Azure Data Lake as a destination in Daton. Set up on Daton

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand