Skip to main content
Data sources are the connections between Vizdom and your data. Once connected, every dataset becomes available to the visualization builder and AI Insights. Vizdom supports direct database connections, cloud data warehouses, file uploads, and REST APIs.

​
Supported connectors

ConnectorType
PostgreSQLDatabase
MySQLDatabase
MariaDBDatabase
Microsoft SQL ServerDatabase
Google BigQueryData warehouse
SnowflakeData warehouse
Amazon RedshiftData warehouse
CSV / Excel uploadFile
REST API (JSON)API

​
Adding a data source

1

Open Data Sources settings

Go to Settings → Data Sources in the left sidebar, then click Add New.
2

Choose a connector

Select your database or service type from the connector list.
3

Enter connection credentials

Fill in the required fields for your connector. For most database connections:
  • Host — the hostname or IP address of your database server
  • Port — the port your database listens on (e.g., 5432 for PostgreSQL)
  • Database — the name of the database to connect to
  • Username and Password — credentials with read access to the relevant tables
For cloud warehouses, you may instead provide a service account key or OAuth token. See the connection examples below.
4

Test the connection

Click Test Connection. Vizdom attempts to connect and returns a success message or an error with details. Resolve any errors before saving.
5

Save the data source

Click Save. The data source is now available in the visualization builder and AI Insights.
If your database is behind a firewall, add Vizdom’s static IP addresses to your allowlist before testing the connection. You can find the current IP ranges at Settings → Data Sources → Vizdom IP Addresses.

​
Connection examples

Enter the following in the PostgreSQL connection form:
FieldExample value
Hostdb.example.com
Port5432
Databaseproduction
Usernamevizdom_readonly
Password••••••••
SSL moderequire (recommended)
Create a dedicated read-only user in PostgreSQL before connecting:
CREATE USER vizdom_readonly WITH PASSWORD 'your_password';
GRANT CONNECT ON DATABASE production TO vizdom_readonly;
GRANT USAGE ON SCHEMA public TO vizdom_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO vizdom_readonly;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT ON TABLES TO vizdom_readonly;

​
Managing existing connections

From Settings → Data Sources, you can manage all your connections:
  • Edit — update credentials, host, or port. Click the connection name to open its settings.
  • Test — re-run the connection test at any time to verify the connection is still healthy.
  • Delete — remove a connection. Any visualizations that use the deleted source will stop loading data. This action cannot be undone.

​
Data refresh settings

For each data source, you can choose how Vizdom handles query execution:
ModeDescription
Live queryEvery chart load runs a fresh query against your database. Always up to date; uses more database resources.
CachedQuery results are cached for a configurable duration (1 minute to 24 hours). Reduces database load; data may be slightly delayed.
Set the refresh mode in Settings → Data Sources → [your connection] → Query Mode. For dashboards with auto-refresh enabled, cached queries are refreshed on the dashboard’s refresh interval regardless of the cache duration.

​
Security

Vizdom protects your credentials in the following ways:
  • All credentials are encrypted at rest using AES-256. Vizdom staff cannot view your passwords or keys.
  • Vizdom never stores raw query results on its servers. Data passes through in memory during rendering and is not persisted.
  • Connections run over TLS. Enable SSL mode on your database for an additional layer of encryption in transit.
  • You can restrict database access by creating a dedicated read-only user with the minimum permissions required.

Connect your first data source

Follow a step-by-step walkthrough to connect and verify your data source.

Data Sources API

Manage data source connections programmatically via the REST API.