topic Load data from ODBC data source cyclically (Sense Desktop) in Connectivity & Data Prep

Load data from ODBC data source cyclically (Sense Desktop)

martinr_ — Mon, 19 Dec 2016 14:49:02 GMT

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.

Re: Load data from ODBC data source cyclically (Sense Desktop)

kaushiknsolanki — Mon, 19 Dec 2016 16:20:41 GMT

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

Re: Load data from ODBC data source cyclically (Sense Desktop)

martinr_ — Mon, 19 Dec 2016 16:43:40 GMT

Hi !

We have the Server.

I can do it also on this way?

Best Regards,

Martin

Re: Load data from ODBC data source cyclically (Sense Desktop)

kaushiknsolanki — Tue, 20 Dec 2016 10:14:03 GMT

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

Re: Load data from ODBC data source cyclically (Sense Desktop)

martinr_ — Tue, 20 Dec 2016 10:15:15 GMT

Thank you. That is the solution

Re: Load data from ODBC data source cyclically (Sense Desktop)

kaushiknsolanki — Tue, 20 Dec 2016 10:21:13 GMT

Great.

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

Regards,

Kaushik Solanki