Multiple Virtual Databases Support

The Data Virtuality Platform supports using several virtual databases in addition to the primary datavirtuality database. These secondary VDBs support the following features:

creating virtual schemas;
creating views;
creating stored procedures;
adding data sources;
managing users (including instances using LDAP authentication).

Speaking of managing users, users and user roles need to be created and fine-tuned for each virtual database separately (please refer to Access Control for more information). The only exception is the superadmin-role group: users with the role superadmin have full permissions for all virtual databases.

As of now, the Data Virtuality Platform does not support the following features for secondary VDBs:

Recommendations, recommended optimizations, etc.;
Jobs;
Visual web-based performance monitoring;
SMTP configuration;
Changing default options;
Changing CLI templates;
Deploying and undeploying modular connectors;
Access to Data Virtuality Web;
Git integration;
REST API.

Creating a Virtual Database

To create a virtual database, you can use this statement:

SQL

CALL "SYSADMIN_VDB.createVdb"("name" => 'string_name');;

Deleting a Virtual Database

A virtual database can be deleted by its ID with the following statement (you can look up IDs of all existing virtual databases in the SYSADMIN_VDB.VirtualDatabases table):

SQL

CALL "SYSADMIN_VDB.dropVdb"("id" => biginteger_id);;

Please be aware that this operation cannot be undone, and a dropped virtual database is gone for good.

Concurrent Query Limits

There are no special limits for multiple virtual databases: the global concurrency limitations are applied.

Backing Up Secondary Virtual Databases

Currently, jobs, including backup jobs, are not supported for secondary virtual databases. To create a backup for any of them, you can use the Data Virtuality Exporter (please note that you need to be logged into the virtual database you want to back up).

Creating a Virtual Database

Deleting a Virtual Database

Concurrent Query Limits

Backing Up Secondary Virtual Databases

See Also