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 conceptsETL: Connect to dataWorking with data in the grid viewConnect your BI or DB toolMarket place: install Metabase etc.Multi-customer managementExcel add-in

Advanced

SQL on anythingJoining dataData transformationsData warehouseMaterializeData LineageIP whitelisting

For developers

Low-code Python (data apps)Publish APIsIncoming webhooksPeliqan REST APIWhitelabel & Embedding

Useful Shortcuts:

Interactive apps (Streamlit)Alerting & messagingReference

Data app template highlights

Send alert to MS TeamsSlow changing dimensions (history tables)Generate Union Query

Data app templates by topic

Data transformationsData Visualization (Streamlit)Interactive apps (Streamlit)Interacting with SaaS APIsData sync & Reverse ETLData enrichmentPredictions, Machine Learning templatesData quality, monitoring & contractsReporting

Product information

Feature list, Roadmap and ArchitectureFrequently asked questions

Contact support

Need help ? We are here to help you !

Contact support

Guides per connector

Airtable - Getting started in PeliqanAWS S3 - Getting started in PeliqanBambooHR - Getting Started in PeliqanCareerPro - Getting started in PeliqanDropbox - Getting started in PeliqanExact Online - Getting started in PeliqanFileMaker - Getting started in PeliqanFortnox - Getting started in PeliqanGithub - Getting started in PeliqanGoogle Analytics - Getting started in PeliqanGoogle Docs - Getting started in PeliqanGoogle Sheets - Getting started in PeliqanHubspot - Getting started in PeliqanionBIZ - Getting started in PeliqanLightSpeed Retail R-Series - Getting started in Peliqan Microsoft Dynamics 365 Business Central - Getting started in PeliqanMicrosoft Dynamics 365 Project Operations - Getting started in Peliqan Microsoft Excel 365 - Getting started in PeliqanMicrosoft Sharepoint - Getting started in PeliqanMicrosoft Teams - Getting started in PeliqanMicrosoft Outlook - Getting started in PeliqanMongoDB - Getting started in PeliqanNotion - Getting started in PeliqanOdoo - Getting started in PeliqanPipedrive - Getting started in PeliqanPostgres - Getting started in PeliqanPostmark - Getting started in PeliqanSalesforce - Getting started in PeliqanSimplicate - Getting Started in PeliqanSFTP - Getting started in PeliqanShiji ReviewPro - Getting Started in PeliqanSlack - Getting started in PeliqanSupabase - Getting started in PeliqanSybase (SAP SQL Anywhere) - Getting started in PeliqanTeamleader Focus - Getting started in PeliqanTeamleader Orbit - Getting started in Peliqan Visma Bouwsoft - Getting started in PeliqanVisma.net - Getting started in PeliqanWeclapp - Getting started in PeliqanWhatsapp - Getting started in Peliqan