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

‍

Here’s a step-by-step guide to setup a data warehouse, connecting your SaaS business applications, and start using Peliqan to activate your data:

1. Click on Add Connection (under Connect) to add a data source.
2. Let's start by Adding a new connection; Peliqan offers more than 100 connectors to suit your exact needs.
3. Choose a connection name and fill in your credentials.
4. Data will start syncing and you will see all the tables from your Odoo account. You can explore your data in a rich spreadsheet.
5. Add your views to transform data, and choose From SQL to a new SQL query.
6. Write your SQL queries and combine data from all your sources.
7. If your data sits across multiple data-warehouses, you can combine them by using Peliqan’s federated query engine (Trino).
8. Get help from Peliqan’s AI assistant when writing SQL queries.
9. Activate your data by building data apps; click the Build icon on the left.
10. Create a new data app from one of the templates.
11. Customize your app in a visual workflow.
12. Click Save and Run to test your app.
13. Hit Save & Publish to share your data app with your team members.
14. You can Schedule apps that need to run in the background.
15. Apps can be shared as API endpoints to share selected data with partners.
16. Go to the Peliqan Marketplace to install various data tools like Metabase (BI) in one click!