Azure Data Factory- Copy data from on-perm SFTP server to Azure blob.

Sangam Dubey
7 min readJul 14, 2020

Azure Data Factory is a powerful Integration tool that provides many options to play with your data.

In this article, we will see how easily we can copy our data from the on-perm sftp server to Azure blob storage. Below are the steps for completing this activity.

  1. Integration Runtime creation
  2. DataSet creation
  3. Creating your copy pipeline.

1. Integration Runtime creation:

Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments.

Data Factory offers three types of Integration Runtime (IR) and we need to choose one based on our requirements.

So whenever we have to do any Data operation in Azure public network then we can choose Azure-provided IR but when we are dealing with Private network(on-perm data source or any private network environment) then we have to create self-hosted IR.

--

--

Sangam Dubey

A passionate engineer (Cloud computing and Platform engineering are my competencies), who loves to share her experiences and life journey.