topic Re: Qlik FTP/SFTP Connection Issue in Connectivity & Data Prep

Qlik FTP/SFTP Connection Issue

Mahaboob_Syed — Tue, 21 Dec 2021 13:37:54 GMT

Hello Community

I'm facing attached error while trying to fetch some files using SFTP over. The web connector is configured as service on the server.

Any inputs please ?

Thanks in advance

Best Regards

Syed

Re: Qlik FTP/SFTP Connection Issue

stevedark — Thu, 12 Nov 2020 22:27:43 GMT

Hi @Mahaboob_Syed

Getting the private key to play ball can be fiddly. Also, I've not tried downloading multiple files in this way (typically I will list and enumerate).

Have you tried a simple list files connection to just pull back a list of the files in a SFTP folder, in order to test the connection, prior to trying a download?

Have you validated all of the settings using a different FTP client on the same server?

Steve

Re: Qlik FTP/SFTP Connection Issue

chrisbrain — Fri, 13 Nov 2020 07:04:04 GMT

Agree with Steve's comments here to perform a simpler test first and using a different table to first enumerate the files and download them one by one as I don't think that * syntax is supported.

Re: Qlik FTP/SFTP Connection Issue

Mahaboob_Syed — Mon, 16 Nov 2020 13:34:03 GMT

Thank you @chrisbrain @stevedark

The issue was related to the access rights to the folder where the .ppk file was residing and qlik user had to be given the access since the web connector was running as service on our reload node.

Now its working.

The next part is while copying the code to the qliksense document and creating a new connection , this is where am I struck now.

Re: Qlik FTP/SFTP Connection Issue

stevedark — Mon, 16 Nov 2020 16:02:41 GMT

Hi @Mahaboob_Syed

You are probably going to want to be creating a REST connection and pass in parameters using WITH CONNECTION.

There are some notes on doing this on the tabs which appear after a successful run in the QWC portal.

Are QWC and Sense Enterprise (or Desktop) running on the same server? If not you will need to ensure that QWC is configured to allow connections from other IP addresses and the firewall is open to allow traffic on 5555.

Hope that helps.

Steve

Re: Qlik FTP/SFTP Connection Issue

Mahaboob_Syed — Mon, 16 Nov 2020 20:04:31 GMT

Hello @stevedark

Thank you for the above.

Yes, the web connector is as an service on same server where we have our Qliksense Reload node.

As you mentioned, yes I'm following up the notes as below attached. I'm trying to create a connection. All of our odbc connections are on reload node

Best Regards

Syed

Re: Qlik FTP/SFTP Connection Issue

chrisbrain — Tue, 17 Nov 2020 06:26:11 GMT

@Mahaboob_Syed Regarding "The service is unavailable" message. A few suggestions:

- Check the Qlik Web Connectors log files for any entries around the time you triggered this message.
- Try running the URL you are pasting in in a browser on the same machine where the qlik server is running.
- If QWC and Qlik are on the same machine, I think you should just be able to use 'localhost:5555' as the address - might be worth trying this too.