> ## 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.

# Connect your BI, DB tool or iPaaS

> Connect Peliqan to BI tools, DB clients and iPaaS platforms using Postgres settings, and learn how to expose Peliqan SQL queries as views.

You can use your favorite BI tool (Metabase, Microsoft Power BI, Tableau, Qlik, Looker etc.) to visualise data after preparing it in Peliqan, and you can use a DB tool (BeeKeeper, DBeaver) to work with tables in your Peliqan data warehouse.

Use these settings in your BI tool to connect to Peliqan:

* **Connection type**: Postgres (default data warehouse type in Peliqan)
* **Host**:
  * db.eu.peliqan.io
  * db.mydatacloud.com
  * db.us.peliqan.io
  * ... (check in your account under Connections > Data warehouse connection)
* **Port**: 5432 (for Postgres)
* **User name & password**: copy / paste from the **Data Warehouse** tile under My Connections in Peliqan (see above)
* **Database name**: same as the user name
* **SSL**: enabled

[SSL certificates for the Peliqan data warehouse](https://help.peliqan.io/connect-your-bi-or-db-tool/ssl-certificates-for-the-peliqan-data-warehouse.md)

## "Create as view" for SQL Queries

In order to see SQL queries written in Peliqan inside your BI tool, you need to set the option "Create as view". Once this is done, you can consume those queries it in your BI tool.

In the SQL editor, click on the Settings icon in the top right corner (gear icon) and enable "Create as view":

![Enabling create as view](https://mintcdn.com/peliqan-9d7f0393/n7mbWWerGRtqvdxO/images/Connect%20your%20BI,%20DB%20tool%20or%20iPaaS/create_as_view.png?fit=max\&auto=format\&n=n7mbWWerGRtqvdxO\&q=85\&s=9708db8ebf07c3720ececb2faf1bb843)

## Connect your BI tool to Peliqan

> **[Microsoft Power BI](https://help.peliqan.io/power-bi.md)**

> **[Looker Studio](https://help.peliqan.io/looker-studio.md)**

> **[Tableau](https://help.peliqan.io/tableau.md)**

> **[Grafana](https://help.peliqan.io/grafana.md)**

> **[Metabase](https://help.peliqan.io/metabase.md)**

> **[AWS QuickSight](https://help.peliqan.io/aws-quick-sight.md)**

> **[Apache Superset](https://help.peliqan.io/apache-superset.md)**

> **[Excel (ODBC)](https://help.peliqan.io/excel-odbc.md)**

> **[Excel add-in](https://help.peliqan.io/excel-add-in.md)**

> **[Salesforce CRM Analytics](https://help.peliqan.io/salesforce-crm-analytics.md)**

## Connect your DB tool to Peliqan

> **[DBeaver](https://help.peliqan.io/d-beaver.md)**

> **[BeeKeeper Studio](https://help.peliqan.io/beekeeper-studio.md)**

## Connect your iPaaS automation tool to Peliqan

> **[Peliqan and n8n](https://help.peliqan.io/peliqan-and-n8n.md)**

> **[Peliqan and Make.com](https://help.peliqan.io/peliqan-and-make.md)**

> **[Peliqan and MS Power Automate](https://help.peliqan.io/peliqan-and-power-automate.md)**


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