Qlik Community

Qlik Sense Cloud Discussions

logicode
New Contributor III

Qlik Sense Cloud - FTP Security

 

Hi Guys

I have a client who is interested in Qlik Sense Cloud Business and we have a way to automate their data uploads/reloads to Qlik Sense Cloud.

 

Their concern with regard to pulling data via FTP (Webfile) connection is security.

 

Does anyone know if there is a static ip address that the FTP requests would come from that we can allow access to through their firewalls?

Or if there is a plan anytime soon to allow SFTP access?

Your assistance would be greatly appreciated.

 

1 Solution

Accepted Solutions
logicode
New Contributor III

Re: Qlik Sense Cloud - FTP Security

An update on the above:

We have been dealing directly with one of the Cloud Success Rep's at Qlik and are happy to say that we have resolved the above security and automation issue.

The automated system that we have set up is therefore as follows:

  1. QlikView (Personal Edition) has been set up to extract & transform data - generating cloud ready qvd's on the client's local server.
  2. The QlikView model(s) have been scheduled (via Task Scheduler) to load all new data every night.
  3. The client has set up FTP access to the above local server directory containing the cloud ready qvd's.
  4. Qlik were able to provide a list of IP addresses that the client could whitelist for access through their firewall.
  5. Qlik Sense Cloud Apps were set up to load the optimised qvd data directly from the client's local server directory, using FTP Web File connections (passing login credentials).
  6. Qlik Sense Cloud Apps were then scheduled to refresh published data every morning.

So far this system seems to work pretty well.

The client is able to manage & store the raw & optimised data on their local server, while Qlik Sense Cloud provides the analysis platform.

The IT guys are happy as the connections are as secure as they can be for now, until SFTP becomes an option.

The above system uses direct FTP access, no 3rd party or Dropbox required.

Users can log in from anywhere and the Qlik Sense App data is refreshed automatically every day.

The only limitation at this point is that users are not able to export data/visualisations from published apps, which Qlik are looking at for future functionality - possibly first half of 2018: Qliksense Cloud export on shared app

Users will therefore be accessing:

  • Published Apps for analysis - screen clipping charts, dashboards & small table visualisations, etc.
  • Workspace Apps to export large tables into Excel.

One important consideration with this approach is that only data in Published Apps can be scheduled to refresh automatically, so any users accessing Apps in Workspace will need to perform manual reloads.

For the cost and convenience, I think the client is pretty happy with the solution provided so far.

Any feedback, comments and questions are welcome.

Regards

Leigh

3 Replies
logicode
New Contributor III

Re: Qlik Sense Cloud - FTP Security

An update on the above:

We have been dealing directly with one of the Cloud Success Rep's at Qlik and are happy to say that we have resolved the above security and automation issue.

The automated system that we have set up is therefore as follows:

  1. QlikView (Personal Edition) has been set up to extract & transform data - generating cloud ready qvd's on the client's local server.
  2. The QlikView model(s) have been scheduled (via Task Scheduler) to load all new data every night.
  3. The client has set up FTP access to the above local server directory containing the cloud ready qvd's.
  4. Qlik were able to provide a list of IP addresses that the client could whitelist for access through their firewall.
  5. Qlik Sense Cloud Apps were set up to load the optimised qvd data directly from the client's local server directory, using FTP Web File connections (passing login credentials).
  6. Qlik Sense Cloud Apps were then scheduled to refresh published data every morning.

So far this system seems to work pretty well.

The client is able to manage & store the raw & optimised data on their local server, while Qlik Sense Cloud provides the analysis platform.

The IT guys are happy as the connections are as secure as they can be for now, until SFTP becomes an option.

The above system uses direct FTP access, no 3rd party or Dropbox required.

Users can log in from anywhere and the Qlik Sense App data is refreshed automatically every day.

The only limitation at this point is that users are not able to export data/visualisations from published apps, which Qlik are looking at for future functionality - possibly first half of 2018: Qliksense Cloud export on shared app

Users will therefore be accessing:

  • Published Apps for analysis - screen clipping charts, dashboards & small table visualisations, etc.
  • Workspace Apps to export large tables into Excel.

One important consideration with this approach is that only data in Published Apps can be scheduled to refresh automatically, so any users accessing Apps in Workspace will need to perform manual reloads.

For the cost and convenience, I think the client is pretty happy with the solution provided so far.

Any feedback, comments and questions are welcome.

Regards

Leigh

fer_damas
Contributor

Re: Qlik Sense Cloud - FTP Security

Hi, Leigh!

Great business case.

Although, it is kinda unclear for me how you connected to the Client local's server to fetch these qvd's. Could you give more details on that, if not asking too much?

Thanks!

Fernando Wenzel

logicode
New Contributor III

Re: Qlik Sense Cloud - FTP Security

‌Hi Fernando

No problem.

To fetch the QVD data from our client‘s local server, we created Web file connections through the data load editor.

In your Qlik Sense Cloud App: Data load editor > Create new connection > Web File (found under Data sources)


Under URL we then used FTP URLs (passing login credentials).

eg. ftp://username:password@hostname/subdirectory/filename.qvd

See below the support information on whitelisting the necessary IP addresses to allow the FTP requests through your firewall:

https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/LoadData/connect-data-sources.ht...

I hope this helps, but feel free to let me know if you need any further information.

Regards

Leigh