How to user Azure Data Factory for ETL

This is a practical demo and step by step video that uses Azure Data factory to collect a file from and FTP server and store it as an Azure Blob then ingest the blob into an Azure SQL Server Database.

The Prerequisites for this is as follows:


FTP Server (I used www.drivehq.com)
An Azure subscription (I use a free trail)

An Azure Blob store (I used v2 Storage Account)
Azure SQL Server
Azure Datafactory

You also need a data set that you can lab with. and SQL Server Management studio 2017 to create tables in the Azure SQL Server database and test your Data Factory Pipeline results with.