Load data from ODBC data source cyclically (Sense Desktop)

[martinr_]

Hello !

I have an app in the Sense Desktop with a data source ODBC.

There I load the data with this Script

LIB CONNECT TO 'ODBC DATA';
LOAD *;
SQL SELECT * FROM TABLE;

However, the data is not loaded automatically every time it is opened.
Can I set a task there, that the data is always load cyclic at 6 o'clock am.
Or always open the App?

Thanks for the help.

[kaushiknsolanki]

Hi,

To do this you need Qlik Sense Server, which has a functionality of scheduling the reports to reload at specific intervals.

You can also have a look at the below links for more help.

https://github.com/eapowertools/QlikSenseTask

How to reload a QlikSense application by command line ?

Regards,

KaushikSolanki

[martinr_]

Hi !

We have the Server.

I can do it also on this way?

Best Regards,

Martin

[kaushiknsolanki]

Yes,

All you need to do is create a new task and add the trigger on that task for what so ever frequency you want.

Regards,

Kaushik Solanki

[martinr_]

Thank you. That is the solution

[kaushiknsolanki]

Great.

Please mark the post as correct so that other users having same issue can get help looking at the post.

Regards,

Kaushik Solanki