We have an ExpressRoute connection for on-premises connectivity, what method should we use to transfer files to a specific directory?

Niren Adhikary 96

Hello, if we have express route connection to on-prem connectivity how do we transfer files to a particular directory? Do we need to use SFTP or how can we transfer the files.

Tushar Kumar 3,326 Reputation points MVP

2023-06-20T10:33:04.8566667+00:00

Expressroute is connectivity mechnism it's going to provide you connectivity from On-prem network(Fast and reliable).

In order to transfer your data considering it's On-prem you can use custom scripts on virtual machine and invoke sftp.

If you can describe source and destination for the data then I'll be able to help you further.
Niren Adhikary 96 Reputation points

2023-06-20T10:37:14.1166667+00:00

The source is Azure Synapse and we need to send the file to destination on-prem server. I don't think we need a script if we use ADF to send file.
Sumarigo-MSFT 46,126 Reputation points Microsoft Employee

2023-06-21T11:39:14.0133333+00:00

@Niren Adhikary Just checking in to see if the above answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 46,126 Reputation points Microsoft Employee

2023-07-10T06:07:45.83+00:00

@Niren Adhikary Just checking in to see if the above answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Tushar Kumar 3,326 Reputation points MVP

2023-06-20T11:26:24.5733333+00:00
That's totally correct.

In this case you have no issues with accessing the source system. Here is how it's gonna be for destination :

Create Private link for your ADF to expressroute connected Vnet/Peered Vnet https://video2.skills-academy.com/en-us/azure/data-factory/data-factory-private-link

Create linked service(SFTP) with private ip or private DNS name in ADF.

Create your Data factory pipeline pulling data from synapse and pushing to SFTP.

Please feel free to comment if you need further explainantion.

Please accept as answer if this helps.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

We have an ExpressRoute connection for on-premises connectivity, what method should we use to transfer files to a specific directory?

1 answer

Your answer