Installation

Komment
1.Import the extension from the Qlik Management Console (QMC)
2.The Komment extension should now be available from the Custom Objects tab under Extend BI bundle
Make sure you have the needed privileges to import extensions on the QMC 
If you already have a version of Komment installed, make sure to delete this from the QMC before you upload the latest version
Disable QVD data connection and storage
If you as admin wants to restrict developers from using QVD as data storage that is also possible. It is done by disabling QVD Data Connection and QVD Storage. Follow these simple steps to achieve this.
1.Go to the folder where you have your Komment.zip file.
2.Open the zip file and navigate to static\config
3.Copy the file Settings.txt
4.Navigate out of the zip file and paste the Settings.txt file in the initial folder
5.Open the Settings.txt file
6.Change value to "true" and save and close the file
7.Copy the Settings.txt file
8.Open the Komment.zip file and navigate to static\config
9.Paste the Settings.txt file and say OK to replace the existing file
10.Navigate out of the zip file
11.Follow the above steps to import the updated zip file to the QMC
You should only disable QVD storage if you have Kaptain installed as you otherwise won't have any way to save your data.
Kaptain
If you are on a Standard plan or higher you have access to our Kaptain service.
Installation
From version 2.5.0
Scope: The below is valid for installations on Kaptain on Windows servers (it can be the Qlik Sense server but does not have to be)
Pre-requisites: 
You must have access to the Windows/Qlik server with admin rights
Make a public port ready on the server so end user can access Kaptain service successfully:
If you install kaptain on same server as Qlik, you will need to define a port number (or choose default kaptain port 8000).
If you install kaptain on a dedicated server, a typical https port (443) will be preferred. In addition you will need to open 4747 port inbound on Qlik server to let Kaptain communicate with Qlik Engine.
Authentication: Based on certificates
Files needed: Kaptain-installer-2.5.0.exe
Installation steps:
Initial steps:
1.Copy Kaptain-installer.exe to the Windows server
2.Start installation by double click the Kaptain-installer.exe
3.Choose Full Installation and installation folder and press Next
4.Navigate to C:\Program Files\ExtendBI\Kaptain
1.Open the file C:\Program Files\ExtendBI\Kaptain\config\default.json as Administrator
2.Update the following according to your system:
1.corsAllowOrigins
2.userId
3.COMPANY
​
​
Steps for creating Certificate and key-file in .pem format:
Step 1-6 can be ignored if Kaptain is installed on Qlik Sense server
1.Open the QMC of your Qlik Sense server
2.Navigate to the Cetificates section
3.Press 'Add Machine Name' and enter your Kaptain server name (e.g. kaptain.extendbi.com)
4.Ignore password but Check mark to include secret key
5.Export file format for certificates as PEM-format
6.Press 'Export Certificates' button
7.Go to Windows File explorer and navigate to C:\ProgramData\Qlik\Sense\Repository\Exported Certificates
8.Copy Client.pem, Client_key.pem, Root.pem and paste into C:\Program Files\ExtendBI\Kaptain\config\Qlik
9.Go back to QMC and Certificates section
10.Press 'Add Machine Name' and enter your Qlik Sense server name (e.g. qlik.extendbi.com)
11.Enter password and Check mark to include secret key
12.Select Windows format for the file format
​
​
13.Press 'Export Certificates' button
14.Copy the exported files to C:\Program Files\ExtendBI\Kaptain\config\kaptain folder
15.Navigate to C:\Program Files\ExtendBI\Kaptain
1.Open the file C:\Program Files\ExtendBI\Kaptain\config\default.json as Administrator
1.Set usePfxCertificate to true
2.Set pfxPassword to the password defined when exporting the Certificates
​
​
Steps to configure inbound traffic:
1.Open powershell as administrator
2.Run the following command:
1
New-NetFirewallRule -DisplayName "Kaptain Inbound" -Direction Inbound –LocalPort 8000 -Protocol TCP -Action Allow –Profile Domain 
Copied!
​
Start Kaptain services:
1.Open the Windows Server Manager
2.Start Kaptain DB Service and Start Kaptain Server Service
 Check settings:
