Installing database GUIs on your Virtual Desktop

PostgreSQL Graphical User Interface (GUI) tools allow to easily interact with the workspace database from the VM. These graphical database management tools help users manipulate, visualize, and manage the data stored in the database.

DBeaver GUI

Installing database GUIs

1. Download drivers

Database drivers are needed to connect the GUIs with the workspace database. A driver is a computer program that will connect a generic interface to a specific database implementation.

Most database GUIs require a JDBC (Java Database Connectivity) driver. Please download the PostgreSQL JDBC driver from here.

2. Download GUI

DBeaver and DBVisualizer are examples of database GUIs that you can install in your workspace in either a Windows or Linux VM in your workspace.

DBVisualizer GUI

First, download the installation files of a preferred database GUI for your VM operating system on your local computer:

Then, upload them to the workspace together with the previously downloaded JDBC driver.

3. Install GUI

If you are working in a Windows VM, simply run the installation file and follow the installation instructions.

To run the installation in a Linux VM, move to the same folder as the installation file and run:

sudo dpkg -i <installation_file>.deb

Once installed, you can start it by typing dbeaver or dbvis for DBeaver and DBVisualizer, respectively.

4. Configure the database connection

The credentials of the database are needed to connect the GUI with the workspace database. For security reasons, please contact the Service Desk to finish the configuration.

Working with database GUIs

Once the connection is set up, you can explore the workspace database using the database navigator found in the left-hand sidebar in both of the GUIs.

You can also easily view the table data, create and run SQL queries, and view Entity-Relationship diagrams using these tools. To find out how to do this, please visit the DBeaver and DBVisualizer documentation sites.

Updated on July 26, 2021

Was this article helpful?

Related Articles

Not the solution you were looking for?
Click the link below to submit a support ticket