All-in-one data platform

Peliqan brings ETL pipelines, data transformations and reverse ETL together in one integrated platform. Connect your favorite BI tool, activate your data with SQL and low-code Python and build a data foundation for your AI Agents.

Platform Overview

ETL Data pipelines with built-in data warehouse or bring your own

Connect to any data source in a few clicks and start exploring your data. Peliqan automatically creates an ETL data pipeline which requires zero maintenance. Peliqan also provides real-time access to any external database thanks to its federated query engine.

Peliqan comes with a built-in data warehouse, or you can use Snowflake, BigQuery, Redshift or SQL Server. Materialize tables, queries and views in your data warehouse to speed up queries and for downstream data sharing. Easily connect existing BI tools and other platforms to your data warehouse.

Use your favourite BI tool

Use your favourite BI tool

Use your preferred BI tool to connect to the Peliqan data warehouse such as Microsoft Power BI, Tableau, Qlik or activate Metabase with a single click from the Peliqan market place.

SQL - Combine data

Model and Transform with magical SQL

Easily transform data to make it ready for ad hoc analysis and downstream usage. 

Write SQL queries in a magical editor that provides smart highlighting, lookups and suggestions, powered by AI.

Optionally run your queries on Peliqan’s built-in federated query engine Trino to join data from different databases.

Spreadsheet BI for business users

Beautiful Data explorer

Explore data in a beautiful and rich data explorer. Filter, group, search, follow relations, view metadata on datasets of any size.

Add your own tables with a few clicks for mapping data, annotations and more and edit your data inline.

Low code scripting for data activation

Low-code scripting for data activation

Developers can implement a wide range of use cases using low-code Python scripts. 

Go beyond analytics, make data interactive, perform writebacks and apply machine learning with just a few lines of code. 

Enjoy direct unified data access from your code. Write, test, run all in one place.

Data lineage and Data catalog

Data lineage & Data catalog

Peliqan automatically detects table and column lineage across the spreadsheet UI, SQL queries, low-code data apps and any other data pipeline.

Peliqan comes with a Data Catalog to store all your metadata.

Reverse ETL & data sync to business applications

Reverse ETL & data sync to business applications

Set up reverse ETL to keep data in sync between your business applications.

Configure any type of data sync: 1-way, 2-way etc.

Optionally customize your writeback scenarios with low-code Python scripts.

Use Excel to work with your data

Excel add-in for business users

CFOs, CEOs and other business users can work with Peliqan data in Excel thanks to the Peliqan Excel add-in.

Easily switch between data sources and work with your data in real-time in Excel.

Let AI do the work for you

Let AI do the work for you

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 data explorer.

Write custom pipelines, data apps and AI agents with AI-assisted coding in Peliqan’s low-code Python editor.

Publish Data APIs

Publish Data APIs

Publish API endpoints and link them to your code. Publish data products, share data and expose ML models through API endpoints.

Consume incoming webhooks from any source. Incoming webhook events are queued in a table and can easily be queried or processed in your Python code.

Marketplace

One-click deploy of best-of-class tools

Choose best of class tools in Peliqan’s market place and deploy them with a single click. 

Start using tools such as Metabase, Jupyter notebooks, Apache Airflow and Apache Superset within your Peliqan environment.

Enterprise-grade features built-in

Peliqan connects to on-prem databases and other data sources using a secure point-to-point VPN tunnel. Install the agent on your server, connect it to Peliqan and start querying your data from the cloud.

Activate SCD T2 history tables (slow-changing dimensions, type 2 tables) to capture historic data and perform time travel on all your data.

Peliqan connectors come with rich metadata to feed your BI and AI, including relations and table & column descriptions.

Peliqan Overview

Ready to get instant access to
all your company data ?