1.Open the file C:\Program Files\ExtendBI\Kaptain\config\default.json as Administrator
2.Ensure you have the correct settings defined for the certificate related elements:
1.settings => qlikHost:"cert"
2.hosts => cert =>
1.keyFile:"qlik/client_key.pem"
2.caFile:"qlik/root.pem"
3.certFile:"qlik/client.pem"
​
​
If you want to base the authentication on JWT please contact us at [email protected]
Up to version 2.4.x
Download the file below for instructions on how to install Kaptain on a Windows server.
Kaptain_Installation steps_JUN2021.xlsx
19KB
Binary
Kaptain Installation Instructions June 2021
External DB configurations
If you wish to store data in one of the supported external databases you need to configure the relevant one in the Kaptain configuration.
Kaptain Configuration file:
The system administrator must setup the proper settings for the DBs to be used by Komment. This is done in the Kaptain configuration file that is installed together with Kaptain. 
Default location: C:\Program Files\ExtendBI\Kaptain\config\default.json
The configuration file has a section for each DB which must be adjusted to your setup:
1
"mssql": {
2
    "MSSQL_SERVER": "mssql.extendbi.eu-central-1.rds.amazonaws.com",
3
    "MSSQL_PORT": 1433,
4
    "MSSQL_USER": "admin",
5
    "MSSQL_PASSWORD": "strongpassword",
6
    "MSSQL_DATABASE": "Kaptain",
7
    "DRIVER": "msnodesqlv8",
8
    "OPTIONS": {
9
      "encrypt": true,
10
      "enableArithAbort": true,
11
      "trustedConnection": false
12
    }
13
  },
14
  "oracle": {
15
    "ORACLE_SERVER": "oracledb.extendbi.eu-central-1.rds.amazonaws.com",
16
    "ORACLE_LIB": "C:\\Projects\\instantclient_19_11",
17
    "ORACLE_PORT": 1521,
18
    "ORACLE_USER": "admin",
19
    "ORACLE_PASSWORD": "strongpassword",
20
    "ORACLE_DATABASE": "ORCL"
21
  },
22
  "mysql": {
23
    "MYSQL_POOL": 300,
24
    "MYSQL_SERVER": "mysql.extendbi.eu-central-1.rds.amazonaws.com",
25
    "MYSQL_PORT": 3306,
26
    "MYSQL_USER": "admin",
27
    "MYSQL_PASSWORD": "strongpassword",
28
    "MYSQL_DATABASE": "Kaptain"
29
  },
30
  "postgresql": {
31
    "POSTGRE_USER": "postgres",
32
    "POSTGRE_SERVER": "localhost",
33
    "POSTGRE_DATABASE": "Kaptain",
34
    "POSTGRE_PASSWORD": "strongpassword",
35
    "POSTGRE_PORT": 4432
36
  }
Copied!
Windows authentication for MS SQL
For the MS SQL database it is possible to use Windows authentication. For it to work make sure that:
DRIVER: "msnodesqlv8" and trustedConnection: true as in the below example.
1
"mssql": {
2
    "MSSQL_SERVER": "mssql.extendbi.eu-central-1.rds.amazonaws.com",
3
    "MSSQL_PORT": 1433,
4
    "MSSQL_USER": "admin",
5
    "MSSQL_PASSWORD": "strongpassword",
6
    "MSSQL_DATABASE": "Kaptain",
7
    "DRIVER": "msnodesqlv8",
8
    "OPTIONS": {
9
      "encrypt": true,
10
      "enableArithAbort": true,
11
      "trustedConnection": true
12
    }
Copied!
​
If not already part of your standard MS SQL installation, please ensure that you have Microsoft® SQL Server® 2012 Native Client - QFE installed as well. The official download site can be reached here: https://www.microsoft.com/en-us/download/details.aspx?id=50402​
​
SSL instructions
You might need to install ssl on your server. You can use the below package:
libssl-1_1-x64.zip
5MB
Binary
Open SSL tool
Installation steps:
1.Download the file above and extract it to the server -  e.g. c:\install\openssl
2.Paste your PFX file into same folder - e.g cert.pfx
3.Open a CMD as Administrator
4.Go to the folder where you extracted the - e.g. c:\Install\openssl\
5.Execute the following commands:
 openssl pkcs12 -in server.pfx -out "c:\install\server.pem" -nokeys -password pass:<your pass>
 openssl pkcs12 -in server.pfx -out "c:\install\server_key.pem" -nocerts -nodes -password pass:<your pass>
6.Paste the files generated in step 5 into kaptain install folder: \config\kaptain\
7.Restart kaptain service
8.Open kaptain admin console in browser and check if there’s still certificate warning
Welcome
Next - Getting started
Load script
Last modified 7mo ago
Copy link
Contents
Komment
Disable QVD data connection and storage
Kaptain
Installation
External DB configurations
SSL instructions