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]

Can you send me a screenshot of your data source configuration?

[Service Manager]

Hi Brent,

Thanks for Helping me out!

You answer helped me but didn't resolved the issue yet.Therefore we are no more using SFTP server.
Do you know any alternative solution to fetch the records from Server "\\svmtAdirec01\Adirec$.csv" (My computer C - drive).

Thanks

[Brent Sutton]

Hi Ya,

Can you please retest with the following changes:

1. Server - make sure this is the fully qualified domain name - example.acme.com
2. File Path - Replace your file path with the following (exactly, including forward slash) - hsvmpsoft/psoft$.csv
3. User Name - Remove the "hs\" prefix, should just be the user name itself - pcexample

Connection URL should look something like the following:

sftp://pcexample:${scp_password}@example.acme.com/hsvmpsoft/psoft$.csv

Retest with these changes and 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.