FTP/SFTP
The Qlik FTP/SFTP connector enables you to download files from, or upload to, FTP and Secure FTP locations directly from your QlikView or Qlik Sense applications or local directory. You can use wildcards to download multiple files from a location and have a table of downloaded files for verification purposes within your application.
The QlikFTP/SFTP connector 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.
- Downloading a named file from your FTP/SFTP server to a local directory.
- Streaming the contents of a named file from your FTP/SFTP server directly into QlikView or Qlik Sense.
- Uploading a file to your FTP/SFTP server.
The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.
Supported offerings
- Qlik Sense Desktop
- Qlik Sense Enterprise on Windows
- QlikView
This connector must be installed separately.
Ways to access your data
The QlikFTP/SFTP connector has the following tables available:
- SFTPListFilesAndFolders - Lists files and folders in the specified directory of the SFTP server.
- SFTPGetRawFile - Downloads a named file from your SFTP server and returns the results directly. You can use the URL generated as a Web File source.
- SFTPDownload - Downloads a named file, or files if you use a wildcard '*', from your SFTP server to a local folder. The table returned shows the number of files downloaded.
- SFTPDownloadAndList - Downloads a named file, or files if you use a wildcard '*', from your SFTP server to a local folder. The table returned lists each file downloaded.
- SFTPUploadFile - Uploads a named file to your SFTP server from a local folder.
- FTPListFilesAndFolders - Lists files and folders in the specified directory of the FTP server.
- FTPGetRawFile - Downloads a named file from your FTP server and returns the results directly. You can use the URL generated as a Web File source.
- FTPDownload - Downloads a named file, or files if you use a wildcard '*', from your FTP server to a local folder. The table returned shows the number of files downloaded.
- FTPDownloadAndList - Downloads a named file, or files if you use a wildcard '*', from your FTP server to a local folder. The table returned lists each file downloaded.
- FTPUploadFile - Uploads a named file to your FTP server from a local folder.
- LatestLog - Retrieves the latest connection logs which can be useful for debugging purposes.
Troubleshooting
If you are having trouble connecting to your FTP/SFTP server, first verify that you can connect to the server successfully from another FTP tool such as Filezilla before contacting support.