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