Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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?
Unicode I believe