Prerequisites to connecting to QlikView server

For QlikView you will need access to the QlikView server. Metric Insights requires you to install a small agent on the QlikView server. This agent communicates with QlikView via its API and returns data to Metric Insights.

A port (8443) will need to be opened for communication back from the agent on the QlikView server to Metric Insights.

The agent is a Java / .NET program that is a few MB in size. It is referred to as a Remote Data Collector and we have detailed instructions on how to install it. You will need to install JRE (Java Runtime Engine) and .NET on the machine that runs the Remote Data Collector.

Alternate Approach

An alternate approach is to host the Metric Insights agent on another Windows server in the same network as QlikView. In this configuration the agent communicates with QlikView server over ports 80 and 443 (http/https), and also port 4747 (using "qvp" - the QlikView protocol) and port 4799.

A port (8443) will need to be opened for communication back from the agent on the Windows server to Metric Insights.

1. QlikView Authorization options

When installing QlikView Server, either QlikView Web Server (QVWS) or IIS Authorization can be used. Prerequisites per both options are described below.

1.1. QVWS Authorization

QlikView Web Server supports 2 types of authorization:

  • NTFS (with Windows controlling file access)
  • DMS (with QlikView controlling file access)

NOTE: Make sure that the user whose credentials are provided when establishing connection with QlikView server has access to required Documents and is a Member of a QlikView Administrators Group (see the picture pelow).

 Make sure that Windows user that is used in the QlikView connection profiles has permissions to access .qvw document in Windows (Right click .qvw doc > Security > Edit > Add qlik user > Apply Full control permissions and Save). After that we can get QlikView object into Metric Insights. This needs to be done because with NTFS auth  Windows controls docs permissions and if user is not in the list of users that have full access to a doc, QlikView plugin can't open this object and get its Metadata.

All Authorised users should get access to the Documents (see the picture below).

1.2. IIS Authorization

Ensure the following is installed:

  • ASP.NET 4.5
  • ISAPI Extensions
  • .NET Extensibility
  • Dynamic Content Compression
  • Windows Authentication

To setup an Authentication via IIS, navigate to:

QLIKVIEW > Sites > Default Web Site > QvAjaxZfc > select a file and click Authentication at the folder option screen > Make sure that Windows Authentication is set to 'Enabled'.

Next: Collecting data. Finally, once setup, pulling data from QlikView is easy. You configure a data connection in Metric Insights. Then begin collecting data.

0 Comments

Add your comment

E-Mail me when someone replies to this comment