How to Use Peliqan to Centralize Your Business Data in a Data Warehouse

Quick summary

Peliqan is an all-in-one data platform that lets you connect SaaS sources, query and transform data using SQL or low-code Python, and build and share data apps — all from a single interface. With over 100 pre-built connectors and a built-in data warehouse, teams can centralize, automate, and distribute business data without stitching together separate tools.

Steps

1. From the dashboard, click the Add connection button under the Connect section to begin linking a data source.
2. Browse and select from over 100 available connectors to add a new connection that fits your needs.
3. Enter a connection name and fill in your credentials to authenticate the data source.
4. Once connected, view all data fields from your source (e.g., Odoo) and visualize them in grid view.
5. Create a new table by selecting From SQL to generate tables using custom SQL queries.
6. Write your own SQL queries to pull and transform data from your connected sources.
7. Use Peliqan's federated query engine (Trino) to combine data across multiple data warehouses in a single query.
8. Open the Peliqan AI assistant to generate SQL queries and low-code Python code automatically.
9. Type a prompt into the AI engine to get instant query suggestions and code help.
10. Click the rocketship icon in the left sidebar to navigate to the data apps builder.
11. Create a new data app by selecting from existing templates.
12. Build your workflow and visualize how data moves across connected systems.
13. Click Save & Run to test your data app and verify it executes correctly.
14. Click Save & Publish to share your finished data app with teammates.
15. Set a Schedule to define intervals at which your script runs automatically in the background.
16. Expose your app as an API endpoint to share selected data securely with external partners.
17. Visit the Marketplace to install open-source data tools such as Metabase (BI) with a single click.