Skip to main content
In Peliqan, go to Connections, find the Data Warehouse tile and copy/paste your connection details: Data warehouse details.png Use these settings in Looker Studio to connect:
  • Connection type: Postgres (default data warehouse type in Peliqan)
  • Server:
  • 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: Screenshot 2024-08-07 at 10.42.43.png 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”: Looker Studio connect Postgres DWH.png Click the below link to download the SSL certificate from your instance of the Peliqan data warehouse: SSL certificates for the Peliqan data warehouse Upload the Peliqan Server Certificate (public key) and click on Authenticate. Select the table to include in Looker Studio: looker public schema.png 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: looker custom query.png You can now build charts and reports in Looker Studio.