Connect to an OceanBase database using ODC
You can manage and maintain OceanBase databases using OceanBase Developer Center (ODC). This topic describes how to add a new database connection in ODC and log on to the database.
Prerequisites
You have the account credentials and connection details for the OceanBase database.
Procedure
Log on to the OceanBase console.
In the navigation pane on the left, click Data Development to open the ODC home page.
On the ODC home page, click All Connections > New Personal Connection.
In the New Personal Connection dialog box, configure the following settings:
Connection Instance: Select the cluster and tenant instances that you want to connect to.
Database Username: Select the username used to log on to the tenant instance.
Database Password: Enter the password for the specified database user.
Save Password: This option is selected by default. If you clear this check box, you must re-enter the password each time you access or test the connection.
Default Database/Schema (Optional): The database to use by default when you log on to the tenant.
Click Test Connection. A
icon appears if the credentials are valid.After the connection test succeeds, click the Save button.
In the Enter Connection Name dialog box, enter a name for the connection and click OK.
After the connection is created, click the connection name on the All Connections tab. ODC opens the database for the connection.