Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Update records dinamically from database's views

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.

Tags (3)
11 Replies
Not applicable

Re: Update records dinamically from database's views

up please

MVP
MVP

Re: Update records dinamically from database's views

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
Honored Contributor

Re: Update records dinamically from database's views

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

Not applicable

Re: Update records dinamically from database's views

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?

Not applicable

Re: Update records dinamically from database's views

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.

MVP
MVP

Re: Update records dinamically from database's views

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

prieper
Honored Contributor II

Re: Update records dinamically from database's views

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

Peter

Not applicable

Re: Update records dinamically from database's views

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

Not applicable

Re: Update records dinamically from database's views

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