3 Replies Latest reply: Jan 5, 2016 9:39 AM by Vladimir Komarov RSS

    Your experience in using QlikSense with data warehouse

    Mark Hohlov

      We are going to use a data warehouse in order to aggregate huge amount of data from multiple sources. What are your experience in working with DWH from QlikSense? Are there certain "more preferable" DHW solutions for QlikSense? Have you ever faced a certain obstacles causing you risks/problems when integrating QlikSense with data warehouse solutions?

        • Re: Your experience in using QlikSense with data warehouse
          Michael Tarallo

          Hi Marks,

           

          Thanks for your question.

           

          I expect the more experienced and those that have implemented this in the field with Qlik Sense to chime in as well, but allow me to add my 2 cents.

           

          Technically your "data warehouse" - is just another data source to Qlik. Qlik Sense and QlikView - take the data from the source and load it into its in-memory indexing engine - which compresses the data and only stores the unique values. It also associates common elements of the data based on common field names. By default - you can directly load the source(s) into the app itself, but as an implementation grows it is common to create this in-memory representation stored on disk in a .qvd file - and then load the app directly from that file. Note that you can perform CDC-like operations and procedures and update the QVD as needed. These apps loaded from the .QVD file can be refreshed on  a scheduled basis as needed.

           

          For more detail - you may want to look at this Technical Brief it was originally designed with the QlikView product in mind but Qlik Sense and QlikView use the same engine so it is applicable - you can start around page 5.

           

          Please let us know how you do and if we can be of further assistance.

           

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

          Mike Tarallo

          Qlik