Connect to OceanBase Database in Oracle mode by using DBeaver

DBeaver is a general-purpose database management tool that supports connecting to various databases, including OceanBase Database in Oracle mode. This topic describes how to connect to OceanBase Database in Oracle mode by using DBeaver.

Prerequisites

• You have installed DBeaver Community or Enterprise Edition (We recommend that you use the latest version).
• You have obtained the connection information of OceanBase Database, including:
  • The address and port of the database server
  • The tenant name
  • The username and password

Download OceanBase JDBC driver

1. Go to OceanBase Download Center and download OceanBase Connector/J from the Drivers and Middleware category.

2. Save the JAR file to a local directory, for example: /path/to/oceanbase-client.jar.

Create a new driver

1. Open DBeaver and choose Database > Driver Manager.

2. Click the Create button to create a new driver.

3. On the Schema tab:

   • Click Add Folder and select the OceanBase JDBC driver JAR file that you downloaded.
   • Click OK to save the driver settings.

Create a new connection

1. Click Database > Create Database Connection.

2. On the database selection page, select the OceanBase Oracle driver and click Next.

3. On the connection settings page, configure the following settings:

   Parameter	Description	Example
   Host	The address of the OceanBase server.	127.0.0.1
   Port	The port of the database. The default value is 2881.	2881
   Username	The username of the database.	user@tenant
   Password	The password of the database.	********

4. Click Test Connection to verify the connection.

Manage OceanBase Database by using DBeaver

After the connection is established, you can use the GUI of DBeaver to perform the following operations:

• Browse database objects such as tables, views, and stored procedures.
• Execute SQL queries.
• Import and export data.
• Manage database users and privileges.
• Monitor database performance.