5 Replies Latest reply: Oct 21, 2017 9:27 AM by Mithilesh Bhoir RSS

    Data Refreash

    Jay Sai

      The Database Which I connected with my Qlik Sense. That database gets refreshed every week so here my question is how should i refresh the data in Qlik Sense automatically 


      For manually reload it taking 9 hours


      So client want to get data refreshed automatically in Qlik sense as well every week when ever the database gets refreshed?

        • Re: Data Refreash
          Mark Little

          Hi Jay,

           

          You will need to have a QlikSense server to schedule the reload and you will need to look at Incremental loads for your data, so you are only getting newer data on reload.

           

          Mark

            • Re: Data Refreash
              Jay Sai
              On what field I have to do with incremental and also you said Qlik Sense Server reload schedule. 


              What is that can you brief it please you mean we can schedule the automatic jobs in Qlik Sense Server?


                • Re: Data Refreash
                  Mark Little

                  Hi Jay,

                   

                  The normal approach would be a date field, but if it is transactions you could use the transaction number.

                  First you would load all the data you have then store to QVD.

                  Once you have your qvd, you update your loader, so it pick up your max date.

                  then load from source where greater than your max date.

                  The store back to qvd.

                   

                  There is lots on here about the sense server if you have a look around, but yes it allows you schedule your reloads and much more.

              • Re: Data Refreash
                Mithilesh Bhoir

                Hi Jay,

                 

                If you have data of several years, one approach would be freeze the old data which not gets updated and store it in qvd say data till 31st Dec, 2016 (one time activity)

                 

                and reload only current year data ( i.e for 2017 year data)

                 

                In the app, concatenate both qvds. It will save your valuable time.

                 

                Regards,