Overview
After you log on to OceanBase Developer Center (ODC), the ODC homepage automatically appears.
On the ODC homepage, you can view the session history, tasks, operating records, and help documentation. You can also perform the following operations on the page: managing database connections, switching the language, setting personal information, changing the password, and logging off ODC.
Manage database connections
The ODC homepage provides the Private Connections tab that shows the connections you have created, the Public Connections tab that shows the public connections that you have the permission to access, and the All Connections tab that shows all connections.
All Connections: On the All Connections tab, you can create a private connection, apply for the permission on a public connection, and search for, filter, sort, and refresh connections.
Private Connections: On the Private Connections tab, you can create a private connection, apply for the permission on a public connection, and search for, filter, sort, and refresh connections. For more information, see Manage private connections.
Public Connections: On the Public Connections tab, you can create a private connection, apply for the permission on a public connection, and search for, filter, sort, and refresh connections. For more information, see Manage public connections.
View session history
On the ODC homepage, you can click History in the left-side navigation pane to go to the session history page.
The page shows a list that has the following columns.
Column |
Description |
|---|---|
| Connection Name | The name of the connection you accessed. |
| Database/Schema Name | The name of the database or schema that you accessed by using the connection. |
| Recently Opened At | The time when you last accessed the connection. |
| SQL/PL Window | The workspace window that you created when you accessed the connection. Move the pointer to a window name, and the script that you edited in the window is displayed. |
| Actions | You can click Open to resume the connection in a new window. The corresponding workspace window and its content are also resumed. |
Note
By default, the historical records in the panel are stored for 48 hours. You can restore the content in an unsaved SQL window based on records in the panel.
Manage tasks
On the ODC homepage, you can click Task in the left-side navigation pane to create and view tasks. For more information, see Manage tasks.
Public resource console
As a database development platform for enterprises, ODC provides the public resource console for the ODC administrator to manage users, grant permissions, and allocate resources.
Notice
The Public Resource Console tab is displayed on the ODC homepage only when you log on as an administrator.
On the ODC homepage, click Console in the left-side navigation pane to go to the public resource management page.
The console allows you to manage users, roles, public connections, resource groups, automatic authorization rules, task processes, desensitization rules, and system settings.
You can grant users the permissions to use public and private resources by roles. You can also use a resource group to batch grant or revoke the permissions for multiple public connections. For more information, see Manage public resources.
Switch the theme
In the lower-left corner of the ODC homepage, choose Me > Theme to switch the theme to Default Theme or Dark Theme.
Switch the language
In the lower-left corner of the ODC logon page or ODC homepage, choose Me > Language to view the display language of ODC. The default language is Simplified Chinese. You can click the language option to switch the display language. ODC supports English, Simplified Chinese, and Traditional Chinese.
Personal settings
In the lower-left corner of the ODC homepage, choose Me > Preferences. The Edit Personal Settings panel appears.
In the panel, you can globally modify the settings of the customizable features. You can also select a connection and configure these features in the connection. The configurations take effect on the current connection. The priority of personal settings is lower than that of settings you configured for each connection. In addition, the personal settings are persisted.
Your modifications to fields in the Edit Personal Settings panel take global effect.
Parameter |
Description |
|---|---|
| Session Mode for SQL Window | The session mode of the SQL window. |
| Delimiter Settings | The default delimiter for executing PL/SQL statements in the SQL window. Five types of delimiters are supported: semi-colons (;), slashes (/), double slashes (//), dollar signs ($), and double dollar signs ($$). |
| Transaction Commit Mode in Oracle Mode | The default transaction commit mode in Oracle mode. Valid values: Manual and Automatic |
| Transaction Commit Mode in MySQL Mode | The default transaction commit mode in MySQL mode. Valid values: Manual and Automatic |
| Maximum Number of Rows in Result Set | The default number of rows returned for an SQL statement executed in the SQL window. |
| Type of Statements Generated by Dragging and Dropping Object | The default type of statements generated when you drag and drop table or view objects. |
Change the password
In the lower-left corner of the ODC homepage, choose Me > Change Password. The Change Password dialog box appears. For more information, see Change the password.
Log off
In the lower-left corner of the ODC homepage, choose Me > Log Off to return to the ODC logon page.
Help
In the lower-left corner of the ODC homepage, you can click Help to view tutorial documents of some common operations in ODC, new features in the current version, and FAQ.
Click the document you want to view on this tab. The introduction and link to the document are displayed in a dialog box. You can click the link to view the document.