Peliqan feature list
Peliqan is an all-in data platform that provides a full modern data stack in one integrated platform.
Peliqan data platform features
Peliqan delivers a comprehensive modern data stack in one integrated platform. From automated ETL pipelines to AI-powered insights, everything you need to build a robust data foundation.
Automated ETL pipelines
Add source connections with a few clicks, and the ETL pipeline is automatically created to sync the data into the built-in data warehouse or your own DWH.
Source connections include SaaS connectors, database connectors, data warehouse connectors and data lake connectors.
250+ SaaS & Database connectors
Peliqan provides a wide range of SaaS connectors to connect your business applications.
Connect to SQL and no-SQL databases such as MySQL, Postgres, SQL Server, MongoDB and more. New connectors are added in 48 hours on demand.
Built-in DWH or Bring Your Own
Peliqan comes with a built-in scalable data warehouse based on Postgres.
You can also connect your existing data warehouse as an ETL target (Snowflake, Redshift, BigQuery, Azure SQL Server).
On-prem connectivity
Peliqan can connect to your on premise data sources through a secure VPN tunnel or using the Peliqan on-prem agent.
Access your enterprise databases securely from the cloud.
Federated query engine (Trino)
The Peliqan federated query engine Trino enables “SQL on anything”, including the ability to join data from different sources.
Query live data across multiple databases without moving it.
Schema discovery & Metadata
Peliqan automatically discovers the schema of each connected source including table structures, metadata, relations and column descriptions.
Rich metadata feeds your BI tools and AI models automatically.
Data transformations with SQL
Implement data transformations using the magical SQL editor, with ephemeral queries and/or materialized queries.
AI-powered autocomplete and suggestions help you write SQL faster.
Table materialization & Replication
Materialize any table or query in Peliqan’s built-in data warehouse or your own Dwh.
Set up table replication across databases to ensure data availability and performance.
Low-code Python IDE & Runtime
Peliqan has a built-in Python IDE and runtime with support for low-code data-centric scripts.
Schedule Python scripts, publish Streamlit apps, embed apps in your platform, and enjoy AI-powered vibe coding assistance.
Writeback & Reverse ETL
Peliqan’s low code Python scripting environment provides single line writeback to SaaS applications, and allows to implement Reverse ETL with a few lines of code.
Keep your business apps in sync with warehouse data.
Webhooks & Publish APIs
Consume incoming webhooks from any source – events are queued in a table for processing.
Publish API endpoints linked to your SQL queries or Python code to expose data products and ML models.
AI Assistant
Peliqan’s AI assistant helps you write SQL queries, transform data, and build Python scripts.
Ask questions in plain English and get instant results with AI-powered code generation.
Data lineage & Data catalog
Peliqan visualizes data lineage to understand provenance of data, data dependencies and impact of changes.
Catalog data assets by adding metadata such as table and column descriptions, tags, and owners.
Data quality & monitoring
Implement data quality checks and scheduled monitoring on datasets using low-code scripts.
Send out alerts to Slack or other channels to keep teams informed about data issues.
Metabase one-click deployment
Deploy Metabase with one click from the Peliqan market place.
The tool is automatically deployed and hosted on Peliqan, ready to connect to your data warehouse instantly.
Data explorer
Peliqan provides an innovative user interface for data engineers and business teams to work with their company data in a spreadsheet-like environment.
Filter, search, edit, and explore datasets visually.
Excel add-in
CFOs, CEOs and business users can work with Peliqan data directly in Excel.
Switch between data sources easily and work with real-time data without leaving Excel.
Embedding & Whitelabel
Peliqan is the only data platform that can be white-labeled for your business (e.g. for consultancy companies) and embedded into SaaS platforms.
Deliver data solutions under your own brand.
Data Masking & Obfuscation
Implement data masking and obfuscation to protect sensitive data such as PII using low-code Python scripts.
Ensure compliance by automatically masking customer information, financial records, and confidential business data before sharing with third parties or non-production environments.
Data Ontology & Semantic Modeling
Build custom data ontologies and semantic models using Peliqan’s low-code Python environment.
Define business rules that capture your organization’s unique data architecture. Create semantic layers that enable AI agents and analytics tools to understand the meaning and context of your business data.
Unify, Automate & Activate Your Data
Connect all your SaaS apps, databases, and spreadsheets into one workspace. Build automations, analytics pipelines, and data apps – all in one place.
Peliqan trust center
Security, compliance, trust, privacy and availability are our highest priority. If you want more details, if you require a certificate or a copy of Peliqan’s operating procedures, contact us now.
SOC 2 Type 2
SOC 2 Type 2 validates our security controls, ensuring your data is protected by independently audited security measures.
ISO 27001
ISO 27001 certification (in progress) ensures enterprise-grade information security, protecting your business with globally recognized standards.
GDPR
GDPR compliance guarantees EU data protection compliance, keeping PII data secure within EU boundaries.