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

LAPONNEKANTI — Tue, 17 Jun 2025 16:45:25 GMT

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

Retrieve data from an SFTP server (similar to how FileZilla works for file transfer).
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.

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

jrlindem — Fri, 08 Aug 2025 14:05:56 GMT

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.

topic Re: Guidance on Connecting to SFTP for Data Retrieval and Writing to a Sandbox Location in Alteryx Connect Discussions

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

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