Mobile Data Reporting with QlikView

Configure ODBC

If you need assistance configuring ODBC on your Windows machine, we have a step-by-step walkthrough on our support page:

Server Data Options

1. Begin a new QlikView Application

Open QlikView and start a new application. For this example, we are using QlikView Sense.

2. Add the ODBC Connection

Click on "Add Data", click on "Connect my data", and select "ODBC".
Select "System DSN", and "32-bit" (or 64-bit depending on how you configured your ODBC), and you should see the "Pendragon Forms" connector on the list.
Select the database connection created earlier and click on the right arrow (>).

3. Add Your Data

Select the tables to add (form_id_*) where * is the form ID with your data and make sure sure the columns of data you wish to add are checked.
Click "Load data and finish".

Add Your Charts and Fields

In QlikView, you can begin to add charts and fields, using the data sources from Pendragon Forms.

Where we don't go into detail on how to fully use QlikView, you can see their tutorials at their Demo site at http://sense-demo.qlik.com/.