topic Re: Update data from query in Connectivity & Data Prep

Update data from query

alexandernatale — Mon, 02 Dec 2019 12:20:24 GMT

Good morning,

I have a doubt as to which is the best way to go to periodically upload data through a query to an external DB.

The data that is extracted from the query - every hour - is many.

The DB consists of data from the last 2 years.

Is it possible to perform partial uploads via Qliksense Cloud / Business?

What I wonder is: is it possible to upload or UPDATE, appending the data to an existing table on qlik?

Thank to all

Re: Update data from query

andoryuu — Mon, 02 Dec 2019 17:09:58 GMT

Sadly Qlik Cloud does not support incremental load.

If you are experiencing delays due to the updated data your best bet with Qlik Cloud may be to try Direct Query and do a full reload during lower usage times (i.e. overnight).

Re: Update data from query

alexandernatale — Mon, 02 Dec 2019 20:07:16 GMT

Thanks @andoryuu for your reply.

I thinks that the Direct Query, in my case, it's not possible because i launch a query with many JOIN ecc.

So I necessarily need a connection with OLEDB / ODBC.

This is a very big limitation of QLikSense Cloud 😞

Re: Update data from query

andoryuu — Mon, 02 Dec 2019 21:26:53 GMT

No problem @alexandernatale . You're right that it's a big limitation. Hopefully the rectify it soon. If you have DDL rights on the database (or can replicate/etl the data in a database where you do have DDL rights) you could create a view to direct query and have it pull rows that are >= reloadtime() as this would give you rows that came after the reload of the app.

If either of my answers have satisfied your question please mark them as the answer. Thanks!