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.


We are experimenting with a cloud hosted version of QVSource Web Edtion to help test the new version and provide certain select partners and customers with a way of trying out the product without needing to download and install it.

We may also consider launching a robust cloud hosted version in the future however please note that we do expect that customers will run the product locally on their own systems in most cases as is the case with QVSource WinForms Edition.

Please do not use the cloud hosted version of the QVSource Web Edtion for anything live or production based, it is intended for experimentation only.

Before reading this page, you should also read the introduction to QVSource Web Edtion as most of the information there (apart from the setup section) is relevant to this version.

Limitations

The cloud hosted version imposes a number of limitations (in addition to any noted more generally here).

  • If you try to run any table which needs to read or write to the local file system, this will return an error. Note that if you install QVSource Web Edition locally you can also configure this in deploy.config (using the AllowConnectorsFileSystemAccess element).
  • The MongoDB Connector is disabled. This is because this could theoretically channel GBs of data through our servers which would not be good for other users.
  • Currently the cloud hosted version is a single node cluster and occasionally we may need to reboot the server or update QVSource. It goes without saying that you should not use this for production use.

Please note also that with the cloud hosted version you are sharing computing resources with a number of other users which may make the application perform more slowly than if you were running it locally (which is the likely production scenario).

Security

Encryption

The cloud hosted version of QVSource is secured using industry standard SSL so all communications with both the web UI and between QlikView or Qlik Sense are encrypted.

If you have been given a login to our cloud hosted version, please do not share it with anybody - ask them to email us and cc you if they would like access.

Allowed IPs

You can log in to the web UI from any IP address however, the QlikView or Qlik Sense load scripts which you generate can by default only be run from IP addresses you 'white list'.

You will find this setting here (note that QVSource also tells you your current IP address and gives you a facility to add this to the list):

Image

User Settings

Any parameters you enter into tables in connectors will be stored by QVSource in a file in a user specific folder as is the case if you run any QVSource edition locally. Authentication tokens and passwords are also encrypted.

If at any time you would like to delete this data please go to the 'All Connector Settings' section at the bottom of the above page and click the following button:

Image

Note that you can also delete the settings just for a particular connector by going to the 'Settings' tab for that connector as well as any cached data:

Image

You can also delete any log file specific to you:

Image

We do not retain any copies or backups of your data so if you delete all of the above files they will be permanently deleted. However if you are not comfortable with your data being stored on our systems please do not use the service. You can also read our privacy policy here.

Usage

If you are a QVSource Standard Edition user then you should find the web version very similar. Here we go through a simple example of authenticating with the Twitter Connector. First, select the connector:

Image

And select a table:

Image

Next click the 'Authenticate' button:

Image

A new browser window or tab should now open where you authenticate with Twitter. Once you have done this you should receive a code which you should copy:

Image

And paste back in to the connector:

Image

You should find you now have an access token saved with your settings:

Image

And you can now enter some parameters for the table:

Image

You should see a preview of the results:

Image

And you can now copy and paste the generated load script into your QlikView or Qlik Sense application:

Image
  Name Size
- allowed ips.png 185.32 KB
- delete all.png 14.53 KB
- delete cache.png 100.84 KB
- delete logs.png 124.70 KB
- twitter access token.png 101.34 KB
- twitter auth.png 111.26 KB
- twitter code.png 82.55 KB
- twitter copy script.png 177.58 KB
- twitter data.png 174.23 KB
- twitter paste code.png 112.37 KB
- twitter run table.png 143.77 KB
- twitter search.png 128.51 KB
- twitter.png 178.97 KB


(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