topic Re: sFTP with Public Key and Password and Passphrase in Connectivity & Data Prep

sFTP with Public Key and Password and Passphrase

stevedark — Fri, 02 Apr 2021 07:55:57 GMT

Hi,

I've been given credentials to an sFTP site, which has a public key file, and a password and also a passphrase.

Qlik Web Connectors only seems to have space to provide a single password/phrase.

Does anyone have any suggestions how I should configure QWC to connect to this site?

As an aside, I've not been able to connect using FileZilla either, so it may be that the sits has not been configured correctly - I'm looking into that also...

Any advice gratefully received.

Thanks,

Steve

Re: sFTP with Public Key and Password and Passphrase

chrisbrain — Fri, 14 Jul 2017 15:12:34 GMT

Hi - I had a quick look and it looks like we would have to add an additional table parameter to support this. We will need to do some testing and see if it can be added to the next release.

Please let us know if you confirm it works with Filezilla.

Re: sFTP with Public Key and Password and Passphrase

stevedark — Fri, 14 Jul 2017 16:02:14 GMT

Hi Chris,

Thanks for the lightning quick response (as ever).

Didn't manage to get it to play ball with FileZilla, but did using another client called WinSCP.

Using this I can see that it prompts first for one of the passwords and then the other.

I will be happy to beta test this functionality for you, if you would like?

Great to see that Qlik is still allowing some of the functionality of Qlik Web Connectors to be used for free. I can see my life involving a lot more scripting and windows scheduler events held together with bits of string and sticky tape if QWC FTP wasn't freely available.

Cheers,

Steve

Re: sFTP with Public Key and Password and Passphrase

chrisbrain — Mon, 17 Jul 2017 09:03:07 GMT

Thanks Steve - I may be in touch regarding a version for you to try out.

Re: sFTP with Public Key and Password and Passphrase

stevedark — Mon, 17 Jul 2017 12:06:43 GMT

Sounds good - thank you.