ODC console

Project collaboration window

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

No.	Window	Description
1	Workspace	Click the workspace to switch to Team Workspace or Individual Workspace. Team Workspace: supports multiple projects and members and provides unified management rules to ensure efficient collaboration within the team and secure change of data sources. Individual Workspace: allows you to flexibly manage your personal data sources without configuring complex rules.
2	Projects	You can create a project, configure project members, and add databases to a project as the project administrator. A project comprises four resource items: database, ticket, member, and sensitive data. A project is the minimum collaboration unit, a ticket is the most common collaboration method used in a project, and the Sensitive Data page is the management center for desensitization strategies in a project.
3	Tickets	You can submit a ticket to perform a data export, data import, data mocking, database change, lock-free schema change, SQL plan, or data archiving task, and approve the created task.
4	Data Sources	ODC allows you to connect to OceanBase Database and MySQL Database to edit and manage data sources, including database objects and resources.
5	Command-line Window	In a command-line window, you can directly execute SQL or PL statements and view the execution results in real time. You can also run the SOURCE command to run files uploaded to the server.
6	User Permissions	You can create a user, edit a user, and grant resource management and system operation permissions based on roles as the system administrator of ODC. You can also configure automatic authorization rules to automatically grant specific roles or permissions to users meeting the specified conditions.
7	Security Specifications	On the Security Specifications page, you can perform the following operations: Manage SQL check specifications and window specifications for different environments. Configure risk identification rules and configure corresponding approval processes for different risky operations. View the built-in desensitization algorithms. View the operation records of all users.
8	External Integration	On the External Integration tab, you can configure approval integration, SQL review integration, and single sign-on (SSO) integration. Approval Integration: You can integrate an external approval system with ODC for process approval. SQL Approval Integration: You can integrate an external review system with ODC for SQL interception check. SSO Integration: You can integrate an external account system with ODC for logon to ODC through SSO by using OpenID Connect (OIDC) or Open Authorization (OAuth) 2.0.
9	Help	On the homepage of ODC, click Help in the lower-left corner to view tutorials for common ODC operations, new features of the current version, and FAQ. You can click the required document. A page appears, displaying the introduction and link to the document. You can select Documentation to view the help information.
10	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, language, or theme, edit your personal settings, view the operation records, and log off.

SQL development window

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

No.	Window	Description
1	Workspace	Click the workspace to switch to Team Workspace or Individual Workspace. Team Workspace: supports multiple projects and members and provides unified management rules to ensure efficient collaboration within the team and secure change of data sources. Individual Workspace: allows you to flexibly manage your personal data sources without configuring complex rules.
2	Database	You can create and manage database objects in a database of a data source or project.
3	Script	You can save edited scripts in the SQL window or anonymous block window and manage saved scripts on the Script tab. You can switch to the Snippets tab to manage snippets.
4	Tickets	You can submit a ticket to perform a data export, data import, data mocking, database change, lock-free schema change, SQL plan, or data archiving task, and approve the created task.
5	Database O&M	Session Management: allows you to manage all sessions in the data source. Global Variables: allows you to query and modify all variables of databases connecting to the current data source. Recycle Bin: allows you to query and restore deleted database objects.
6	SQL window	SQL editing section: You can write and execute SQL statements. Execution Records tab: You can view the execution records of SQL statements in the current connection process. Logs tab: You can view the execution records in the current SQL window. Result 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.