You can use MS Query or Power Query in Excel to connect to the Peliqan data warehouse.

Note: MS Query and Power Query (with DB connection) are only available in Excel on Windows, not Mac.

<aside> 💡

As an alternative, you can also use the Peliqan Excel add-in !

</aside>

Enable ODBC in Excel (Legacy)

In Excel > File > Options > Data: enable legacy data import wizards, see screenshot below:

excel options legacy data.png

Install Postgres ODBC driver on Windows

Download the Postgres ODBC driver:

https://odbc.postgresql.org/

Choose the 64 bit version (X64) for recent computers.

Add a DSN

Open ODBC Database Administrator on Windows (64 bit version if you are using a recent computer). Add a User DSN, choose PostgreSQL Unicode:

dsn postgres.png

Add the connection details of your Peliqan data warehouse:

dsn.png

Use “allow” for SSL Mode.

Add a connection in Excel

In Excel, go to Data > Get Data > From Other Sources > ODBC > Select your DSN.