Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martinr_
Creator
Creator

Load data from ODBC data source cyclically (Sense Desktop)

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.

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
martinr_
Creator
Creator
Author

Hi !

We have the Server.

I can do it also on this way?

Best Regards,

Martin

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
martinr_
Creator
Creator
Author

Thank you. That is the solution

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Great.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!