> ## Documentation Index
> Fetch the complete documentation index at: https://help.peliqan.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Looker Studio

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

<img src="https://mintcdn.com/peliqan-9d7f0393/bd3Fc7iE3KLG4a0Y/images/Data%20warehouse/Data_warehouse_details.png?fit=max&auto=format&n=bd3Fc7iE3KLG4a0Y&q=85&s=e769e503edf5b3b813de26cc6d47015e" alt="Data warehouse details.png" style={{ width:"37%" }} width="708" height="1044" data-path="images/Data warehouse/Data_warehouse_details.png" />

Use these settings in Looker Studio to connect:

* **Connection type**: Postgres (default data warehouse type in Peliqan)
* **Server:**
  * [db.eu.peliqan.io](http://db.eu.peliqan.io)
  * [db.mydatacloud.com](http://db.mydatacloud.com)
  * [db.us.peliqan.io](http://db.us.peliqan.io)
  * … (check in your account under Connections > Data warehouse connection)
* **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”.

<img src="https://mintcdn.com/peliqan-9d7f0393/bd3Fc7iE3KLG4a0Y/images/Data%20warehouse/Data_warehouse_details.png?fit=max&auto=format&n=bd3Fc7iE3KLG4a0Y&q=85&s=e769e503edf5b3b813de26cc6d47015e" alt="Data warehouse details.png" style={{ width:"45%" }} width="708" height="1044" data-path="images/Data warehouse/Data_warehouse_details.png" />

Use these settings in Looker Studio to connect:

* **Connection type**: Postgres (default data warehouse type in Peliqan)
* **Server:**
  * [db.eu.peliqan.io](http://db.eu.peliqan.io)
  * [db.mydatacloud.com](http://db.mydatacloud.com)
  * [db.us.peliqan.io](http://db.us.peliqan.io)
  * … (check in your account under Connections > Data warehouse connection)
* **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:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Looker%20Studio/Screenshot_2024-08-07_at_10.42.43.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=227cccf24df5228dccb468fe8cff4e5d" alt="Screenshot 2024-08-07 at 10.42.43.png" width="1588" height="844" data-path="images/Connect your BI, DB tool or iPaaS/Looker Studio/Screenshot_2024-08-07_at_10.42.43.png" />

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Looker%20Studio/Screenshot_2024-08-07_at_10.42.43.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=227cccf24df5228dccb468fe8cff4e5d" alt="Screenshot 2024-08-07 at 10.42.43.png" width="1588" height="844" data-path="images/Connect your BI, DB tool or iPaaS/Looker Studio/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”:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Looker%20Studio/Looker_Studio_connect_Postgres_DWH.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=ef7b8a25df781636ed6d20f944f88493" alt="Looker Studio connect Postgres DWH.png" width="1616" height="1894" data-path="images/Connect your BI, DB tool or iPaaS/Looker Studio/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](/connect-your-bi-or-db-tool/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:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Looker%20Studio/looker_public_schema.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=0985ef4fa59a227513982603153f4447" alt="looker public schema.png" width="2316" height="1820" data-path="images/Connect your BI, DB tool or iPaaS/Looker Studio/looker_public_schema.png" />

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Looker%20Studio/looker_public_schema.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=0985ef4fa59a227513982603153f4447" alt="looker public schema.png" width="2316" height="1820" data-path="images/Connect your BI, DB tool or iPaaS/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: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:

<img src="https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/Looker%20Studio/looker_custom_query.png?fit=max&auto=format&n=n7mbWWerGRtqvdxO&q=85&s=04709f9ab137988a74fa59188380d28e" alt="looker custom query.png" width="1680" height="1760" data-path="images/Connect your BI, DB tool or iPaaS/Looker Studio/looker_custom_query.png" />

You can now build charts and reports in Looker Studio.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.