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

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

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.
891 questions
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2021-05-05T10:59:49.427+00:00
    PRADEEPCHEEKATLA-MSFT 53,006 Reputation points Microsoft Employee

    Hello @J 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. answered 2021-05-10T22:59:02.267+00:00
    HimanshuSinha-msft 17,566 Reputation points Microsoft Employee

    Hello @J 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

    No comments