Re: On-premise data source to Qlik Cloud Business?
In our case FTP access to the local server was locked down to whitelisted IP addresses only, but FTP access to the/a local server would have to be enabled, yes.
Depending on your network security this shouldn't be too difficult and this is about as secure as we could get it:
Whitelisting Qlik Sense Cloud IP Addresses
Passing FTP access credentials through the Qlik Sense Cloud Web File Connections
The Qlik Sense Cloud offering is still quite new, however Qlik are adding features and functionality all the time, so the security side should be expanded at some point to support more advanced security options.
As per the Qlik Sense Help documentation above, you will need to whitelist the IP addresses for access through your firewall for ODBC connections as well - if you chose to go this route and it works - as I mentioned before we haven't tested this on our side as it wouldn't have worked for our requirements.