We wanted a small internal app on top of our business data, built with Claude Code, without setting up our own database, login and hosting for it. In Peliqan we created a new machine in the Peliqan Machine section, connected our coding agent through the Peliqan CLI, and downloaded the instructions.md file for Claude Code to work from. Claude Code built the app and deployed it over SSH with the CLI. We checked the preview, then clicked Publish to production.
We look after several legal companies, and each one has its own Exact Online administration. Every connection gives you the same tables, but they're separate, so any report across all companies meant repeating the same work per company.
Peliqan has a data app template called union connection data. You run it, pick the connection type, select the connections and the tables you want to combine, and click Generate queries. It creates the union queries in their own folder and activates them as views. Each row gets a source column that tells you where it came from, and the columns and data types are lined up across all of them.
We built our dashboards on those views. When we add a company, we run the template again instead of rewriting SQL.
We already had a Snowflake data warehouse and didn't want a second one. In Peliqan we added Snowflake as a connection and set it as the target, and now our pipelines from HubSpot, Stripe and Xero load into it. Our analysts kept working in the same place.
Peliqan.io is an all-in-one data platform to unify your company data.Low-code data warehouse for developers & engineers, no-code data access for business teams. Get to insights fast, use your favourite BI tools and implement data syncs (reverse ETL) for your RevOps, FinOps and DataOps.