3 Replies Latest reply: Aug 4, 2016 11:22 AM by Tim Kendrick RSS

    Qlik Sense Enterprise

    Garrett Muzikowski

      Hello,

       

      Does Qlik Sense Enterprise have the capability to automatically download data from an online database, say on a daily basis? I see that it has the capability to "automatically refresh", but not exactly sure what that means.

       

      Also, does Qlik Sense Enterprise operate faster than the desktop version? When working with large data sets I tend to find that the desktop version lags a bit.

       

      Thanks!

        • Re: Qlik Sense Enterprise
          Daniel Ansell

          Refresh and download mean the same thing in this instance as long as you have scripted the application correctly.

           

          As for speed it would depend on how much RAM and what processors are loaded on the server.

          In most circumstances a servers processing power and amount of RAM are far greater than a desktop PC

           

          Dan

          • Re: Qlik Sense Enterprise
            Bill Markham

            If you have a qvf load script that runs manually ok in Desktop, then with Enterprise you can set it to auto run to a schedule.  With the Caveat though that the Enterprise server must have the same access to the online database as your database - often server access to the internet is more locked down on a server than a desktop.

             

            Regarding your Desktop lagging with large datasets vs. how Enterprise behaves, the answer is the infamous "it all depends".  If it lags because your Desktop is low on RAM and paging, and your Server has oodles of RAM then probably yes.  If it lags because of poor data model design and inefficient expressions, then no.

            • Re: Qlik Sense Enterprise
              Tim Kendrick

              Qlik Sense Enterprise does have the ability to automatically refresh data from any data source. That means it will run your data load on a predefined schedule (and users will be locked out of their dashboards for the duration).

               

              In my company's case, Qlik Sense Enterprise is deployed on a cloud-based VM. Therefore, we can control and scale the resources allocated to that VM to ensure it is running fast for the number of users. Remember, the Qlik Sense Engine uses IN-MEMORY COMPUTING, so make sure your hardware has a decent amount of memory for large data sets. Qlik Sense Enterprise uses the same engine as Qlik Sense desktop so it is not inherently faster than Qlik Sense Desktop. What makes it faster is giving it more resources.