Configuring and Deleting Databases¶

To view the current list of databases of the Virtual DataPort server, click the menu Administration > Database management.

List of existing Virtual DataPort databases¶

These are the options available for each database:

• Click Edit to:

  • Change the description of the database.

  • Enable or disable the Unicode support of the database.

  • Enable or disable the cost-based optimization feature. See more about this feature in the section Cost-Based Optimization.

  • Enable or disable the simplification of queries. See more about this feature in the section Automatic Simplification of Queries.

  • Restrict Kerberos and OAuth authentication for this database for clients (see Creating Databases).

  • Change the “Authentication type” of the database to “Normal” or “LDAP” (see the section Creating Databases or more information about authentication types).

• Click Delete to delete the database. Take into account some restrictions when trying to delete a database:

  • Only administrators (or standard users with the serveradmin role) can drop databases. Standard users with admin rights over a particular database cannot drop the database.

  • No one can drop the “admin” database.

  • Users cannot drop a database while connected to the database.

  • Users cannot drop a database if it contains the VDP Server’s cache data source or the cache data source configured for a particular database.

  • Users cannot drop a database if it is referenced by a Global Security Policy.

  Important

  When a database is deleted, all its elements are deleted as well: data sources, views, etc. The tables in the underlying databases will not be deleted nor the tables created with the remote tables feature.

• The buttons Memory Usage and Cache open the dialogs to change the memory usage and swapping policies (see section Configuring the Memory Usage and Swapping Policy) and cache settings (see section Configuring the Cache), respectively, for the selected database.

  In both dialogs, if the toggle Default Configuration is on, Virtual DataPort will use the settings defined in Server configuration. If it is off, the settings of this database override the global settings.

• The button Credentials vault allows configuring the vault for a specific database.

  If default configuration is not used there are three options:

  • Off: This database will not retrieve secrets from vault.

  • Customized global settings (Deprecated): VDP allows override server configuration for Hashicorp and CyberArk. If the administrator configured Virtual DataPort to use the HashiCorp Vault, you can specify the namespace used for this database. If the administrator configured Virtual DataPort to use the CyberArk Vault you can specify the applicationId and the Client Certificate used for this database.

  • New provider: This database use a vault configuration defined in this dialog. The configuration for the vault is the same that defined in Credentials Vault. Note that if configuration use an agent, agent configuration is shared between databases and VDP server.

Using vault for a database¶

• Click Export to export the metadata of the database to a VQL file, so that it can be easily recreated in another Virtual DataPort installation.

  Neither the users nor its access rights for the database are included in the export process. The database creation statement is not included either.

  To export all the metadata of the server instead of just one database, click the menu File > Export (see page Exporting and Importing the Server Metadata).