Qlik Sense Business - FTP/SFTP Qlik Connector

[Adamo]

I have seen that the SFTP connector is not aviable in the Qlik Sense Business.

Does any one know when that will be available?

Regards

[stevedark]

Is anyone aware of any progress on this one? It seems like a connector that should be there out of the box on Qlik Sense Business, especially as it was there on the old Qlik Sense Cloud For Business.

@Michael_Tarallo is this something you have visibility of timescales on?

The other connector which would be useful in Qlik Sense Business is the standard Web Connector (as opposed to REST) as this would allow a connection to Qlik Web Connectors on another server (which would be another route to SFTP).

Steve

[chrisbrain]

Hi - I can't give an estimate when this will be available but we are aware of the interest in having it.

[stevedark]

Thanks Chris. I hope it is relatively soon, as the workarounds are horrible.

[attaporn]

Anyone, I would like to know about SFTP connector is it have on Qlik cloud enterprise?

and hope can have SFTP connector on Qlik cloud business soon, i have working on POC state and can’t load data source from SFTP server.

[stevedark]

As far as I know, the connector is not there on any version of Sense Cloud.

As you have an enterprise licence, you could have an on-premise instance of Sense and do the FTP retrieve there and then get the files via a service such as DropBox. This kind of kills the point of having the files on an SFTP server in the first place though. With the Hybrid cloud you should be able to refresh an app on premise and have that replicate to the Cloud, but this is not something I have seen live.

As I mentioned above, the work arounds required from not having SFTP in the cloud are not nice.

The closest I got to a solution to this is to use Amazon S3 as storage and have a task running to replicate the SFTP files on S3. These two articles may help with that:

https://www.quickintelligence.co.uk/cloud-file-services-qlik-sense/

https://aws.amazon.com/sftp/

Good luck!

[attaporn]

Stevedark, Thank you very much. i have study to use Amazon S3 also, if a little data is ok, but if a lot of data it will make more cost.

[scottduthie]

Hi everyone,

We're also in need of SFTP loads into Qlik SaaS. To my surprise it looks like there's no connector available.

Is using Application Automation a workaround? Or is this potentially Qlik's recommended method?

https://help.qlik.com/en-US/blendr/Content/blend-editor/ftp-and-sftp.htm

I have heard from Qlik that Automation should not be used as a substitute for normal loads via the data load editor - but in this case it might be the only way? I wonder what limitation we might run into with things like data volumes, querying lists in an FTP site, or dynamically calling on different files located in that site etc.

[stevedark]

Hi Scott,

It seems really strange that some kind of functionality like you can get from QWC on premise is not available in the Cloud. The issue with the QWC method is when you save you refer to the filesystem path (e.g. c:\etc..) and you obviously don't have access to that in cloud. Some way of using libraries should be possible though.

But...

As that isn't available this seems like a perfect use case for Qlik Application Automation, where an automation could call the SFTP server, place the data somewhere suitable and then kick off the reload of the apps that require that data.

I'm surprised that Qlik have advised against Automation for loads. Anyone who has come from a QlikView or Client Managed environment will have set up chained reloads to do a QVD load prior to a front end load. Qlik Application Automation is the only way to achieve this in Cloud, so is perfect for data loads.

My guess is what they mean is that the best way of transforming data is still with the powerful scripting language that you have in application load scripts - which is certainly true. I can't see why this shouldn't be kicked off from within an automation though.

Hope that helps?

Steve