Update records dinamically from database's views

[#1]

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.

[#2]

up please

[tresesco]

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

[ahaahaaha]

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

[#5]

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?

[#6]

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.

[tresesco]

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

[prieper]

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

Peter

[#9]

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

[#10]

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