Guidance on Connecting to SFTP for Data Retrieval and Writing to a Sandbox Location

[LAPONNEKANTI]

I am working on a use case where I need to perform the following tasks using Alteryx:

1. Retrieve data from an SFTP server (similar to how FileZilla works for file transfer).
2. Once the data is retrieved, write it back to a specific sandbox location on the same or another SFTP server.

I would like to understand the best approach or tools available within Alteryx to achieve this.

[jrlindem]

Given when you posted this, I'm hoping you've figured out a solution.  Figured i'd leave this note here in case others happen upon this post...

I think in many cases, the "best" approach is actually to have your IS/DS people map the SFTP to a network drive location that can then be accessed by your instance of Alteryx.

We do this a lot at my organization where we had information services build out read/write locations that pull/push files across the SFTP, but all we have to do on the analytics side is input and output files into those folders.  So, they operate just like any other drive directory.