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

[Daniel_Seo]

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

1. 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.

2. Run the installation executable, and then launch the installed program as Administrator.
3. Create the Server
   1. Right-click Servers  
   2. Click Register
   3. Click Server...
      
      
      
      
4. In the following prompt, name the connection (your preferred name, it does not have to match the database name)
   
   
   
   
5. Switch to the Connection tab
   
6. 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).

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