Monday, 16 July 2018

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.




No comments:

Post a Comment