idea Re: Adding a built in FTP connector in Qlik Sense Cloud in Suggest an Idea

Adding a built in FTP connector in Qlik Sense Cloud

ingoniclas — Tue, 16 Jun 2020 04:18:49 GMT

So far it is not possible to fetch data from an FTP server when using Qlik Sense Business, i.e. in the Cloud environment. The Qlik FTP/SFTP connector uses localhost in the url to find the respective file, which does not work in the cloud because localhost does not exist in that context. However, there are situations where companies only allow to fetch data from FTP servers. Therefore, I suggest to add this option.

Re: Adding a built in FTP connector in Qlik Sense Cloud - Status changed to: Open - Collecting Feedback

Ian_Crosland — Wed, 23 Sep 2020 08:07:29 GMT

Re: Adding a built in FTP connector in Qlik Sense Cloud

thomasc — Wed, 03 Mar 2021 09:03:49 GMT

Hi@Ian_Crosland ,

Is it possible to add same feature in DataTransfer?

Thanks

Regards,

Thomas

Re: Adding a built in FTP connector in Qlik Sense Cloud

Ian_Crosland — Wed, 03 Mar 2021 09:33:00 GMT

Thanks for submitting this idea, we will add it to the FTP request for SaaS idea which is in open status

Re: Adding a built in FTP connector in Qlik Sense Cloud

gwoodard — Thu, 25 Mar 2021 15:59:28 GMT

Is there a timeline for the FTP integration. We are in need of a Box connector and the FTP/FTPS would be a good work around since Box supports FTP/FTPS.

Re: Adding a built in FTP connector in Qlik Sense Cloud

Shwe — Wed, 31 Mar 2021 13:34:25 GMT

What is the timeline for this in QlikSense Enterprise SaaS? I can't think of any other Cloud BI Software leaders that lack this (or similar) functionality.

Re: Adding a built in FTP connector in Qlik Sense Cloud

CHansford — Mon, 05 Apr 2021 14:42:44 GMT

@Ian Crossland I've been asking for a FTP/SFTP connector in SaaS for some time now and it is stopping me from connecting to one of the my largest public data sets as this is the only way they provide the data to the public.

I support this idea

CHris

Re: Adding a built in FTP connector in Qlik Sense Cloud

Ian_Crosland — Mon, 05 Apr 2021 15:15:19 GMT

I will also loop in our PM for Connectivity @P-O_Davidson

Thanks

Re: Adding a built in FTP connector in Qlik Sense Cloud

MLaverick — Tue, 10 Aug 2021 15:23:03 GMT

Any update on this?

Re: Adding a built in FTP connector in Qlik Sense Cloud

scottduthie — Mon, 14 Feb 2022 18:52:34 GMT

Hi @Ian_Crosland ,

I can't see this idea in the ideation board - do you know what the status of it is?

I have multiple Qlik SaaS customers where this is becoming a real blocker. We have tried many workarounds with application automation, but we still can't get to smooth working solution for extracting files from an SFTP daily.

Re: Adding a built in FTP connector in Qlik Sense Cloud - Status changed to: Open - On Roadmap

Ian_Crosland — Tue, 15 Feb 2022 06:38:37 GMT

Re: Adding a built in FTP connector in Qlik Sense Cloud

Ian_Crosland — Tue, 15 Feb 2022 06:41:09 GMT

I will copy the PM for this one @P-O_Davidson , this has been updated to on the roadmap, currently no ETA as the team are fully utilised on other features currently .

Thanks

Ian

Re: Adding a built in FTP connector in Qlik Sense Cloud

p_verkooijen — Fri, 25 Mar 2022 14:26:58 GMT

Really need this connector, any news about when we could be expecting a solution?

@scottduthie any chance you could share a FTP automation example with me ?

Re: Adding a built in FTP connector in Qlik Sense Cloud

MatteoBios — Thu, 21 Apr 2022 13:03:50 GMT

Hi, I also need this connector since many customers are migrating from Qlik Enterprise on Windows to Qlik Cloud.

@Ian_Crosland can you advice us as soon as you have an ETA?

Thanks,

Matteo

Re: Adding a built in FTP connector in Qlik Sense Cloud

Ian_Crosland — Thu, 21 Apr 2022 13:06:31 GMT

@P-O_Davidson is the PM on this one and is looking to have an ETA, currently this is not in development and behind a few other R&D tasks

thanks

Ian

Re: Adding a built in FTP connector in Qlik Sense Cloud

p_verkooijen — Fri, 29 Apr 2022 15:48:50 GMT

For a workaround, I recently created this automation that retrieves files from FTP and move's then to Onedrive.

https://community.qlik.com/t5/Qlik-Application-Automation/Automation-of-FTP-files-to-Cloud-Provider/m-p/1920400#M532

Had to setup a Microsoft/OneDrive account because Google Drive is (still) not supported as a location in automations 😞

Re: Adding a built in FTP connector in Qlik Sense Cloud

scottduthie — Fri, 29 Apr 2022 19:25:48 GMT

Thanks for sharing @p_verkooijen !

As part of your solution did you have to identify the 'latest file' in a list of files on the FTP? This is the part we've been struggling with - in our use case we have a new file being dropped every day with a unique timestamp in the file name (we have no visibility of in advance of what the timestamp and file name will be) - so we need to try identify the latest file in a list - however it doesn't seem the FTP connector in QAA can retrieve this type of metadata for us. Any insight on that?

Re: Adding a built in FTP connector in Qlik Sense Cloud

p_verkooijen — Sat, 30 Apr 2022 08:39:49 GMT

Hi @scottduthie

Yes we need to process our increments from newest to oldest feed. So yes we identify the latest file, however not by using Automations.

We move the file(s) to a /processed folder after transferring them to the OneDrive.

Then perform a reload and move the file to a similar folder /processed on the OneDrive.

Re: Adding a built in FTP connector in Qlik Sense Cloud

jorono — Tue, 02 Aug 2022 10:23:31 GMT

Hi, I also need this connector since many customers are migrating from Qlik Enterprise on Windows to Qlik Cloud.

Can you provice more information about the potencial availability of this connector please.

Best Regards

Joaquin

Re: Adding a built in FTP connector in Qlik Sense Cloud - Status changed to: Open - In Development

P-O_Davidson — Tue, 20 Dec 2022 20:36:23 GMT