Automating a data download from Qlik

[MaheshSurendran]

Hi,

    I am wondering if someone can point me to automating a download from Qlik. Any help would be appreciated.

Mahesh Surendran

[marksouzacosta]

Hi @MaheshSurendran,

I need more details of what you are trying to do. Are you thinking about moving a QVD file from Qlik Cloud to an on-prem machine?

Regards,

Mark Costa

[MaheshSurendran]

Hi Mark,

   I really appreciate your reply. Could you please tell me something about yourself? Do you work for Qlik?

   I am not sure I am trying to download a Qlik QVD file. We could get on a Teams Chat and I could screen share what I am trying to do. 

   I am not sure we have the Cloud version of Qlik. I will try and find out.

   Usually we right click and ask to download a Qlik data set which in turn queries some other data environment. Once it is ready for download, we then download it. It is tedious to repeat this multiple times for multiple Qlik datasets.

   So I am wondering if there is a way to automate this so we do not have to download data multiple times from Qlik.

Mahesh Surendran

[hugo_andrade]

Hi @MaheshSurendran,

Yes, this can usually be automated.

If the goal is to save the data somewhere instead of manually right clicking and downloading it each time, a cleaner approach is to write the file during the app reload itself.

You can create a data connection to the destination where you want the file to be saved, then use the Store command in the load script to write the file directly there. That way, every time the app reloads, it can generate the output file automatically.

So instead of treating Qlik as a place where a user manually exports data, you let the reload process create the file for you.

This is especially useful if:

• the export always follows the same logic

• the output needs to go to a known folder or location

• you want the process to run on a schedule without user interaction

The main thing to confirm is what the destination is. For example:

• a folder location

• SharePoint

• S3

• another connected storage target

Once that part is clear, the next step is usually to set up the right data connection and then store the final table there as part of the reload.

Super powerful approach, and usually much more reliable than trying to automate a manual UI download.

Hope this helps.

Please give it a like, mark it as Helpful or Solution if that was the case.

[MaheshSurendran]

Hi Hugo,

    Thanks for your message and suggesting the way forward.

    However, I am new to creating data connections and to using the STORE command in the load script. Are you able to walk me through these steps or suggest something I could read?

Mahesh Surendran

[hugo_andrade]

Would Sharepoint/Onedrive be a valid option for you to store these files?

I believe I have a working example

[MaheshSurendran]

Hi Hugo,

    By OneDrive do you mean a folder such as C:\Users\xxxx\OneDrive - Santander Office 365\xxxx\?

    Could you please send me the example? Thanks so much for your help.

Mahesh

[hugo_andrade]

@MaheshSurendran ,

A good way to handle it is to create a data connection to the destination, for example SharePoint or OneDrive, and then use the script to store the output file there during the app reload. That way, Qlik generates the file for you instead of manually download it each time.

So the general flow would be:

• connect to the target location,
• prepare the table in the script,
• then use the Store command to dump the data out to that connection.

The main questions I would check first are:

• Do you have access to create a new data connection in your environment?
• Are you on Qlik Cloud, Qlik Sense, or QlikView?

[MaheshSurendran]

Hi Hugo,

    I can create a data connection.

    Here is the information I have on Qlik:

      Is this sufficient?

Mahesh

[MaheshSurendran]

Hi Hugo,

    In the data load editor I can create a new connection and I get the following screen:

Mahesh