SQL Databases
Qvista supports the most widely used relational database engines across on-premises and cloud-hosted environments:MySQL
A widely used open-source database ideal for web applications and transactional systems.
PostgreSQL
An advanced open-source relational database known for its extensibility, performance, and standards compliance.
Microsoft SQL Server
A reliable, scalable enterprise solution supporting both on-premises and cloud-based SQL Server instances.
Oracle Database
High-performance database management designed for critical, large-scale business workloads.
SQLite
A lightweight, self-contained engine well-suited for embedded systems and local development environments.
Key Features for SQL Connections
- Real-time data extraction and transformation — fetch the latest records on every query with no stale caches
- Encrypted data transfer — all connections use SSL/TLS encryption to protect data in transit
- Complex query support — run multi-table joins, stored procedures, views, and parameterized T-SQL or ANSI SQL queries directly from Qvista
- Change data capture — track incremental updates in your database so dashboards reflect changes as they happen
- Automated scheduling — set extraction jobs to run at defined intervals, keeping downstream reports and dashboards fresh without manual intervention
NoSQL Databases
Qvista also integrates with leading NoSQL platforms, making it straightforward to work with unstructured and semi-structured data alongside your relational sources:MongoDB
A document-based database optimized for high-volume storage and flexible JSON schemas.
Cassandra
A distributed database designed for high availability, linear scalability, and fault tolerance.
Redis
An in-memory data structure store ideal for caching, real-time analytics, and session management.
Elasticsearch
A distributed search and analytics engine for fast, scalable full-text search and log analysis.
CouchDB
A schema-free database using a JSON document model, well-suited for dynamic and offline-first applications.
Key Features for NoSQL Connections
- Native JSON and document support — query key-value, document, and wide-column data without conversion overhead
- High-performance handling of distributed datasets — Qvista is optimized for the large-scale, distributed nature of NoSQL architectures
- Real-time indexing and search — leverage Elasticsearch and Redis capabilities for fast, live data retrieval
Connect a SQL Database
Follow these steps to add a SQL database as a data source in Qvista:Select Your Database Type
Choose your database engine from the list — for example, PostgreSQL or MySQL — and click Configure.
Enter Connection Details
Provide your host address, port number, database name, username, and password. For cloud-hosted instances, paste the full connection string if available.
Configure SSL / TLS Encryption
Toggle Require Encrypted Connection to enable SSL/TLS. Upload your CA certificate if your database server requires mutual TLS authentication.
Test the Connection
Click Test Connection. Qvista verifies credentials and network access. A green checkmark confirms a successful connection.
Set Access Controls
Assign the connection to one or more workspace roles so only authorized team members can query this source.
All database connections in Qvista use SSL/TLS encryption by default. Qvista also supports role-based access controls so you can restrict which users and workspaces have permission to query a given database. For Microsoft SQL Server, parameterized queries are enforced automatically to prevent SQL injection.