topic Re: Connecting to PostgreSQL from QlikSense in Connectivity & Data Prep

Connecting to PostgreSQL from QlikSense

prathamb7 — Mon, 13 Dec 2021 18:03:38 GMT

Hi All,

Looking for help in regards to setting up connectivity to a PostgreSQL database from Qliksense. Could you please suggest on what is the recommended way to setup connectivity between from Qliksense to a PostgreSQL db, is it the out of the box PostgreSQL connector option that qlik provides as documented here: https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/PostgresSQL/Create-PostgreSQL-connection.htm

installing a driver as suggested on the following post: https://community.qlik.com/t5/QlikView-Integration/Connecting-qlikview-to-PostgreSQL-with-ODBC-connector/m-p/1183973#M2867

Please suggest. Thanks for your help.

Re: Connecting to PostgreSQL from QlikSense

Vu_Nguyen — Tue, 04 Jun 2019 12:55:50 GMT

Hi, both solution should work. Qlik ODBC Connector package (the built-in connector in Qlik Sense) does not require installing anything else to make the connection. Meanwhile, using ODBC driver provided by the database vendor may result in higher data load performance. So it's absolutely up to your choice.

Re: Connecting to PostgreSQL from QlikSense

dvbxr6bud — Fri, 30 Aug 2019 13:50:16 GMT

Hi,

i followed the instructions and got the next massage:

do you have an idea what should i do?