Database Integrations
Vantage supports 7 database adapters for connecting to your existing data stores. Once connected, databases can be used as data sources for dashboard tiles and workflow nodes.
Supported Databases
| Database | Type | Default Port |
|---|---|---|
| PostgreSQL | Relational | 5432 |
| MySQL | Relational | 3306 |
| Microsoft SQL Server | Relational | 1433 |
| MongoDB | Document/NoSQL | 27017 |
| Amazon DynamoDB | Key-Value | N/A (AWS API) |
| Google Firestore | Document/NoSQL | N/A (GCP API) |
| Redis | Key-Value/Cache | 6379 |
Connection Setup
Relational Databases (PostgreSQL, MySQL, MSSQL)
- Go to Integrations page.
- Find your database type.
- Click "Connect".
- Enter:
- Host — Server hostname or IP
- Port — Server port
- Database — Database name
- Username — Database user
- Password — Database password
- Click "Save".
Cloud Databases (DynamoDB, Firestore)
- DynamoDB — Requires AWS Access Key ID, Secret Access Key, and Region
- Firestore — Requires Google Cloud service account credentials
Redis
- Host, Port, and optional Auth Token
Workflow Nodes
| Node | Purpose |
|---|---|
| Database Query | Execute read queries (SELECT) |
| Database Write | Execute write operations (INSERT, UPDATE, DELETE) |
| Query Runner | Execute custom queries with parameters |
For More Details
See individual database integration pages in the Platform Integrations reference: