Supported sources
- Databases
- Data warehouses
- SaaS tools
- PostgreSQL
- MySQL / MariaDB
- Microsoft SQL Server
- SQLite (file upload)
- Oracle Database
Connection settings
Navigate to Analytics → Data sources → Add source and complete the following fields:
Click Test connection to validate credentials before saving. Errors include a specific reason code to help troubleshoot firewall or credential issues.
Sync frequency
After connecting a source, configure how often data is refreshed:- Real-time — Queries run live against the source on every dashboard load. Best for low-latency sources with indexed queries.
- Scheduled sync — Data is fetched on a fixed interval (15 minutes, 1 hour, 6 hours, or daily) and cached. Best for large datasets or rate-limited APIs.
- Manual — Refresh only when you click Sync now. Suitable for one-off data imports.
Scheduled sync intervals depend on your plan. Free plans support daily sync only.
