Peliqan brings ETL pipelines, data transformations and reverse ETL together in one integrated platform. Connect your favorite BI tool and activate your data with SQL and low-code Python.
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.
Peliqan also provides real-time access to any external database thanks to its federated query engine.
Choose your favourite data warehouse:
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.
Peliqan comes with a built-in data warehouse, or you can use Snowflake or Bigquery.
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.
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.
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 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.
Set up reverse ETL to keep data in sync between your business applications.
Configure any type of data sync: 1-way, 2-way etc.
Optionally customize your writeback scenarios with low-code Python scripts.
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’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.
We’re even adding AI assisted coding to our low-code Python editor!
Publish API endpoints and link them to your code. Publish data products, share data and expose ML models through API endpoints.
Consume incoming webhooks from any source. Incoming webhook events are queued in a table and can easily be queried or processed in your Python code.
Choose best of class tools in Peliqan’s market place and deploy them with a single click. Start using tools such as Metabase, Jupyter notebooks, Apache Airflow and Apache Superset within your Peliqan environment.
