Without mid server is it possible to send file through sftp?

[Sjoshi2]

Hi

I want to collect a CSV file from Customer using SFTP mode and have to retrieve the file in my system. Is it possible to get the file without mid server?

[HarshTimes]

Hi Shreya

Yes , you can do that. Just make sure that your firewall is allowing traffic/connection from servicenow.

[Sjoshi2]

Hello,

Could you more elaborate on this as to how achieve it?

[HarshTimes]

Hi Shreya

Goto Data Source (system Import Sets->Data Source) and create new Data source with below configuration.

1. Name - You can put any name of your data source. If your organization is following any naming convention, follow that.
2. Import set table label - Add name of the import set table. This will auto create an import set table. This is the staging table where your file will be recorded. If you already have the import set table created then you can put that name in the import set table name field.
3. Type - There are 3 options LDAP, File and JDBC for the type. Select the type as File.
4. Format - There are multiple format. In this case we are loading the csv file. So select the format as CSV.
5. Zipped - If the source file is zipped then check the Zipped checkbox.
6. File retrieval methods - Select as SFTP.
7. FilePath - This is the path where your file is kept in Kiteworks. Let's say the file name is TestFile.csv and is stored in TestFolder. Then the FilePath will be /TestFolder/TestFile.csv
8. Server - This is the server name of the Kiteworks.
9. Username - Name of the user. This user should have access to read the file that is stored in respective folder. Select the username that is setup in above Kiteworks profile setup.
10. Password - Password of the user profile.

Submit this record and reopen the same record. Once you reopen you will find that a connection URL has been generated automatically. Now you are ready to check the connection.
Scroll Down the form and you will see that there are few related links. Click on the Test load 10 records. Once you click on this link, servicenow integration engine will try to connect to SFTP Server and will fetch the file that you have configured in the data source settings. If the connection is successful then data in csv file will be loaded in the configured import set table. Now you can setup the transform map and process the data accordingly

[Sjoshi2]

Hello,

Thank you very much for these helpful comments.

I have some doubts as I am new to this procedure could you clear it?

1. FilePAth - In SNOW itself do I have to store or somewhere else? and what is kiteworks?

2. If   Mid server is not used then do I need to provide a server name?

3. without using mid server will I be able to get a file from outside of customer's network?