Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Seo
Support
Support

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

Last Update:

Jun 28, 2023 10:09:00 AM

Updated By:

Sonja_Bauernfeind

Created date:

Nov 17, 2017 10:43:22 PM

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

      Create Server.png

  4. In the following prompt, name the connection (your preferred name, it does not have to match the database name)

    Name the connection.png

  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

      connection details.png

      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.

    expand tables.png
              
Labels (2)
Version history
Last update:
‎2023-06-28 10:09 AM
Updated by: