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?
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.
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?
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.
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