Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

How to Connect to the PostgreSQL Database used for Qlik NPrinting Repository

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Yoichi_Hirotake
Former Employee
Former Employee

How to Connect to the PostgreSQL Database used for Qlik NPrinting Repository

Last Update:

Feb 23, 2023 9:11:24 AM

Updated By:

Sonja_Bauernfeind

Created date:

Nov 3, 2016 1:18:19 AM

Modifying the Qlik NPrinting Repository will void the Support Agreement! Changes to the database should be performed by the Qlik NPrinting services only or through the use of supported API calls.

Qlik NPrinting use PostgreSQL as the repository database. For exploratory purposes, you can connect to the repository using pgAdmin.

  1. Go to Windows Services.msc and stop all Qlik NPrinting services except the QlikNprintnigRepoService.
  2. Go to Folder C:\Program Files\NPrintingServer\pgsql\bin and double click  pgAdmin3.exe 
  3. Click Add a connection to a server button
User-added image
 
  1. Enter below information into New Server Registration window and press OK button
Name: Nprinting
Server: localhost
Port: 4992
Maintenance DB: Postgres (select from pull down)
Username: Postgres
Password:  The password that you entered on installation

User-added image
 
  1. Now connected to Qlik Nprinting Repository
User-added image

Note:   It may be necessary to perform the following in order to connect to the database from other servers or from same NPrinting server without using 'localhost' or loopback 127.0.0.1 IP:  

  1. Stop all NPrinting services including the repoService.
  2. Obtain a backup copy of and then open the file C:\ProgramData\NPrinting\data\postgresql.conf
    Note: Older version may store this under c:\Program Files\NPrintingServer\data instead.
  3. Change the parameter listen_addresses to equal '*', and remove the # sign from the beginning of the parameter string

    e.g: listen_addresses = '*'

  4. Save and close the file.

  5. Obtain a backup copy of and then open the file C:\ProgramData\NPrinting\data\pg_hba.conf

  6. Change the line below the string "# IPv4 local connections:" to look like the following:

    host all all 0.0.0.0/0 md5

  7. Save and close the file.

  8. Start the QlikNPrintingRepoService.

  9. Attempt connecting to the database.

Note: It is recommended to have all remaining services stopped when connecting to the database.

Labels (1)
Comments
Luck
Partner - Contributor II
Partner - Contributor II

Hi, 

Is There any possibilities for nprinting to utilize database traffic encryption using SSL like qliksense does in this link ?

 

Best Regards,

Lucky

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Luck 

Let me verify this for you.

All the best,
Sonja 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Luck 

This is not currently supported. I would suggest logging an idea.

All the best,
Sonja 

ccaporaso
Partner - Contributor III
Partner - Contributor III

Hi!

Is it possible to use connection data provided in the post to access NPrinting Repository through Qlik Sense Postgres connector?

Any precaution or advice? 

I'd be nice to access (read only mode) to the database to get relationships that are not easily shown (or not shown at all) in NPrinting application (eg. To which tasks a report is attached, In which tasks a user appears as destination, etc). 

When the use of NPrinting is intensive, maintenance can be difficult without that kind of information.

Regards,

Cecilia.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @ccaporaso 

This an interesting application of the Qlik Sense Postgres connector! And absolutely doable. As long as you (as you already mentioned) do not POST to the db and stay in read-only mode, you'll be good to go.

All the best,
Sonja 

ccaporaso
Partner - Contributor III
Partner - Contributor III

Hi @Sonja_Bauernfeind 

Thanks a lot for your answer! I'll proceed developing this set of analysis then.

Best regards, have a nice day.

Cecilia.

Sebastian_Dec
Creator II
Creator II

Hi, thanks a lot, great article. It connected without a problem.

Version history
Last update:
‎2023-02-23 09:11 AM
Updated by: