How to create an SFTP data connection in a Qlik Cloud Application using 'fingerprint' method

[Frank_S]

Steps

1. Retrieve the SFTP server fingerprint (this example uses port 22)
   
   
   1. Open a Windows command prompt
   2. Run the following command: 
      
      sftp -P 22  username@ftptest.test.com 
      
      Where username is 'username' and 'ftptest.test.com' is the sftp hostname.
      
      
   3. The response received will be similar to:
      

      C:\Windows\System32>sftp -P 22 username@ftptest.test.com
      The authenticity of host 'ftptest.test.com (18x.6x.15x.21x)' can't be established.
      RSA key fingerprint is SHA256:KijFUxxxxxxxxxxxxxx/xxxxxxxxxxxxxxxxxapWjo

      if the above does not retrieve your fingerprint, contact your SFTP server administrator who can provide fingerprint or public key details for you.

   4. Copy the RSA fingerprint 
      
      
2. Create a Qlik Cloud Data Connection
   
   
   1. Open your Qlik Cloud Application and navigate to the data load editor
   2. Under Data Connection choose Create new connection 
   3. Search and select SFTP
   4. Enter your credentials and fingerprint information
      • Hostname
        • (ie: myftpserver.domain.com. Do not pre-pend the address with ftp:// nor sftp://)
      • Username
      • Password
      • Insert fingerprint
   5. Click Test connection
      
      
      

      If there are connectivity issues, to request data from your data connections through a firewall, you need to add the underlying (all three) IP addresses for your region to your firewall's allow list. These addresses are static and will not change. See Allowlisting domain names and IP addresses.

Other Diagnostics:

Error in SFTP connector

• Error shows public key mismatch error in Qlik SFTP connector

Diagnostic

• Open Command Prompt and enter "ssh-keyscan -t rsa <host ip or name) | ssh-keygen -lf -"

Example: (insert a valid SFTP server host IP)

• C:\Windows\System32>ssh-keyscan -t rsa 192.168.xxx.255 | ssh-keygen -lf -

Result:

• "(stdin) is not a public key file"

In case of this or other SFTP connection errors, please work with the SFTP server administrator or SFTP server vendor in order in order to enable the generation of a publicly available fingerprint.

Related Information:

SFTP

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

[KD2015]

Hello, I am new to Qlik Sense & I just purchase an account for testing purposes to see if I can use it for my business. I am having a hard time following the instructions here especially this line on this line...'sftp -P 22  username@ftptest.test.com'. What is the username specified here? Is it for my cloud account login or it is something else. And the URL, is it for my cloud account? Thank you 

[Sonja_Bauernfeind]

Hello @KD2015 

This example would be the credentials and URL of your SFTP host. It is the host that you connect to to fetch the data.

All the best,
Sonja 

[KD2015]

Thank you Sonja...I completed everything & I think I got all the correct OpenSSH info I need to make the connection. Now I am getting this error message "The following parameter validation errors were found: host: The Host URI is blocked". What could I have missed? It looks like my Firewall is open for port 22 & all my SSH functionalities are running properly. 

Thank you

[Sonja_Bauernfeind]

Hello @KD2015 

This error indicates some sort of network security blocking the host. I suggest reaching out to your internal IT to have this reviewed. Here is an example of another user encountering this issue and having noticed that the Qlik cloud IPs were not added correctly: Qlik Cloud SFTP connector returns Error.

If you need more assistance troubleshooting this, please post about it in the appropriate forum: Connectivity and Data Prep.

All the best,
Sonja