7 Replies Latest reply: Apr 25, 2013 11:48 AM by Michael Tarallo RSS

    The value with QlikView Expressor

    Fredrik Quirin

      Hi,

       

      We are extracting data out of multiple databases and Excel sheets and saving it different QVD files (this is our repository for reuse data in different QVW end user applications). I was wondering what value we would get, if we would start to use QlikView Expressor? Do we have to convert all of our qvd-files to qvx-files? The file qvw file size will increase if we will read data out of qvx instead of qvd.

       

      Is there a way to source controll QlikView script and Design layor in Expressor? Today we are using QlikView Publisher to refresh all our qvw and qvd files. Is there also a way to compile a project in Expressor with QlikView Publisher - and is it the way we should go?

       

      Regards

      Fredrik

        • Re: The valute with QlikView Expressor
          Hugo Sheng

          Hi Fredrik,

           

          Your observations regarding QVX vs QVD are correct, though I suspect that as the 2 products become further integrated, QVD support within Expressor would appear as well.

           

          In the meantime, there are several key benefits you could realize from using Expressor:

          • Semantic Metadata - allows you to conform heterogenous data sources into a common data model.  This can be the model already created within QlikView.
          • Built-in source control - dataflows and other artifacts created within Expressor can be checked into a central repository and versioned over time
          • Graphical designer for data access and provisioning - minimize the need to develop and maintain scripted solutions
          • Logic re-use - reduce or eliminate the need for 1-off solutions by leveraging Expressor's Semantic Metadata layer
          • QlikView Connector - ability to seamlessly call Expressor as a data source directly from within QlikView 11 without having to manually launch Expressor.  QlikView load script(s) automatically get created.   This makes integration into Publisher very seamless as well.

           

          Let us know if you have any additional questions.

           

          Hugo

            • Re: The valute with QlikView Expressor
              Fredrik Quirin

              Thank you for your answer Hugo.

               

              Is there still a value with Expressor for QlikView develoment if all data goes through SSIS packages (Microsoft)?

              Do I unserstand you right, that we could convert  star schemas in our QlikView scripts to Expressor and use one connector instead?

               

              Do you have any example Expressor projects that I could use to test QlikView Connector? Does QV Connector work together with Expressor Desktop Edition?

               

              Thank you

              Fredrik

                • Re: The valute with QlikView Expressor
                  Hugo Sheng

                  Yes, you could translate QlikView scripts over to Expressor dataflows.  However, you may want to evaluate the reason for doing so.   Expressor currently only generates QVX files.   Further, the value in having a star in QlikView is to take advantage of the associative model.   Combining that data into a single QVX would lose much of that.   Of course, if the intent is to replace that with a QVX instead of QVD, then sure, that would work.

                   

                  I'll upload an example project shortly.

                  • Re: The valute with QlikView Expressor
                    Hugo Sheng

                    See the attached Expressor project.  Do not uncompress it.  You should be able to import it directly into Expressor via the project import option.   Open the project afterwards and have a look - there's simple dataflow that joins a flat file to an Excel file and writes the output to QVX.   There's also a Deployment Package created for this dataflow.  The Deployment Package is a requirement for using QlikView Connector.

                     

                    Next, within QlikView, create a new QVW and edit the load script.  Choose the QlikView Connector as shown and click Connect:

                    2012-08-17_142220.png

                    Next, locate the Deployment Package mentioned above.   You'll have to go into the Expressor workspace area as shown below

                    2012-08-17_142510.png

                    Select just the top level project that contains the Deployment Package.

                     

                    2012-08-17_142533.png

                    Click OK and notice that it inserts the CUSTOM CONNECT statement

                    2012-08-17_142557.png

                    Next, click the Select button to pick the data columns to bring in

                    2012-08-17_142639.png

                    To select all, just click OK and you should now see the select statement inserted as well.

                    2012-08-17_142707.png

                    At this point, you can reload the data and what will happen is that Expressor will be invoked in the background, run the dataflow, and pass the data into QlikView via the QVX file.