Peliqan is an all-in-one data platform and iPaaS that provides direct data access to a wide range of data sources including databases, data warehouses and SaaS business applications. Peliqan provides one-click ETL pipelines from 100+ sources. Peliqan has a built-in data warehouse or you can use your own data warehouse (Snowflake, BigQuery, Redshift, SQL Server etc). Peliqan combines magical SQL with low-code Python to get work done fast, including setting up BI, data activation, data syncs (reverse ETL), publishing data apps and data APIs, embedding and more.

Basics

Overview and concepts

ETL: Connect to data

Working with data in the grid view

Connect your BI or DB tool

Market place: install Metabase etc.

Multi-customer management

Excel add-in

Frequently asked questions

Advanced

SQL on anything

Joining data

Data transformations

Data warehouse

Materialize

Data Lineage

IP whitelisting

Feature list and Architecture

For developers

Low-code Python (data apps)

Publish APIs

Incoming webhooks

Peliqan REST API

Whitelabel & Embedding

Interactive apps (Streamlit)

Alerting & messaging

Reference


Popular data pipelines

Send alert to MS Teams

Generate Union Query

Slow changing dimensions (history tables)

Handling deleted rows

Templates by topic

Data transformations

Data Visualization (Streamlit)

Interacting with SaaS APIs

Data sync & Reverse ETL

Data enrichment

Predictions, Machine Learning templates

Data quality, monitoring & contracts

Reporting

Contact support

Need help ? We are here to help you !

Contact support


Guides per connector

Airtable - Getting started in Peliqan

AWS S3 - Getting started in Peliqan

BambooHR - Getting Started in Peliqan

Billit Invoicing - Getting started in Peliqan

CareerPro - Getting started in Peliqan

CreditSafe - Getting started in Peliqan

Dropbox - Getting started in Peliqan

Exact Online - Getting started in Peliqan

FileMaker - Getting started in Peliqan

Fortnox - Getting started in Peliqan

Github - Getting started in Peliqan

Google Analytics - Getting started in Peliqan

Google Calendar - Getting started in Peliqan

Google Docs - Getting started in Peliqan

Google Sheets - Getting started in Peliqan

Hubspot - Getting started in Peliqan

ionBIZ - Getting started in Peliqan

Lighthouse Channel Manager (Cubilis)

LightSpeed Retail R-Series - Getting started in Peliqan

Linkedin Ads - Getting started in Peliqan

Microsoft Dynamics 365 Business Central - Getting started in Peliqan

Microsoft Dynamics 365 Project Operations - Getting started in Peliqan

Microsoft Excel 365 - Getting started in Peliqan

Microsoft Sharepoint - Getting started in Peliqan

Microsoft Teams - Getting started in Peliqan

Microsoft Outlook - Getting started in Peliqan

Microsoft Outlook Calendar - Getting started in Peliqan

Monday - Getting started in peliqan

MongoDB - Getting started in Peliqan

Notion - Getting started in Peliqan

Odoo - Getting started in Peliqan

Pipedrive - Getting started in Peliqan

Postgres - Getting started in Peliqan

Postmark - Getting started in Peliqan