query postgresql

[rittermd]

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?

[marcus_malinow · Accepted solution]

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]

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]

Unicode I believe