on premises SQL to AZure Data lake RRS feed

  • Question

  • Hi Guys,

    How do I move data from on premises SQL database like adventure works to Azure data lake, not based on tables but t-sql or stored procedure.



    Navin.D http://dnavin.wordpress.com

    Tuesday, June 14, 2016 6:49 PM


  • Hi Navin,

    You can use Azure Data Factory to achieve this scenario. Here is a document that describe various scenarios: https://azure.microsoft.com/en-us/documentation/articles/data-lake-store-data-scenarios/

    Here is a video that explains how to use Azure Data Factory code free wizard to copy data into Azure Data Lake Store: 

           How To - Data Orchestration using Azure Data Factory for Azure Data Lake Store: https://mix.office.com/watch/1oa7le7t2u4ka


    Amit Kulkarni

    Program Manager, Azure Data Lake

    • Marked as answer by Navind Tuesday, June 14, 2016 8:11 PM
    Tuesday, June 14, 2016 7:46 PM