Configuring the Connection Between DBeaver and GaussDB

Version Requirements

3.3.50.0 or later

Network Requirements

• Port for connections between your PC and the bastion host: 18000
• Port for connections between the bastion host and GaussDB databases: The default port is 8000.

Configuring the DBeaver Client

1. Use DBeaver to directly connect to GaussDB databases. Select PostgreSQL. During the connection, the system prompts you to download the driver. Download the driver and connect to the database.
2. Configure the DBeaver driver and obtain the GaussDB driver package. The driver package version is the same as the GaussDB database version.
   • Download the 3.X driver package.
   • Download the 2.X driver package.

   Decompress the package, go to the GaussDB_driver\GaussDB_driver\Centralized\Euler2.5_x86_64 directory, and decompress the JDBC package.

3. Start the DBeaver client, choose Database > Driver Manager > PostgreSQL, and click Edit. Then, select Libraries, delete the original driver from the library, and import gsjdbc4.jar.
4. After the import, click OK. Edit the postgresql driver again and click Find Class.
5. Enable SSL for GaussDB and disable SSL in DBeaver.

   Start the DBeaver client, choose Database > Driver Manager > PostgreSQL, click Edit, select Connection properties, and add the sslmode property. Set its value to disable.

6. Configure the workspace.

   Choose File > Switch Workspace and select C:\sso\SsoTool\DBeaver.