Scheduled Imports with an SFTP connection - timeout error

mfestger
Kilo Contributor

‎05-25-2018 07:46 AM

I am attempting to schedule an import, and the data source is an xlsx file in a folder I have placed into an SFTP using the FileZilla server client.

The error I am receiving is: ava.io.IOException: SSH authentication failed, Timed out while waiting for TCP to connect: ( scheduled import job: userdata.xlsx (Uploaded))

Below is a screenshot of how the Data Source is set up. For the Server field, I have input the IP address my local machine is connected to. As for the username, that is also something I set up within the FileZilla server.

find_real_file.png

Does anybody have any tips or leads I can refer to solve this issue? 

Thank you!

Preview file
17 KB
0 Helpfuls
  • 1,128 Views
6 REPLIES 6

Syvo
Mega Guru
In response to mfestger

‎05-25-2018 09:00 AM

Ok, the MID server is rather simple to deploy on any machine, you just have to make sure it's monitored when in production.

Let us know if you have questions regarding this. 🙂

0 Helpfuls

Roger Poore
Tera Guru

‎06-01-2018 05:04 PM

Why not just open SFTP at your firewall for your instance's IP range?    Setting up a MID server just to grab a file seems like overkill to me.

0 Helpfuls