Skip to main content
Before you can build dashboards or run reports, you need to connect at least one data source. Storm Analytics supports databases, data warehouses, and SaaS tools through a unified connection interface.

​
Supported sources

  • PostgreSQL
  • MySQL / MariaDB
  • Microsoft SQL Server
  • SQLite (file upload)
  • Oracle Database

​
Connection settings

When you add a new source, fill in the following fields:
FieldDescription
Source nameA human-readable label used in the UI.
Source typeSelect from the supported list above.
Host / URLHostname or endpoint URL for the source.
PortDefault ports are pre-filled for common sources.
Database / SchemaThe specific database or schema to connect to.
Username / API keyAuthentication credential for the source.
Password / SecretStored encrypted and never displayed after saving.
SSL modeRequire, prefer, or disable SSL. Require SSL for production sources.
Click Test connection to validate credentials before saving.

​
Sync frequency

Choose how often Storm Analytics fetches data from your source:
  • Real-time — Queries run live against the source on every dashboard load.
  • Scheduled sync — Data is fetched on a fixed interval (15 min, 1 hour, or daily) and cached.
  • Manual — Refresh only when you click Sync now.
Scheduled sync intervals depend on your plan. Free plans support daily sync only.