All-in-one data platform

Zero setup, zero maintenance, it’s magic

Peliqan reinvented how data teams, developers and business users collaborate. Data teams can now safely enable business users to connect to any data source, enjoy rich data editing in virtual copies, apply visual transformations and combine data across sources using magical joins.

Data pipelines ETL/ELT

Connect to any data source in a few clicks and start exploring your data. An ETL data pipeline is automatically created and requires zero maintenance.

Peliqan provides real-time access to any source thanks to its federated query engine.

 

Model and Transform your data

Easily transform data to make it ready for ad hoc analysis or downstream usage. Data can be wrangled, prepped, de-duped and cleaned and unified using 3 types of transformations: formulas, SQL models and low-code Python.

Built-in data warehouse

Peliqan comes with a built-in data warehouse.

Sync data from SaaS business applications into your data warehouse with a few clicks, the “Load” in ETL.

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.

Spreadsheet BI for business users

Business users can explore and edit data in a rich spreadsheet editor. Add your own rows and columns with notes, new data and apply formulas similar to Excel or Google Sheets.

SQL on anything for power users

Power users can write SQL queries to combine data from multiple sources. You can join data from disparate data sources and share the resulting view with business users.

Business users consume the view in Peliqan’s rich data editing spreadsheet editor, and they can work on the data in a new virtual copy that magically stays up to date with the underlying query and sources.

Thanks to Peliqan’s “SQL on anything” approach, you can even access data from SaaS business applications in real-time by writing SELECT queries.

Need to combine data without a joined key ? No problem, Peliqan’s Magical Joins allow you to apply fuzzy matching in order to freely combine data sets.

Low-code scripting for developers

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 & Data catalog

Data lineage shows where data comes from (provenance) and where data is used in other queries, tables and low-code scripts.

Lineage is essential to find the cause of a data error, as well as to understand which changes will impact others.

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.

Ready to get instant access to all your company data ?

Get the superpowers of a data engineer, start now !