Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 extraction does not retrieve a valid working fingerprint, contact your SFTP server administrator who can provide a fingerprint or a public key for you.
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.
Error in SFTP connector
Diagnostic
Example: (insert a valid SFTP server host IP)
Result:
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.
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.
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
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
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
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
Hello everybody, in my qlik cloud i recive this error , testing with RSA or ECDsaNistP256
But, when i create my fingerprint, recive in ECDSA format, Could be the cause of my problem?
Regards,
Vinicius
Please check with your SFTP administrator. If the SFTP server is sending this message back, then there is some issue with the fingerprint you are receiving.
Ensure that you share the 'Supported Cryptography' section above with your SFTP administrator to ensure they are using the required cryptography.
There are variations of host public key algorithms.
If you are not using one of the specific algos from 'Supported Cryptography' section above, it will not work as expected.
Please check with your SFTP admin and also check and test with the diagnostics section of this article to help you to troubleshoot your sftp environment.
Kind regards..