While there are different ways to visualize your data inside Peliqan, you can also use your existing BI tool (Metabase, Power BI, Tableau, Qlik, Looker etc.) to visualise data after preparing it in Peliqan, or you can use a DB tool (BeeKeeper, DBeaver) to see tables in your Peliqan data warehouse.

You can do so by materializing one or more tables, for example a table that is based on an SQL query that you wrote. Once the table is materialized, you can connect with your BI tool to your Peliqan built-in data warehouse. See this chapter for more information: Materialize tables.

Once the table is materialized, in Peliqan go to Connections, find your Data warehouse (e.g. named “Sync Data warehouse”), select the Target in the toggle and copy & paste all the details:

Screenshot 2023-03-02 at 14.50.00.png

For SaaS sources, you can connect directly to the SaaS target database in the Peliqan data warehouse. In Peliqan go to Connections, find your Data warehouse (e.g. named “Sync Data warehouse”), select the Target in the toggle and copy & paste all the details:

Hubspot target.png

Use these settings in your BI tool to connect:

Connect your BI tool to Peliqan

Microsoft Power BI

Grafana