topic Connect QlikView to PostgreSQL - ODBC in Qlik NPrinting

Connect QlikView to PostgreSQL - ODBC

Sahal — Mon, 14 Sep 2020 16:19:57 GMT

Hi,

From our local Nprinting server we are able to connect to Nprinting repository via ODBC without any issue.

**Works**

**Nprinting server**

**Inbound port opened on Npritning server**

However when we install the odbc driver on our QlikView server we are not able to connect to the Nprinting repository

There are no firewall issue between Nprinting and QlikView servers but we are still not able to "Telnet" then Nprinting server on 4992 from our QlikView server.

Do we need to change any config files on the Nprinting server to connect to postgresql server from Another server?

**Does not work**

**QlikView Server**

Re: Connect QlikView to PostgreSQL - ODBC

fosuzuki — Mon, 14 Sep 2020 19:34:06 GMT

Hi,

By default the database is localhost only. To connect from outside, it is necessary to change a config file. Did you do it?

Check this: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-connect-to-postgresql-database-from-another-server/td-p/1690365

Re: Connect QlikView to PostgreSQL - ODBC

Sahal — Tue, 15 Sep 2020 08:05:39 GMT

To make it easier for anyone seeking the same information.

You have to change 2 config files.

C:\ProgramData\NPrinting\data

pg_hba.conf & postgresql.conf