What options do we have to retrieve CSV files that are behind a firewall?

Nick78
Tera Contributor

I have a data source that has started to fail due to an Organizational change in our file retrieval methods. Our Data Source was pulling a simple CSV file from a Server. That Server has since been put behind a firewall causing the failure, resulting in the following error message.

 

"java.io.IOException: SSH authentication failed, Timed out while waiting for SSH protocol ID string".

This leads me to believe we are reaching the target server, but the connection is being refused. What options do we have to remedy this behavior? At this point I cannot ask them to move it back to a public facing server, due to security reasons. We Tried to move the file to a Jscape server but we're met with a similar issue, this time due to a VPN....is there a way to still address this with the going the Jscape route, and navigate around the VPN?

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@Nick78 

was that a ftp or sftp server?

You will have to install mid server in client's network, ask the team to put csv file in mid server then fetch it

check these links on how it can be fetched

How to import a CSV file from a MID Server 

CSV file from MIDserver to ServiceNow instance 

File Import (CSV / XLS) file from Mid Server location 

Import a file to Servicenow from MID Server 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

@Nick78 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

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