Connect to OceanBase Cloud by using Client ODC

OceanBase Developer Center (ODC) can connect to Oracle-compatible tenants of OceanBase Cloud. This topic describes the prerequisites and connection procedure.

Prerequisites

• You have installed Client ODC. For more information, see Install Client ODC.

• You have obtained the connection string of the target Oracle-compatible tenant in an OceanBase Cloud instance. For more information, see Obtain the connection string.

Procedure

1. Open Client ODC. Click the plus (+) sign and select OceanBase Oracle Compatible.

2. In the Create Data Source panel, specify the following information based on the obtained connection string mentioned in the "Prerequisites" section.

   Parameter	Description
   Intelligent Parsing (optional)	You can paste the connection string to the field. ODC automatically identifies the string and populates the corresponding fields.
   Endpoint	Host IP/Domain Name: the IP address or domain name of the server where the target database is located. Port: the port number of the server where the target database is located.
   Database Account	Database User Name: an account created in the tenant. In the MySQL compatible mode, this account must have the permission to access the default database. Database Password: the password of the account created in the tenant. You can click Test Connection to test whether you can connect to the target database. Note An error will be returned if the configurations such as the username, password, or network settings are invalid. You can connect only to a database in the current tenant. Otherwise, an error indicating test failure will be returned. Before you save the configurations, you can click Test Connection to test the database connection. If the database username and password are correct, the system returns a message indicating that the connection succeeded. In ODC V4.0.0 and later, you can save the connection without setting the database account and password.
   Environment	The type of the environment. Valid values: dev (development), sit (system integration test), and prod (production).

3. Click OK in the lower-right corner of the panel. In the dialog box that appears, enter a data source name.

   Note

   Before you save the configurations, you can click Test Connection to test the database connection. If the database username and password are correct, the system returns a message indicating that the connection succeeded.