Install Qlik Sense Server with Bundled PostgreSQL
Deploy and Configure Qlik Sense
Overview
This guide walks you through installation process of Qlik Sense server with bundled installation of PostgreSQL.
Bundled installation of PostgreSQL is easy to install but is limited when it comes to upgrading it to a newer version. Having gone through an upgrade of a bundled installation of PostgreSQL, I recommend installing Qlik Sense with a standalone installation of PostgreSQL.
Still, if you have a need or preference for a bundled installation of PostgreSQL for your Qlik Sense server, this guide will show you how to get Qlik Sense installed with a bundled installation of PostgreSQL.
In this guide, you will learn:
Process for installing Qlik Sense server.
Meaning of terms like cluster and node.
Different Qlik Sense licensing models and steps for activating Qlik Sense with corresponding licensing model.
Prerequisites
There are four prerequisites that you need to have in order to successfully install and activate Qlik Sense server:
Service account with admin privileges that will be used to install Qlik Sense and to run Qlik Sense services.
Shared folder that will be used to house Qlik Sense apps, logs, app contents, etc.
Qlik Sense license.
Browser to administer Qlik Sense.
If you have those four things ready, you're all set to get Qlik Sense server installed. Let's get started!
43
STEPS
27
SCREENSHOTS
LOW
COMPLEXITY
Step 01.
Go to location where you've saved Qlik Sense install files.
Step 02.
Right-click the setup file and select Run as administrator option to begin installation process.
Step 03.
Click Run button in Security Warning window.
Step 04.
Click Yes in the User Account Control window.
If you're running install file from a local directory (Downloads folder, Desktop folder, etc.) you will see this window instead:
Step 05.
Click Install button in Qlik Sense Enterprise installation window.
Step 06.
Read through License Agreement and check the I accept the license agreement checkbox if you do.
Step 07.
Click Next.
Step 08.
On Create or join a cluster screen, click Create a cluster button.
Step 09.
On Select the host name screen, select the server on which you are installing Qlik Sense.
Step 10.
Click Next.
Step 11.
On Set up the repository database screen, select Create a new database option to create a new PostgreSQL database that will be used by Qlik Sense as its repository.
Step 12.
On Configure new database (1/2) screen, enter a password, in Database user password field, that you would like to use for the qliksenserepository database user.
Step 13.
Re-enter the password in Confirm password field.
Step 14.
Expand Advanced settings and take a note of the Database port number used for the repository database.
Step 15.
Click Next.
Step 16.
On Configure a new database (2/2) screen, enter a password, in Set a password field, that will be create for superuser account (a.k.a. the postgres admin account).
Step 17.
Re-enter the password in Confirm the password field.
Step 18.
Click Next.
Step 19.
On Provide information for the Qlik services (1/2) screen, enter the domain name and username of the service account that will be used to run Qlik Sense services.
Step 20.
Enter password of the service account in Password field.
Step 21.
Click Next.
Step 22.
Enter shared root folder location to be used to house Qlik Sense data like apps, app contents, logs, etc.
Step 23.
You may expand the Advanced settings to see folders that will be automatically created in the shared root folder once Qlik Sense is installed.
Step 24.
Click Next.
Step 25.
On Where would you like to install Qlik Sense screen, leave the default Installation location, or specify your own if you would like to change it.
Step 26.
Click Next.
Step 27.
On Ready to install screen, select options that you would like to be enabled and click Next.
Step 28.
If you chose to install object bundles, read through the License Agreement for Qlik Sense Object Bundle and click I accept the license agreement, if you do.
Step 29.
Click Install to being installation of Qlik Sense on your server.
Step 30.
Wait for Qlik Sense to install.
Step 31.
Once installation is complete you will see the Qlik Sense has been installed message.
Step 32.
You will likely also see a warning icon next to the Qlik Sense Management Console button.
Step 33.
Once all Qlik Sense services are running, click on the Qlik Sense Management Console button.
Step 34.
Enter username of the service account that was used to install Qlik Sense.
Step 35.
Enter password of the service account that was used to install Qlik Sense.
Step 36.
Click OK to log in to Qlik Management Console (QMC).
Step 37.
On Site license properties screen, enter the singed license key for your site.
Step 38.
Click Apply to activate your copy of Qlik Sense.
Step 39.
If the license you bought is in the form of a serial number and a control number, instead of a Signed License Key (SLK), click the Switch to using serial number and control number link to switch licensing model.
Step 40.
If you use serial number and control number to activate your copy of Qlik Sense, populate Owner name, Owner organization, Serial number, and Control number fields.
Step 41.
If you received a License Enabler File (LEF) with your purchase of Qlik Sense, copy and paste LEF details in the input box in License details section.
Step 42.
Click Apply to activate your copy of Qlik Sense.
Step 43.
Click Close on the popup message confirming that your Qlik Sense license has been successfully activated.
Guide
Summary
Done!
You have successfully installed Qlik Sense server! Not only that but hopefully some of the terms used in the installation process make more sense now and there's more clarity around creating vs. joining clusters, creating bundled vs. connecting to a standalone PostgreSQL, and activating Qlik Sense using different licensing models.
Now that you have Qlik Sense up and running, the next set of lessons will show you how to install a patch to take advantage of bug fixes and enhancements available for your Qlik Sense server. Steps showing how to install a patch are covered in the next lesson. I'll see you there!
Authentication fails repeatedly when using external DNS alias locally on the server
QLIK SUPPORT ARTICLE
Learn more about impacts of using server alias name during Qlik Sense installation, what issues that may cause, how to resolve them, and security vulnerability to consider and avoid by choosing to use server name instead.
References
Up Next
Patch Qlik Sense
Copyright © 2023 howdash LLC