Data source Error - retrieve the records via CSV

[Service Manager]

Hello

We are looking forward to retrieve the CSV file from a server and push it on a custom table. However, when I tried to fetch the data based on given credentials via datasource. Retrieval method is SFTP but there was an error stating that

com.glide.db.impex.datasource.DataSourceException: java.io.IOException: SSH authentication failed, DNS cannot resolve host \\xxxxxxxxxxx to an IP address while opening an SSH TCP connection

Thanks

[Brent Sutton]

Have you checked your "Connection URL" (you'll probably need to add the field to your data source form) in your data source to ensure it is correct to make the connection to your SFTP site? This is auto-generated based on the file retrieval method, server, user name, password and file path. Sometimes it needs to be manually amended based on the way your organisation has set-up the SFTP server. 

Standard SFTP connection URL will look something about the below:

sftp://admin:${scp_password}@example.example.com/svmtAdirec01/Adirec$.csv

Let me know how you get along.

Brent

P.S. If my suggestion helped then please mark as helpful and/or correct so other community members can benefit from this information.

[Service Manager]

I appreciate your response!

I'm not sure with file retrieval method so I tried with FTP and SFTP but both throws the same issues

we don't have connection URL we have something like "\\svmtAdirec01\Adirec$.csv" I used that as a server with given username and password.

Thanks

[Brent Sutton · Accepted solution]

Hi Ya,

Your data source should be set-up like the following:

You'll need to know the server name as well as the file path in order to create the connection. File path should not have a forward slash at the start i.e. svmtAdirec01/Adirec$.csv

Hope this makes sense.

Brent

P.S. If my suggestion helped then please mark as helpful and/or correct so other community members can benefit from this information.

[Service Manager]

Thanks for the quick response!

I tried as you mentioned above but I got a different error this time.

com.glide.db.impex.datasource.DataSourceException: java.net.MalformedURLException: For input string: \\svmtAdirec01\Adirec$.csv

Thanks