QlikView Expressor: The QlikView Connector

    The QlikView Connector is a feature of QlikView Expressor that allows a QlikView QVW script to run an Expressor Dataflow.  Each time the QVW is reloaded, the script will run the dataflow and then load the data that the dataflow has written to a QVX file.  You may use this feature of QlikView Expressor with QlikView Personal Edition, QlikView Desktop, or with QlikView Publisher or Server.  However, you must purchase an Expressor license if using Publisher or Server.

     

    Although the QlikView Connector is installed as part of QlikView Expressor, it is not installed under the Expressor installation directory but into the directory C:\Program Files (x86)\Common Files\QlikTech\Custom Data where it can be found by the various QlikView applications.

     

    In order to use the connector, you first develop and test your Dataflow and then prepare a deployment package.

     

    When using the QlikView Connector, you add statements to a QlikView script that are similar to those used to load data from a database table.  In the Data tab of the script editor, select the connector from the drop down menu

    connector_1.png

    then click Connect, which opens the Configure expressor Data Source wizard.  Now you click Add Folder and browse to directory that contains the deployment package, then click OK.

    connector_2.png

    Drill down through the deployment package hierarchy and highlight the entry corresponding to the Dataflow you want to run.  In the following screen shot there is only one Dataflow, but a deployment package may contain multiple Dataflows.

    connector_3.png

    Click OK and a CONNECT statement is added to the script.  Now, on the Data tab, click SELECT to open the Create SELECT Statement wizard.  When using the QlikView Connector, you must enter a SELECT * statement; optionally select the Preceding Load checkbox and click OK to complete.  A SELECT statement is added to your script.

    connector_4.png

    Now when you reload QlikView, the CONNECT and SELECT statements will cause the Dataflow to be run and the resulting QVX file is loaded into the QlikView application.

     

    The following video illustrates this process.