Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

Web Edition Doc Quick Links
QVSource Web Edition is now commercially available should be used - if you are still using the WinForms edition please upgrade now as this is deprecated and will no longer be supported after the 22nd May 2016.

You should find most of the documentation on this wiki for the WinForms edition of QVSource still applies, particularly the connector specific pages (ignoring the minor UI differences).

The following are the most important Web Edition specific pages:

  • Web Edition Overview - A short introduction to the new QVSource Web Edition including the benefits and high level differences.
  • Getting Started - A guide on running the QVSource Web Edition in its simplest mode (e.g. servicing requests from localhost only with no user authentication).
  • Example Deployment Scenarios - Some example diagrams showing how QVSource Web Edition might be deployed with QlikView and Qlik Sense.
  • Advanced Configuration - How to perform advanced configuration of QVSource, for example allowing remote access and setting up users.
  • User Management - How to manage users.
  • Upgrading from WinForms Edition - How to upgrade.
  • SSL Configuration - How to set up a test SSL certificate so that traffic between your browser (or QlikView/Qlik Sense) is encrypted.
  • Troubleshooting - Read this page first if you are having trouble running QVSource.
  • Cloud Hosted Demo - Information on a cloud host demo edition we are currently testing out.


Image


QVSource Web Edition is a browser based version of QVSource, the highly rated product for connecting QlikView and Qlik Sense to a large number of Web APIs and other sources which are traditionally more difficult to load from in QlikView and Qlik Sense.

QVSource Web Edition is now commercially available. We are also hosting a cloud version of it for demo and testing purposes (which you can read about here) and may consider launching a commercial cloud hosted offering in the future.

The QVSource Web Edition is primarily a redevelopment of the front end UI for QVSource, the code for the connectors is 99.99% the same now in both versions and any updates made to the connectors will appear in both versions (they will share the same change logs and version numbers).

Image



Advantages Of QVSource Web Edition

We believe QVSource Web Edition will offer a number of advantages to our customers:
  • Central hosting. The current version of QVSource needs to be installed, administered and updated on each machine where a QlikView or Qlik Sense reload is taking place (including servers and any machine where a QlikView or Qlik Sense developer is working with the product). QVSource Web Edition can be run and administered from a single server within an organisation and users can simply browse to it.
  • No more remote desktop (RDP) needed - With the current version you will often need to use up an RDP connection to perform some configuration or checking of QVSource on the server, this will no longer be needed with the web edition.
  • A cleaner and richer user interface. We are adding new features to the web user interface to help alert users to updates to both QVSource itself and also live issues which might be affecting the APIs they are using as well as features to make it easier to access log files and manage user settings.
  • Cloud hosting opportunities. Now QVSource is a web app we have new opportunities to host it on public web URLs. We might use this to allow users to evaluate the product without even needing to download or install it (although we expect that for production usage QVSource will still be run on the customers local machines in most cases as with the standard version of QVSource). NOTE: We are already experimenting with a cloud hosted version.
  • Running from mobile devices. With Qlik Sense, Qlik appear to improving their ability to allow users to create and edit apps from mobile devices such as tablets and QVSource Web Edition should allow them to use QVSource in the same work flow. We have been testing the QVSource Web Edition on the iPad and it appears to be working well (in landscape mode only) and we plan to test with other tablet devices based on user interest.

We hope that the QVSource Web Edition will become the standard over the following 12 months and would like to retire the standard windows forms edition. However we are keen to listen to customer feedback and address any concerns which this might raise.

Differences To WinForms Edition

There are a couple of minor specific things which you should be aware of if you are a user of the previous WinForms edition:

  • Authenticating with certain connectors (which use OAuth1 or OAuth2) is sometimes tricky on iPads and other touch screen devices. This is because you are usually redirected to a separate tab/window where you are required to copy a code and paste it back into the QVSource Web UI and sometimes this is fiddly on touch screens. We would recommend you first authenticate with these connectors from your desktop or laptop computer, the authentication details will then be stored and you should be able to interact with the connector from your iPad without difficulty.

  • We have had to make a breaking change to the Sentiment Analysis & Text Analytics Connector which means you will have to make a minor modification to your load scripts as noted here. NOTE that this change is now also in the WinForms edition of QVSource version 1.6.5.3 and later, we have had to make this change so the connector can run in the new Web Edition.

  • The 'copy to clipboard' feature/button does not work in all browsers (it should work in FireFox 41+, Chrome 42+, IE 9+ and Opera 29+ but may not work on tablet devices. If the copy to clipboard button does not work it is a simple matter to select the script content and use the standard copy to clipboard button or short cut on your chosen OS and browser.

Miscellaneous

QVSource users sometimes use the store command in QlikView or Qlik Sense to create a CSV file containing data which is then used by another connector. For example, a common scenario is to write a table of Tweets to a CSV file and then configure the Sentiment Analysis Connector to read and process this file.

Remember that QVSource needs to be able to read from the location on the file system (or share) where QlikView or Qlik Sense wrote this file. If they are both running on the same server (which we expect to be the recommended setup) then this should not be an issue. However please keep this in mind.

Another solution to the Tweet/Sentiment scenario above is to loop through the data in your load script, this avoids any file system access from QlikView or Qlik Sense but it may not be as performant and it does not give QVSource a chance to process the table of data in a more efficient way (e.g. using multi-threaded calls or making use of any batching features which the API might provide).

Installing QVSource Web Edition

Please see the getting started guide for the web edition for instructions on how to install this in localhost only mode with no authentication (essentially a straight swap in replacement for QVSource WinForms edition) and this page for more advanced configuration.

Introductory Video to QVSource Web Edition

On the 22nd September 2015 we hosted a webinar about the QVSource Web Edition and below you will find a recording of it and you can download the slide deck from here.



(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd