Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

NOTE, QVSource also has Connectors to:


Usage

This connector currently supports:
  • Secure FTP (SFTP) and FTP.
  • Authentication with username and password or public/private keys (SFTP).
  • Listing of files and folders in a given location on the server (v1.0.2 and later).
  • Downloading a named file from your FTP/SFTP server to a local directory (from where it can be loaded into QlikView).
    • Note - you can also use wild card characters to download multiple files - e.g. you could specify '/myfolder/*.txt' to download all text files. There are now tables which return the list of files which were downloaded.
  • Streaming the contents of a named file from your FTP/SFTP server directly into QlikView.
  • Uploading a file to your FTP/SFTP server.

Please contact us if you would like to see other features (including authentication modes or other file transfer protocols) supported.

Image

Troubleshooting

If you are having trouble connecting to your FTP/SFTP server, before contacting support please first verify that you can connect to it successfully from another FTP tool such as Filezilla as this will likely be the first thing we would ask you to demonstrate over a support call.

Change Log

1.1.2 - 07/02/16
  • Added new Ftp Mode input parameter to all FTP tables which allows FtpSslExplicit (Use FTP protocol with explicitly secured TLS/SSL connection) and FtpSslImplicit (Use FTP protocol with implicitly secured TLS/SSL connection) to be set.

1.1.1 - 28/01/16
  • FTP tables should now work with anonymous servers (i.e. if username and password are left blank).

1.1.0 - 23/12/15
  • If a proxy is configured (as noted here http://wiki.qvsource.com/An-Introduction-For-Enterprise-Users.ashx#Proxy_Authentication_1 for WinForms version or here http://wiki.qvsource.com/QVSource-Web-Edition-Advanced-Config.ashx#Proxy_Server_4 for the Web Edition) this connector will now set up a HTTP CONNECT proxy for the FTP connection with those details.

1.0.9 - 04/12/15
  • Added initial additional support for connection through proxies.

1.0.8 - 10/11/15
  • Added Timestamp column to LatestLog table.
  • Cartegorised tables as "SFTP", "FTP" or "Advanced".
  • Upgraded to latest (R4.1) of RebEx.

1.0.7 - 04/09/15
  • Minor fix to FTPGetRawFile/SFTPGetRawFile tables.

1.0.6 - 31/08/15
  • FTPGetRawFile/SFTPGetRawFile tables now stream contents of file as binary (rather than first converting to text first).

1.0.5 - 22/01/15
  • Added a LatestLog table to inspect connection details of the most recent request. Note this is for use in the user interface only and will not work from QlikView/Qlik Sense.

1.0.4 - 20/10/14
  • Requests to SFTPDownloadFile now correctly mapped to the new name SFTPDownload (this should have been fixed in 1.0.1 but was not working).
  • Requests to FTPDownloadFile now correctly mapped to the new name FTPDownload (this should have been fixed in 1.0.1 but was not working).

1.0.3 - 21/07/14
  • Added input to override default port number.

1.0.2 - 03/06/14
  • Added FTPListFilesAndFolders and SFTPListFilesAndFolders tables.

1.0.1 - 01/05/14
  • Added FileCount column to ????DownloadFile tables.
  • Added file count to progress displays.
  • SFTPDownloadFile renamed SFTPDownload (this will be automatically mapped for script generated using an earlier version).
  • FTPDownloadFile renamed FTPDownload (this will be automatically mapped for script generated using an earlier version).
  • Added FTPDownloadAndList and SFTPDownloadAndList tables which show which files were downloaded.

1.0.0 - 23/04/14
  • Taken out of beta.
  • Upgraded to latest version of FTP library.

0.8.1 - 05/12/13
  • Added FTP Support.
  • Added tables to upload files.

0.8.0 - 20/11/13
  • Initial version.


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd