Configuring a Customized Driver for DBeaver to Connect to GaussDB Databases
GaussDB databases can be connected through the custom driver configured on DBeaver.
Version Requirements
3.3.52.0 or later.
Network Requirements
- PC to bastion host: 18000
- Port for connections between the bastion host and GaussDB databases: The default port is 8000.
Configuration on the Bastion Host
- Log in to the web page of the bastion host, click Download Center in the upper right corner, and download SSOTool Windows.
Figure 1 Downloading the login tool
- Choose and add a GaussDB protocol host.
- Then, choose to associate the user with the access permission for the GaussDB host.
Configuring the DBeaver Client
- Start the DBeaver client, choose New.
, and click
Table 1 Parameter descriptions Parameter
Description
Driver Name
Set a name that is easy to identify, for example, GaussDB.
Driver Type
Select Generic.
Class Name
org.postgresql.Driver
URL Template
jdbc:postgresql://{host}[:{port}]/[{database}]
Default Port
Port of the database to be connected. Default port: 8000
- Click the Libraries tab, click Add File, and add gsjdbc4.jar.
Download the gsjdbc4.jar file. The driver package file is compatible with the 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.
- Click OK, edit the corresponding driver again, and click Find Class.
- Open the DBeaver client and directly connect to the target GaussDB database. Select the driver file created in 1.
- Click OK. After the connection is successful, open the C:\sso\SsoTool\DBeaver\General\.DBeaver\data-sources.json file, verify that the corresponding connection is generated, and open the C:\sso\SsoTool\ssotool.conf file.
Add the C:\sso\SsoTool\DBeaver\General\.DBeaver\data-sources.json parameter to the C:\sso\SsoTool\ssotool.conf file, uncomment the corresponding line in the ssotool.conf file, and save the file.
- Choose and access the host using the corresponding protocol.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot