ODC console

Project collaboration window

Log on 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	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.
3	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.
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	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.
7	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.
8	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.
9	Settings	On the homepage of ODC, click Settings in the lower-left corner to set the database, editor, appearance, and account.
10	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.
11	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 on 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 lock-free 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.