topic Re: Update records dinamically from database's views in QlikView

Update records dinamically from database's views

Wed, 24 May 2017 13:24:03 GMT

Hi everyone,

I've created a OLE DB connection with my db, and i want to use just some views that i've created for qlik desktop.

I've two question:

1) When my tables' data will be modified, my data into my app (from views created from theese) will be modified too? If not, how can i do to make it possible?

2) If I've created a connection to my database, how can i delete or modify it from qlik?

Thank you.

Re: Update records dinamically from database's views

Mon, 29 May 2017 06:47:42 GMT

up please

Re: Update records dinamically from database's views

tresB — Mon, 29 May 2017 07:06:18 GMT

Qlik products are not really made for real-time analysis of data. However, with some limitations you might get something very close to that.

Check the following threads:

Real-Time Data Processing

How to use Dynamic update action in QV 11

Accessing large data sets with Direct Discovery or pdf here

Re: Update records dinamically from database's views

ahaahaaha — Mon, 29 May 2017 07:25:29 GMT

Hi Mauro,

1) If you change the data in your tables, there will not be an automatic change in QlikView application. To change the data in QlikView application, it is necessary to reload (partially load the changed data) from the changed tables into it. The download can be configured automatically after a certain period of time, either by means of the QlikView Server or by using a macro (if you are using Personal Edition version of QlikView). The reload interval should be less than or commensurate with the time of data change in the tables. For example, when constructing indicators of employee employment, we did an automatic reboot every three minutes. To control the receipt of money funds to the settlement account, an interval of 1 hour was used.

2) Connection to your DB through OLE DB in the script code takes one line. Changing or deleting this line, respectively, changes or deletes the connection of your QlikView application to your DB.

Regards,

Andrey

Re: Update records dinamically from database's views

Mon, 29 May 2017 07:48:53 GMT

thank you, but I've wrote wrong up there: i don't have a database, but only some free table (visual foxpro tables).

I'm connecting to them with a ole db connection.

your solutions are for qlik view, but i'm using qlik sense desktop. it's the same thing?

Re: Update records dinamically from database's views

Mon, 29 May 2017 07:52:20 GMT

thank you,

when you say "The download can be configured automatically after a certain period of time" how can i do this with qlik sense desktop?

i've seen my db connection (it's starts with LIB CONNECT TO ....), but i don't know how modify it to reload all data every hour.

Re: Update records dinamically from database's views

tresB — Mon, 29 May 2017 08:05:30 GMT

You might have to go for extension then. Check this:

Re: Update records dinamically from database's views

prieper — Mon, 29 May 2017 08:19:26 GMT

You may do with ordinary batch-files and WIN-scheduler or execute with QMC.

Peter

Re: Update records dinamically from database's views

Mon, 29 May 2017 08:36:10 GMT

I've searched into Qlik Branch but i've not found any extension for dynamic update!

Re: Update records dinamically from database's views

Mon, 29 May 2017 08:38:43 GMT

i don't want to add "complexity" into this project.

i would give just an app with all sheet and dynamic update of tables, because people that will use it aren't so good and i need a monkey-proof solution

Re: Update records dinamically from database's views

Anonymous — Mon, 19 Jun 2017 18:24:03 GMT

Hi Mauro,

Let me know if you found a solution to this - this is something i may need.

Thank you

Re: Update records dinamically from database's views

Anonymous — Tue, 12 Jun 2018 07:15:17 GMT

Hi Mauro,

Let me know if you get any solution to dynamically update the db in qlik sense desktop.

Regards