SFTP Data Source : MidServer Location

Ken83 · ‎03-28-2022

Hello Community,

I have a .csv file on my MidServer in the \export\folder directory. I want to retrieve this file using an SFTP data source and run a data transform on it. When i try to retrieve the file, i get an error. Why can't I retrieve the file?

Ken83 · ‎04-11-2022

After speaking with ServiceNow, they explained that in order to utilize an SFTP Data Source, the site/server hosting the file must be publicly accessible over the internet. I pivoted to a third party file transfer solution to grab the file from the host and hold it in a location that ServiceNow could pull it from. Everything is working as needed.

View solution in original post

Vasantharajan N · ‎03-28-2022

Is SFTP service running on your Mid Server? If yes, try use the valid user credential.

Try the different methods provided in the below KB

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0817437

Thanks & Regards,
Vasanth

Ken83 · ‎03-29-2022

What is the SFTP service called? If you mean the SSH service, yes that is running.

Vasantharajan N · ‎03-29-2022

Please check the below,

1. SFTP network Port TCP/22 is in listening state

2. Whether you are using Internet IP of your mid server because you are connecting the mid server from ServiceNow Application server which is not in customer(your) network.

Thanks & Regards,
Vasanth

Ankur Bawiskar · ‎03-29-2022

Hi,

the error says connection refused and authentication failed

Did you try to connect to that SFTP using some open source software and test the connection

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader