Activate your ClickHouse data: business alerts, custom reporting, publish data APIs, set up reverse ETL, automations & integrations with low-code Python.
ClickHouse is a high-performance columnar database built for real-time analytics on massive datasets. Originally developed at Yandex, it powers low-latency queries across billions of rows for product analytics and observability. Peliqan provides managed ELT connectors that sync directly into ClickHouse, handling schema mapping, deduplication, and incremental loads without writing Kafka pipelines.
Sync data from 300+ SaaS business applications and databases into ClickHouse with a few clicks.
Sync data from ClickHouse back into your business applications (reverse ETL). Prepare data for your favorite BI tool such as Microsoft Power BI, Tableau, Qlik Sense, Looker or Metabase.
Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool.
Use Peliqan’s built-in distributed query engine to combine data between sources, e.g. write between tables in ClickHouse and other external databases.
Use your preferred BI tool (Power BI, Tableau, Metabase etc.) to visualize your ClickHouse data.
Deploy Metabase with a single click from the Peliqan Market Place and use ClickHouse in Metabase.
Sync with Google Sheets for easy data analysis from any source.
Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.
Use Retrieval-Augmented Generation (RAG) for knowledge lookups and text-to-SQL for analytics. Deploy AI agents that can answer questions, produce SQL, or trigger actions.
Access, combine, and report on data from ClickHouse and all your SaaS apps instantly.
Gain valuable insights by bringing all your business data together in one place within minutes.
A cloud data platform for everything you want to do with ClickHouse data after the sync.
Analyze your ClickHouse data with SQL or in a spreadsheet.
Enable business users with controlled self-service data access to ClickHouse.
Work with your ClickHouse data in a spreadsheet that is always up-to-date.
Create charts and visualize your ClickHouse data in dashboards.
Create views for “human in the loop” processes when working with ClickHouse data.
Build custom reports from ClickHouse in HTML, PDF…
Peliqan provides 300+ managed ELT connectors that load data directly into ClickHouse with incremental syncs, automatic schema evolution, and managed credential rotation. There is no need to write Airflow DAGs, Azure Data Factory pipelines, or Glue jobs.
Connect a source in a few clicks, choose the tables you need, and Peliqan handles the rest. Initial backfills and ongoing incremental loads run on a schedule you control.
Peliqan covers 300+ sources including CRM (Salesforce, HubSpot, Pipedrive), ERP (NetSuite, SAP, Odoo, Exact Online, AFAS), ecommerce (Shopify, WooCommerce, Magento), marketing tools, support platforms, databases, and files. Browse the full connector catalog to see every source available.
If a source is not yet supported, Peliqan offers a 2-week custom connector SLA so you are never blocked.
Sync frequency is configurable per connector. The default is every 15 minutes on the Pro plan, with custom schedules and on-demand triggers available on higher tiers. Sync mode is incremental, so only new or changed records are pulled, which keeps source API usage low and costs predictable.
Yes. Peliqan’s reverse ETL pushes data from ClickHouse back into operational systems like Salesforce, HubSpot, Mailchimp, or Slack. Run flows on a schedule, on demand, or trigger them with SQL conditions. Read the reverse ETL documentation for setup details.
Once data lands in ClickHouse, you can run SQL queries, build dashboards in Power BI, Tableau, Metabase, or Looker, expose data to AI agents through MCP servers, build Text-to-SQL workflows, or trigger reverse ETL flows. Peliqan also includes a built-in spreadsheet UI for ad hoc analysis without writing SQL.
Peliqan is SOC 2 Type II certified, GDPR compliant, and ISO 27001 certified. Credentials are stored encrypted at rest, all transfers happen over TLS, and EU-resident data stays in EU infrastructure on the eu.peliqan.io region.
Connect ClickHouse to the rest of your stack and build the reports, dashboards and AI workflows your team needs.
