Skip to main content
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

​
”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

​
Connect your BI tool to Peliqan

Microsoft Power BI

Looker Studio

Tableau

Grafana

Metabase

AWS QuickSight

Apache Superset

Excel (ODBC)

Excel add-in

Salesforce CRM Analytics

​
Connect your DB tool to Peliqan

DBeaver

BeeKeeper Studio

​
Connect your iPaaS automation tool to Peliqan

Peliqan and n8n

Peliqan and Make.com

Peliqan and MS Power Automate