Want to load data from Azure data lake to Sql server real time

Jagannath Prusty 1 Reputation point
2021-05-05T09:21:03.173+00:00

My requirement is to load live data (real time data) from Azure data lake to Azure SQL.

could someone please suggest how to do

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,355 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 78,331 Reputation points Microsoft Employee
    2021-05-05T10:59:49.427+00:00

    Hello @Jagannath Prusty ,

    Welcome to the Microsoft Q&A platform.

    You can use Azure Data Factory to copy data among data stores located on-premises and in the cloud.

    Note: If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

    For more details, refer Copy data to and from SQL Server by using Azure Data Factory.

    Hope this helps. Do let us know if you any further queries.

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

  2. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-05-10T22:59:02.267+00:00

    Hello @Jagannath Prusty ,
    Thanks for the ask and using the Microsoft Q&A platform .

    Well as @PRADEEPCHEEKATLA-MSFT wrote , you can use Azure data factory also , but I think you should try and explore Azure Stream analytics , it does take Data lake storage as an input and SQL as output and it may what you are looking for .

    https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    0 comments