Suggest an Idea

[ingoniclas]

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.

[Ian_Crosland]

Hi

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

[p_verkooijen]

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 ?

[MatteoBios]

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 

[Ian_Crosland]

Hi

@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

[p_verkooijen]

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/...

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

[scottduthie]

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?

[p_verkooijen]

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.

[jorono]

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

[p_verkooijen]