In Peliqan, go to Connections, find the Data Warehouse tile and copy/paste your connection details:

Use these settings in Looker Studio to connect:

• Connection type: Postgres (default data warehouse type in Peliqan)
• Server: db.eu.peliqan.io (for EU instance)
• User name & password: copy / paste from the Data Warehouse Connection tile (see above)
• Database name: same as the user name
• SSL: enabled

Step by step

In Looker Studio, click on “Create” and choose “Data source”.

Select PostgreSQL from the list:

Paste the host name from the Peliqan data warehouse, e.g. db.eu.peliqan.io , the database name, username and password and check the checkbox “Enable SSL”:

Upload the Peliqan Server Certificate (public key) and click on Authenticate.

Click below to download the .pem file (Server Certificate) for the EU instance of Peliqan:

Select the table to include in Looker Studio:

If the table you need is not visible, use a custom query using the correct schema name and table name, for example to get data from Odoo:

You can now build charts and reports in Looker Studio.