2 Replies Latest reply: Oct 7, 2015 3:24 AM by MOHAMMAD Hossein JADIDI RSS

    real time Select from database and update qlik view

      I have a Microsoft sql database which contain 4 table only but each table has 100,000 rows of data, an application will add new record to the database real time. a base layer provide a .QVd file daily and we have a reload schedule every morning. The application layer contain some set analysis and if and else expression. I don't want to reload the entire database once a new record is being added. Data inside database are system generated and well formed, so there is no transformation layer in this application.

       

      What is the most efficient method to Reload, partial Reload new record (real time) to my qlikview application so I can see the result of new records once I refresh the access point.