Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

query postgresql

I want to query the postgreSQL database that Qlik Sense uses.  I have only used MS SQL databases to date.  So I am not sure what to use in order to do the same things I can do in MS SQL Management Studio with this database?

1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor II

Re: query postgresql

Hi Mark,

sounds like you have two queries here:

- how to use a Postgres data source in Qlik Sense

- how to administer Postgres

To use a postgres data source, you'll need to install the Postgres ODBC driver, then set up a System DSN in your ODBC connections. You should then be able to connect to your new ODBC connection in Qlik Sense.

To administer Postgres, there's a utility called PGAdmin, which is quite similar to SQL Server Management Studio.

Marcus

3 Replies
marcus_malinow
Valued Contributor II

Re: query postgresql

Hi Mark,

sounds like you have two queries here:

- how to use a Postgres data source in Qlik Sense

- how to administer Postgres

To use a postgres data source, you'll need to install the Postgres ODBC driver, then set up a System DSN in your ODBC connections. You should then be able to connect to your new ODBC connection in Qlik Sense.

To administer Postgres, there's a utility called PGAdmin, which is quite similar to SQL Server Management Studio.

Marcus

rittermd
Honored Contributor

Re: query postgresql

Thanks.  I just downloaded and installed the ODBC driver.  I now see two entries when I create the system DSN.

1.  ANSI(x64)

2. Unicode(x64)

Which one should I use?

marcus_malinow
Valued Contributor II

Re: query postgresql

Unicode I believe