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.