topic Re: Load from SFTP in QlikView

Load from SFTP

Mon, 26 Jan 2026 18:19:17 GMT

Dear Community,

Is it possible to load the excel sheet directly from sftp server?

There is built in feature for ftp connection only.

Thanks and best regards,

Chanel

Re: Load from SFTP

jagan — Thu, 16 Jan 2014 04:11:34 GMT

Hi,

Check this

File Transfer Connector For QlikView (SFTP (Secure FTP) & FTP) - QVSource - The QlikView API Connector (Docs)

Hope it helps you.

Regards,

Jagan.

Re: Load from SFTP

brijesh1991 — Thu, 16 Jan 2014 05:03:13 GMT

QlikView has loading data from an FTP site built directly in to it’s product.

I recently ran in to a scenario that required a connection to a Secure FTP site. As of QV11, connection to an SFTP sites is not supported.

To handle this I used PuTTY, a free telnet/SSH client, to pull the file down to a local drive where QV could read it. One of the great things about PuTTY is that it does not HAVE to be installed.

You can download a portable edition that just sits on a folder on your desktop.

This is important because many QV developers don’t have administrative rights on their box making installation a no go.

Re: Load from SFTP

Thu, 16 Jan 2014 06:13:15 GMT

Thanks for your fast response. But I am unable to access, it looks like that secure ftp refuse for this connection.

Somehow, i did try to use ftp connection to connect to sftp and load data from there,

it is working fine but with longer time.

Thanks,

Chanel

Re: Re: Load from SFTP

brijesh1991 — Thu, 16 Jan 2014 06:40:52 GMT

See the attachement.

Re: Load from SFTP

Tue, 21 Jan 2014 01:04:27 GMT

Hi Jagan,

Is the connector need extra cost?

By the way, i am able to use the ftp load at scripting part to connect to sftp.

I just face another problem in "for each file in filelist ..." function.

For Each File in Filelist - FTP load

Hope you might help.

Thanks and best regards,

Chanel

Re: Load from SFTP

roelvandeven — Fri, 21 Feb 2014 08:42:09 GMT

I have used the PuTTY workflow to download files from an sFTP server. I have setup a bat file to start PuTTY and the download and let QlikView wait and check if the download is finished (I let the bat file create a logfile when process is done).

This all works fine when I reload the script manually, but when I schedule the reload on the QV server, the download won't start. However, the logfile is created instantly.

Are there any settings I'm missing out on?

Re: Load from SFTP

Tue, 25 Feb 2014 00:25:15 GMT

I haven't get the exact solution, sorry that unable to help much...

Re: Re: Load from SFTP

anjali0108 — Thu, 07 Apr 2016 07:28:27 GMT

Hi Brijesh,

I also have the same requirement . I want to download files from SFTP Server .After downloading PuTTY,I launched

PuTTY.exe and the following window is coming :

I only information I have handy is :

URL of that SFTP Folder ,a username and a password to open that .Could you please suggest further steps to connect to the same .Any help will be appreciated .Thanks in advance .