> ## Documentation Index
> Fetch the complete documentation index at: https://docs.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
## "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":
## Connect your BI tool to Peliqan
[SSL certificates for the Peliqan data warehouse](/connect-your-bi-or-db-tool/ssl-certificates-for-the-peliqan-data-warehouse)
## Connect your DB tool to Peliqan
## Connect your iPaaS automation tool to Peliqan
This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.