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.
As an alternative, you can also use the Peliqan Excel add-in !
Enable ODBC in Excel (Legacy)
In Excel > File > Options > Data: enable legacy data import wizards, see screenshot below:
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:
Add the connection details of your Peliqan data warehouse:
Use “allow” for SSL Mode.
Add a connection in Excel
In Excel, go to Data > Get Data > From Other Sources > ODBC > Select your DSN.
Next, select tables and/or queries from Peliqan to load in Excel.
If you want to work with queries written in Peliqan, make sure to set the option “Create as view” in Peliqan for that query, so that it is visible in the data warehouse and hence in Excel.
The selected tables will be loaded in Excel and can be refreshed at any time:
You can also use Power Query in Excel.
In Excel go to Power Query > New Source > Other Sources > ODBC > Select your DSN.
