On the homepage of OceanBase Developer Center (ODC), the Connections tab displays the connection settings that you created and saved. The Connections tab displays all the connections you created to help you view and manage connection information more efficiently.
View connections
You can filter connections by specifying the Status in the upper-right corner of the Connections tab. The filtering conditions include All, Connected, Connection failed, and Connecting. You can also enter the search criteria in the search box to search for the target connection. The connection list displays the following connection information:
Connection Name : the name of the connection and the host, port, cluster, and tenant information. You can click the name of a connection to go to the corresponding connection management page. A sign is displayed in front of the connection name, showing the state of the connection. A green tick indicates a valid connection, and a red exclamation point indicates an invalid connection.
Tag : the tag of the connection. You can create a tag and assign it to a connection. You can assign only one tag to each connection.
Mode : the mode of the connection. Valid value: Oracle or MySQL .
Operation Time : the time when the connection was edited, or the time when the connection was created if the connection has not been edited.
Set the tag
ODC allows you to create a tag and assign it to a connection. You can assign only one tag to each connection. To set a tag, click the Set Tag button next to the Connection Name field in the Create Connection panel. Alternatively, you can move the pointer over the tag column of the row where the target connection is located in the connection list, and click the Set Tag button that appears. The drop-down list provides options for you to create, set, and manage tags.
Create a tag: Select Create Tag from the drop-down list. On the Tags page, specify the name and color of the tag, and click the tick icon to complete the creation.
Set a tag: Select the target tag from the drop-down list that displays all the tags that you created, and modify related parameters to finish the setting.
Manage tags: Click the Settings icon in the upper-right corner of the drop-down list to go to the Tags page, where you can edit or delete created tags.
Pin a connection to top
By default, the connections in the connection list are sorted by their creation time, with the most recently created connection on top. The list does not support custom sorting, but you can pin frequently used connections to the top.
You can click the flag after the name of a connection to pin the connection to top. This turns the flag yellow. You can click the flag again to unpin the connection.
Edit a connection
Click the Edit button in the Actions column of the target connection. The Edit Connection panel appears, which has the same structure as the Create Connection panel and displays the configuration information of the current connection. You can edit the information displayed in the Edit Connection panel.
Before you modify Database Password , you must first click the Change Password button next to the password box to enable password modification. To abort the current change, click the Cancel Modification button next to the password box, and the input in the password box is restored to its original value.
Copy a connection
Click the Copy button in the Actions column of the target connection. The Create Connection panel appears. The copied information is automatically filled in the dialog box. This allows you to create a connection by modifying existing information. The copy feature allows you to create database connections having similar information with ease.
Delete a connection
To delete a connection, click the Delete button in the Actions column of the target connection. For example, when the connected database no longer exists or you do not need to access the connected database, you can directly delete the corresponding connection.
More operations
In addition to the management actions that the Connections tab provides, after you go to the management page of a database connection, the homepage menu in the navigation bar in the upper part of the page further provides the following buttons:
Open Connection in New Window : After you click a connection in the connection list that appears, ODC opens the connection in a new window.
Connections : Click this button to open the Connections page in a new window, where you can view and manage the configuration information of all connections.
Reload : Click this button to reload the current page.
Exit Connection : Click this button to exit the current connection and jump to the Connections page.
