Dynamically load on premise SQL server tables into azure data lake

Due to the limitations of blogger I am not able to publish this article in a webpage, therefore I decided to upload this blog article to my google drive. You can download the article here.

In this blog I describe how you can dynamically load on premise SQL server tables into Azure Data Lake using Azure Data Factory.

Screenshot of Azure Data Factory loading tables using the "Lookup" and "ForEach" transformation.



Screenshot of Azure Data Lake containing the tables of AdventureWorksDW2014 database in text format