Which file retrieval method to create a file type data source for a scheduled import of a csv from a linux server behind firewall inside company network?

[tantony]

I don't know much about networking to decide on an ideal file retrieval method for a file type(CSV) data source. I will be receiving a feed file(csv)   for daily department update, on a Linux server which is within the company's network. Which file retrieval method (SCP or FTPS or SFTP) will be ideal for creating file type(CSV) data source. I am thinking of a scedule import to Department table.

[Deepak Kumar5]

You can use any method depend on the security of company.

SN support all the file retrieval method based on your company security process.

[sergiu_panaite]

If your Linux server is behind a firewall you most probably are using a private IP address, rather than a public one. If that's the case you can only import the file via a MID server and not directly (private IP addresses are not routable in the internet):

MID Server

Regards,

[tantony]

Yes , I tried all the methods and failed. I see that Crossfuze has a plugin to import files via MID Server (http://www.servicenowguru.com/integration/scheduled-file-import-mid-server/)   but people say they are not working since Eureka.

With SFTP with port=22 I got this error:

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: SSH authentication failed, Connection unexpectedly closed by SSH server:

So I am guessing it is able to reach the remote server but connection refused.

I would like to know if anybody has used FTPS(Auth SSL) with Mutual authentication set up.

File type data source fields   has a boolean field 'System KeyStore' which is documented as "Select this check box to validate the certificate from the FTPS server against all saved certificates. This certificate may be any type supported by the instance. If you do not select this check box, the instance uses the Java default certificate to validate the FTPS server. This field is available only for data sources with a File retrieval method value of FTPS (Auth SSL)

[tantony · Accepted solution]

I got it working.My organization had a public facing FTP server which is not behind firewall. The CSV feed files   created daily on   the company server behind firewall is   uploaded by FTPS to the public facing FTP server by a python script.. The networking team took care of the certificate validation(between Servicenow and FTP server) and gave me the account and port to connect to that FTP server .A file type data source with a File Retrieval Method FTPS(Auth SSL) created in Servicenow with the username ,password, hostname and port, directly imported the data from CSV file via import table,import sets and transform map. A scheduled import with this data source is scheduled to run daily. A MID server was not required