How To Configure Tunneling Using Microsoft Internet Information Server (IIS)

[Andre_Sostizzo]

QlikView's OCX clients (Desktop Client and Internet Explorer Plugin) communicates with QlikView Server on port 4747 with the QVP protocol. If this port is not allowed by network or local firewall the traffic can be tunnelled through HTTP. 

Prerequisites

• QlikView server installation
• Microsoft IIS: The QVSTunnel.dll file must be added as an ISAPI filter

Restrictions and limitations

• Tunnelling will not function properly with a clustered QlikView Server setup. Tunnelling can only address one server node, not a cluster. 
• Tunnelling adds overhead to the data transfer, which may result in a slower connection. It is recommended to use Full browser version (AJAX) client if possible instead of tunnelling.

Confirm that QvsTunnel.DLL is installed

1. Go to C:\Program Files\QlikView\Server
2. Search for folder called QvTunnel
3. Confirm that QvsTunnel.dll is in the QvTunnel folder
4. If the QvsTunnel.DLL exists, continue on step 16

Install QvsTunnel.DLL if needed

1. Go to Programs and Features in Windows, 
   Control Panel > All Control Panel Items > Programs and Features
2. Highlight QlikView Server in the program list
3. Click Change to start the installer
    
   

    

4. On the Program Maintenance dialogue select Modify and click Next 
   
   
   
   
5. Expand Microsoft IIS Support
6. Expand the QlikView Tunnel ISAPI dll dropdown
7. Select “This feature, and all subfeatures, will be installed on local hard drive”. 
   
   
   
   
8. Click Next
9. Fill in QlikView Server logon information.
10. Click Next
11. Click Install to start installation

Microsoft IIS Setup to enable QlikView tunnelling

1. Open the Internet Information Services Manager
2. Select the IIS top node
3. Open the ISAPI and CGI Restrictions 
   
   
   
   
4. Choose Add in the Actions pane
5. Set the ISAPI or CGI path to point to the QvsTunnel.dll
6. Define a description for the restriction
7. Check Allow extension path to execute 
   
   
   
   
8. Open the site that should host the QlikView Server/Publisher pages
9. Click on Scripts
10. Open the Handler Mappings dialogue 
    
    

     

11. Locate the ISAPI-dll
12. Choose Edit Features Permission in the Actions pane
    
    
    
    
13. Check Execute in the dialog that opens 
    
    
    
    
14. If IIS and QlikView Server are on separate machines, then the following registry keys must be created upon the web server, as this tells the webserver how to forward the traffic to the QlikView Server:
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\QlikTech\QlikTunnel]
    (Key entry for QlikTunnel)
    
    "QVSPort"=dword:000012a6
    (dword entry if 32bit install and qword entry if 64bit install) 
    
    "QVSServer"="QvsHost"
    (String Value entry and QvsHost is the actual QlikView Server machine name)
    
    

     

15. Open a web browser and browse to http://localhost/scripts/qvstunnel.dll?test
16. If everything is installed correctly a message like below will appear.