Connect to Qlik Nprinting repository with QlikView

[Sahal]

Hi, I'm trying to find a step by step guide on how to connect to nprinting repository and fetching data into QlikView  (do not want a guide on Qlik Sense).

I have looked at https://support.qlik.com/articles/000026032 however i can't find pgAdmin3.exe (do i need to download it from somewhere?)

A step by step guide using QlikView would be great.

[woutermak]

Hi,

You can download it here:

https://www.pgadmin.org/download/

[Sahal]

Thank you, do you also have the step by step guide?

Should i install/open the driver on the server that has QlikView Server services or in Qlik Nprinting server (that has all the services?) more information would be great.

[woutermak]

Hi,

You only have to install it on the nprinting server to connect to the progrest database of nprinting.

https://support.qlik.com/articles/000042413

[Ruggero_Piccoli]

Hi,

We strongly suggest to avoid to connect to the PostgreSQL Repository. If you damage it your Qlik NPrinting installation could not work any more.

As conseguence there is not an official guide about how to connect.

Best Regards,

Ruggero

[Sahal]

Yes we understand that we are connecting to the repository on "our own risk", however due to the lack of easy access to metadata (e.g. like QVPR database in QlikVew) the only way we are able to get this data is by asking for help if anyone else has done it.

I would believe that this question has come up before (even if it's for Qlik Sense) and why QlikTech has not made it easier for us to get this data is beyond me?

So if you buy any chance have access to information on how to do this we are willing to take the chance.

[Sahal]

Thank you, however as stated we want to know how to connect to QlikView and not sense.

[Lech_Miszkiewicz · Accepted solution]

I agree with @Ruggero_Piccoli  that this is something you should avoid doing.

If you insist to do that anyway you should have at least basic understanding how to connect to PostgreSQL database. Therefore I am not giving away details and step by step instructions as this is something only people with confidence and knowledge should do. 

Below are high level steps. 

• Since you are using QlikView first thing you need to do is to get odbc PostgreSQL connector. You may want to search for that online. Normally you would get it from https://www.postgresql.org/website
• Your QlikView instance is likely on different server so you will need to change PostgreSQL database configuration files to allow for connection from other than local hosts.
  • https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-connect-to-postgresql-database-from-...
• Once you have both done all what you need to do on QlikView server is to use create odbc connection (this is not even QlikView step and it is just general step on how to connect to PostgreSQL db from windows using ODBC)
  • details for connection are the same as in the topic about Qlik Sense: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Repository-Database-Name/td-p/133...

As soon as you connect to DB you are on your own, so make sure you have db backup (usually it is done via pg_dump), with NPrinting there are detailed steps described on help.qlik.com how to take a backup of NPrinting repository.

good luck.

[Ruggero_Piccoli]

Hi,

The parameters of your Qlik NPrinting Repository are the ones you set during the Qlik NPrinting Server installation. Connecting to it is like to connect QlikView to any other installation of a database server.

Instead if you want to use PostgreSQL administration tool you have to refer to its documentation.

Best Regards,

Ruggero

[Lech_Miszkiewicz]

just to clarify:

Connection parameters are the same for QlikView and for Qlik Sense.

The only difference is that Qlik Sense has built in PostgreSQL odbc connector and for QlikView you need to install it manually.

From there steps are the same.