How to connect to the Qlik Sense Enterprise on Windows or Qlik NPrinting PostgreSQL database

Daniel_Seo — Wed, 28 Jun 2023 14:09:00 GMT

This article covers the installation and configuration of pgAdmin 4 (or later) to connect to either the Qlik Sense Enterprise on Windows or Qlik NPrinting repository.

Qlik cannot support direct queries and access to the underlying product's database hosted by PostgreSQL. If any issues arise for which direct queries are deemed responsible, Qlik Support will reserve the right to request that a previous working backup is restored to the system in order to bring back full operation or resolve any isolated issue(s). The steps described here in this article are only used by Qlik Support for troubleshooting purposes.

Establishing a connection

Download pgAdmin 4 or higher. The software can be found on pgadmin.org.

For deployments still utilizing PostgreSQL 9.6: pgAdmin 4 versions 6.13 and higher no longer support PostgreSQL 9. See the release notes for 6.13. 6.12 or an older version of pgAdmin can be downloaded from this archive.
Run the installation executable, and then launch the installed program as Administrator.
Create the Server
1. Right-click Servers
2. Click Register
3. Click Server...
In the following prompt, name the connection (your preferred name, it does not have to match the database name)
Switch to the Connection tab
Provide the required connection details:
1. Hostname/address: localhost (if local)
2. Port: 4432 (Qlik Sense on-prem) 4992 (Qlik NPrinting)
3. Maintenance database: postgres*
  *This value may differ if you run a standalone database and have configured it differently.
4. Username: postgres
5. Password: your password, set during installation
6. Click Save
  
  If you are running an SSL-secured database with Qlik Sense (not supported with Qlik NPrinting), proceed by configuring the SSL tab.

Reading the Repository information

This is an example on how you can afterwards access the Qlik Sense Repository information (Qlik NPrinting follows a similar structure).

Expand Servers
Select your database (in our example it is named postgres, you may have named it QSR or any other familiar name)
Expand Databases
Expand the QSR database
Scroll down to and expand Schemas
Expand public
Scroll down to and expand Tables
Review the table you wish to read.

article How to connect to the Qlik Sense Enterprise on Windows or Qlik NPrinting PostgreSQL database in Official Support Articles

How to connect to the Qlik Sense Enterprise on Windows or Qlik NPrinting PostgreSQL database

Establishing a connection

Reading the Repository information