topic sFTP connector cannot acces private key in QlikView

sFTP connector cannot acces private key

Anonymous — Fri, 12 Jan 2018 07:42:17 GMT

Hello,

I'm trying to connect to a sFTP folder from one of our suppliers. It's configured with public and private keys. I already succesfully used WinSCP to test the connection and download files, so basically it's working. But when using the sFTP connector from the QlikWebConnectors, I run this error message over and over again:

There was an error running the table (Access to path C:\QlikWebConnectors\private-key.ppk is denied.)

I have tried several locations to store the private key on my local machine as well as network drives. Initially I had a passphrase on the private key, but I already removed that to rule out any problems on that part.

Can anyone tell me what to do?

Thanks,

Ruud

Re: sFTP connector cannot acces private key

Deepak_dhikale — Mon, 19 Jul 2021 07:46:57 GMT

Hi @Anonymous

have you got the solution? I am stuck with same thing

regards

Deepak

Re: sFTP connector cannot acces private key

mattdetwiler — Tue, 08 Nov 2022 22:23:52 GMT

I think they changed the error because now it states you need to add the file location to the deploy.config file. My file was located in C:\QlikWebConnectors\

You'll want to add your path between the <FileSystemAccessAllowedPaths> tags but make sure it is not in the part that is commented out with <-- -->

After you add the path you'll have to restart the Qlik web connectors Windows service.

Re: sFTP connector cannot acces private key

Jill_Masinde — Tue, 08 Nov 2022 22:46:37 GMT

@Anonymous See below link, You now need explicitly white list the paths you would like the connectors to be able to access.

https://community.qlik.com/t5/Connectivity-Data-Prep/access-denied-Qlik-FTP-SFTP-Connector/td-p/167