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”. 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:Select PostgreSQL from the list: Screenshot 2024-08-07 at 10.42.43.png 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”: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 certficate from your instance of the Peliqan data warehouseClick the below link to download the SSL certficate 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. Upload the Peliqan Server Certificate (public key) and click on Authenticate. Select the table to include in Looker StudioSelect the table to include in Looker Studio: looker public schema.png 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: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.