Database Management
The Database Management section provides an overview of all configured connections to instances of the VC Database or the 3D City Database. You can use the search function to quickly find existing connections. The menu also allows you to add new database connections or edit and delete existing ones.
Search Function
The search field at the top of the Database Management section allows you to filter existing database connections by name, type, version, database, host or creation date. You can also enter multiple search terms at the same time to further refine the results.
Add, edit and delete Database Connections
To create a new database connection, click the plus icon on the right side of the Database Management header. A form will open, showing the fields that need to be filled in.
Before you can save the connection, you must test and establish the connection to the database by clicking the corresponding button. If the connection is successful, additional database information will be displayed (e.g., 3D City Database version, database management system, coordinate reference system, etc.).
Once all required information is entered and the connection has been verified, click Add to save the new connection. After saving, the database connection appears in the overview list.
| Option | Description |
|---|---|
Name |
Name of the database connection. This name is used within the project to uniquely reference this connection. |
Version |
Version of the VC Database. |
Database Type |
Currently, Oracle and PostGIS are supported as database types. |
Username |
Name of the database user, e.g., vcdb_user. |
Password |
Password of the database user. You can click the eye icon to show or hide the entered password. |
Host |
Name or IP address of the server where Oracle/PostGIS is installed, e.g., myserver.de. |
Port |
The port number of the database server. Ususally, Oracle uses port 1521 and PostGIS uses port 5432. |
Database (sid) |
Name of the Oracle/PostGIS database, e.g., 3dgeodata. |
Schema |
Name of the database schema. If no value is provided, the system uses the default schema, for example the "citydb" schema in PostGIS. |
All existing database connections can be edited. When you click a connection, its details are displayed and all fields can be modified. To apply the changes, click the Save button.
To delete a database connection, click the trash can icon. Please note that deleted connections are permanently removed and cannot be restored.