Connectors

Contact support

Helpdesk portal

Excel (ODBC)

Excel (ODBC)

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:

image

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:

image

Add the connection details of your Peliqan data warehouse:

image

Use “allow” for SSL Mode.

Add a connection in Excel

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

image

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:

image

You can also use Power Query in Excel.

In Excel go to Power Query > New Source > Other Sources > ODBC > Select your DSN.

image