OceanBase Developer Center

V4.4.3

Download PDF

ODC console

Last Updated:2026-09-03 09:11:30

Project collaboration window

Log in to the OceanBase Developer Center (ODC) console and choose Team Workspace to go to the ODC project collaboration window.

No.	Module	Description
1	Workspace	You can click Team Workspace or Individual Workspace to switch between the two workspaces. Team Workspace: provides unified control rules for multiple projects and members to ensure efficient team collaboration and secure data source changes. Individual Workspace: allows you to flexibly manage and change data sources without configuring complex control rules.
2	Workbench	The workbench provides the following information. You can conveniently view and access the information that you need. Note Click the menu icon in the upper-right corner to customize the contents of the workbench. Quick Start: You can choose For Admins or For Developers to view different quick-start guides and the links to the corresponding operation procedures. Task Overview: The statistics of the tickets and jobs executed in the last 7 days are displayed. Recently Accessed Databases: This section shows the basic information of the databases accessed most recently. You can click the database name or project name to quickly access the specified database or project. You can also click the Import or Export button in the Actions column to open the task pop-up window. For more information about the import and export functions, see Export schema and data. Best Practices: ODC provides daily use tips and solutions for common problems. This helps you quickly get started with ODC and improves your development and O&M efficiency. About Us: This section provides the download address of the latest ODC version and the latest product updates. You can provide feedback and suggestions, or join the DingTalk group to report ODC usage problems.
3	Projects	You can create projects as the project administrator and configure members and databases for projects. A project contains four types of resources: databases, tickets, members, and sensitive data. A project is the minimum unit of collaboration. Tickets are most commonly used for collaboration in a project. Sensitive data is the subject for data desensitization strategies.
4	Tickets	You can submit a ticket to perform operations such as importing, exporting, mocking, and archiving data, modifying a database, implementing lock-free structure changes, and managing SQL plans. You can also review the created tickets.
5	Jobs	You can apply for a job to execute data archiving, data cleaning, SQL plans, and partitioning, and approve the created task processes.
6	Data Sources	ODC allows you to connect to OceanBase Database and MySQL Database to edit and manage data sources, including database objects and resources.
7	Users	You can create and edit users as the ODC system administrator and assign roles to users to grant them the permissions on resource management and system operations. You can also configure automatic authorization rules to automatically grant specific roles or permissions to users that meet the specified conditions.
8	Security	On the Security page, you can perform the following operations: Manage SQL check and window specifications for different environments. Configure risk identification rules to match approval processes for different risky operations. View built-in data desensitization algorithms. View the operation records of all users.
9	Integrations	On the Integrations page, you can configure approval integration, SQL approval integration, and login integration. Approval Integration: You can integrate an external approval system with ODC for process approval. SQL Approval Integration: You can integrate an external approval system with ODC for SQL interception check. Login Integration: You can integrate an external account system with ODC for logon to ODC through single sign-on (SSO) by using OpenID Connect (OIDC) or Open Authorization (OAuth) 2.0.
10	Settings	On the homepage of ODC, click Settings in the lower-left corner to set the database, editor, appearance, and account.
11	Help	On the homepage of ODC, click Help in the lower-left corner to view tutorials for common ODC operations and new features of the current version. You can report questions to Github or support email.
12	Me	On the homepage of ODC, you can click Me in the lower-left corner. The menu that appears provides options for you to change the password, view the operation records, and log off.

SQL development window

After you log in to a database, go to the SQL development window.

No.	Module	Description
1	Workspace	You can click Team Workspace or Individual Workspace to switch between the two workspaces. Team Workspace: provides unified control rules for multiple projects and members to ensure efficient team collaboration and secure data source changes. Individual Workspace: allows you to flexibly manage and change data sources without configuring complex control rules.
2	Databases	You can create and manage database objects in databases of the data source or project.
3	Scripts	You can save edited scripts in the SQL Window and Anonymous Block Window and manage the saved scripts on the Script tab. You can also manage snippets on the Snippets tab.
4	Tickets	You can submit a ticket to perform operations such as importing, exporting, mocking, and archiving data, modifying a database, implementing online schema changes, and managing SQL plans. You can also review the created tickets.
5	O&M Management	Session Management: You can manage all sessions of the data source. Global Variables: You can query and modify all variables of databases connected to the current data source. Recycle Bin: You can query and restore deleted database objects.
6	SQL Window	SQL editing section: You can edit and execute SQL statements in this section. Record tab: You can view the execution records of each SQL statement in the current connection. Logs tab: You can view the execution records of the current SQL window. Results tab: You can view the execution result of the current SQL statement.
7	Anonymous block window	You can compile, run, and debug PL objects and anonymous blocks.

Previous topic

Next topic