Copy On-Prem Flat file to Azure Blob using Azure Data Factory V2

1
votes

I am trying to load a Flat file to BLOB using the ADF V2. I have installed the Self Hosted Integration Runtime for the same. The Integration Runtime on Local Machine shows that is successfully connected to the cloud Service as in the SC below. However while making the LinkedService to the on Prem File, some credentials are required. I am not sure of what UserName or Password should be fed in. I have tried both On-Prem and Azure passwords (Wanted to try). Please see the SC.

Could you please guide as how the connection can be made to a local Flat file in my case.

Thanks - Akshay Screenshot

2
azureazure-data-factory

2 Answers

3
votes

Note: You can choose a file while creating the File System as a source in ADF.

You may follow the following steps to select the text file while creating File system as source:

First create a linked service as follows:

Host: **C:\AzureLearn\**

enter image description here

Create a copy activity and select Source as follows:

Click on Source => New

enter image description here

Select New DataSet => Select File => File System and continue

enter image description here

Select Format= > Choose DelimitedText and continue

enter image description here

=> Select previously created File system linked service and click on browse.

enter image description here

Choose a file or folder.

Here you can find the file located under the previously selected folder while creating File System.

enter image description here

Hope this helps.

1
votes

The LinkedService connection to BLOB or AzureSQL Server are being blocked by the firewall of my organisation. It won't let my system Integration runtime connect my resources to the public cloud. I followed the same steps on my personal machine and everything went smoothly. Will get the firewall restrictions sorted and update this link for more information.