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.
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.
Start instantly with Peliqan’s built-in columnar data warehouse, or seamlessly connect to Snowflake, BigQuery, Redshift, or SQL Server.
Query live data across external databases without moving it, thanks to Peliqan’s federated query engine powered by Trino.
Push data to your 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.
Configure 1-way, 2-way, or custom multi-way data syncs to keep your CRM, marketing tools, and operational systems perfectly aligned with your warehouse.
Optionally customize your writeback scenarios with low-code Python scripts for complex merge logic, deduplication, and conditional updates.
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.
Write, test, and schedule Python scripts directly in Peliqan with instant access to all your data – no local setup or dependency management required.
Create interactive Streamlit dashboards, automate complex processes, call external APIs, train ML models, or trigger custom business logic – all in one place.
Demo
Learn about low-code Python Data Apps, covering their use cases for automation, custom data pipelines, and API endpoints, as well as features like Streamlit UI, scheduling, versioning, and built-in dwh functions.
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.
Transform data with an intelligent SQL editor featuring smart autocomplete, syntax highlighting, and AI suggestions – or simply ask questions in plain English.
Peliqan automatically detects table and column lineage across SQL queries, Python scripts, and pipelines, with a built-in data catalog for all your metadata.
Peliqan provides real-time access to any external database thanks to its federated query engine. Optionally run your queries on Peliqan’s built-in federated query engine Trino to join data from different databases.
Join data from PostgreSQL, MySQL, MongoDB, Salesforce, and 250+ sources in a single SQL query – without moving or copying data.
Query fresh data in real-time for exploratory work, one-off reports, or validation before committing to full data pipelines
Demo
Learn how Peliqan’s federated query engine powered by Trino lets you seamlessly combine data from databases, APIs, and SaaS applications using standard SQL.
Publish API endpoints and link them to your code. Publish data products, share data and expose ML models through API endpoints.
Publish secure REST APIs backed by SQL queries or Python code to share data products, expose ML predictions, or integrate with external systems.
Consume webhooks from any source – events are automatically queued in a table for easy querying and processing in your Python workflows.
From secure on-premise connectivity to automated data lineage and time-travel capabilities, Peliqan includes the governance and security features your enterprise needs – right out of the box.
Use your preferred BI tool to connect to the Peliqan data warehouse..
Activate Metabase with a single click from the Peliqan market place and start using it within your Peliqan environment instantly.
Peliqan automatically detects table and column lineage across the spreadsheet UI, SQL queries, low-code data apps and any other data pipeline.
Activate SCD T2 history tables (slow-changing dimensions, type 2 tables) to capture historic data and perform time travel on all your data.
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.
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.
Peliqan connectors come with rich metadata to feed your BI and AI, including relations and table & column descriptions.
Connect all your SaaS apps, databases, and spreadsheets into one workspace. Build automations, analytics pipelines, and data apps – all in one place.
