What is ODC?

OceanBase Developer Center (ODC) is a GUI-based database development tool. It is also a collaborative management platform for data development, production, and changes. ODC is provided in two forms: client ODC and web ODC. Client ODC focuses on database development. It is lightweight and easy to deploy on Windows, macOS, and Linux. As for web ODC, in addition to database development, web ODC also provides collaborative management features to ensure the security, compliance, and efficiency of database changes.

You can use ODC in the following ways:

• Download the client ODC from the OceanBase Download Center.
• Log in to the Web ODC.

ODC console

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	Projects	You can create projects as the project admin 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	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.
6	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.
7	Settings	On the homepage of ODC, click Settings in the lower-left corner to set the database, editor, appearance, and account.
8	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.
9	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.