community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

FTP as Data Source

Hello,

 

I am quite new Alteryx user. now been using Alteryx as ETL tool more than anything else.

 

Now I'm in situation where data source files (xlsx,csv and txt) are on FTP server.

Is there an option to upload data from these files straight to SQL server? 

I saw some solutions where people download/upload files to certain places, can it be done without this?

 

Thanks,

Leonardas

Highlighted
Alteryx
Alteryx

Hi @Leonardas,

You'll start by downloading your data from the ftp site.  The Knowledge Base posting should help you do that:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/File-Transfer-Protocol-FTP-Download/ta-p/105...

 

Once you've downloaded it, you then output (Output Tool) to SQL server.  If you haven't done so already, you'll need to create a DSN connection to the SQL Server in order for the Output Tool to pass data to SQL Server.  This Knowledge Base article can help you with that:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Manage-Data-Connections-Alteryx-11-0/ta-p/45...

Thanks for reply, these links are helpful.

 

Labels