How do I use the instance list?

To help you manage database instances more quickly and easily, DMS provides the instance list function, which allows you to quickly access the database instances you need.

You can click the instance list on the menu bar to view all the instances for which you have permission. Or, you can click the Favorite tab in the instance list to view the favorite instances.

Details are as follows:

• Click the Instance List menu, and click the Add and Favor button in the upper right corner of the Instance List page.

• Click Data Source Management > Instance Metadata on the menu, and click / in the list on the Instance List page to favor an instance or cancel favoring.

How do I view or use the instance?

You can view the instances available for viewing or use on the following pages:

• Click Data Source Management > Instance Metadata menu to view or use the instance.

• Click the Instance List menu to view/use instances.

• Click the Security Center > Team Management menu and toggle the Team Instance Management tab to view or use the instance.

• Click Personal Center > My Team to toggle the Team Instance tab and view or use the instance.

It is important to note that DMS controls resource permissions to ensure data security, which includes organizational resource isolation and team resource isolation. You can obtain the viewing/using permissions using the following methods:

• Join the organization and team where the instance is located.

• Obtain data authorization for an instance. To perform this operation, the administrator or team administrator of the organization or team where the instance is located should go to the Data Source Management > Instance Metadata page and click the Data Permission Management button in the instance list.

How do I hide the instance address?

To better protect data security, DMS allows you to hide the instance address. After this function is enabled for an instance, the instance address and port are uniformly displayed as ***:*** on the DMS platform.

This function is only restricted to the administrators or team administrators. You can enable or disable this function in the following ways:

• When adding a new instance: Check the Hide Instance Address option to enable the hiding instance address function.

• Enabling/disabling the instance address hiding for existing instances: Click the Data Source Management > Instance Metadata menu, click Edit in the instance list to open the Edit Instance pop-up window, and check or uncheck the Hide Instance Address option.

What is the purpose of disabling instances?

By disabling an instance, you set the database instance to an unavailable state in DMS. When an instance is disabled, it is removed from the instance favorites. You will not be able to access and use the instance until it is re-enabled.

This function is typically used to temporarily restrict access to instances when performing maintenance, upgrades, or other operations to ensure data security and system stability.

The disabling/enabling instance function is restricted to administrators or team administrators only. Details are as follows:

• Click the Data Source Management > Instance Metadata menu and click Disable Instance/Enable Instance in the instance list.

How do I use the query function?

DMS provides several entrances to the query function. You can use the query function through the following methods:

• On the Console Home page, click the Query button in the Recently Accessed Databases/Schemata and Recently Opened Scripts below.

• Click Instance List. Then, click the instance name to unfold the database list and double-click the database name to use the query function.

• Click the Development Space > Query Window menu to go to the Query Window homepage.

• Click the Data Source Management > Instance Metadata menu and click Query in the Instance List.

• Click the Security Center > Team Management menu, switch to the Team Instance Management tab, and click Query in the Instance List.

• Click the Personal Center > My Team menu, switch the Team Instance tab, and click Query in the Instance List.

Note: before using the query function, make sure that you have obtained permission to view or use an instance.

How do I use the script function?

The script function allows you to quickly access and use scripts anytime and anywhere, thus improving productivity. Utilizing the script function to its fullest enables you to simplify common tasks, resulting in time and effort savings.

DMS supports the editing, deletion, and replicating for use of scripts to better meet your database management needs.

You can access and use the script function through the following methods:

• On the Console Home page, click the Open/Edit button in the list of Recently Opened Scripts at the bottom.

• Click the Development Space > Query Window menu to go to the Query Window homepage, select a recently opened script, and click the Open/Edit button.

• Go to the Query Window page and click My Script tab on the left side to view the list of scripts and use the script function. Or, go to the Query Window page, click the Save button in the SQL edit box area to save the SQL statement in the edit box to My Scripts.

How do I create or edit a table in a visualized manner?

You can easily create or edit a table in a visualized manner on the DMS platform. This helps improve your database management efficiency and simplify the table structure design and modification process.

Details are as follows:

• Click the Development Space > Query Window menu, right-click the table name row at the table tab on the left and select Create Table/Edit Table.

• Click the Data Source Management > Instance Metadata menu, click the Database List in the Instance List, and go to the Database List page. Click the Object List in the Database List to go to the Object List page, select the upper table tab, and click the Create Table button on the upper left to visually create a table in the Query Window. In the Table List, you can click Edit to edit the table.

How do I create or edit a programmable object in a visualized manner?

You can easily create or edit a programmable object in a visualized manner on the DMS platform. This helps improve your database management efficiency and simplify the programmable object design and modification process.

Details are as follows:

• Click the Development Space > Query Window menu, switch the Programmable Object tab in the left area, right-click the Programmable object name line, and select Create/Edit.

• Click the Data Source Management > Instance Metadata menu, click the Database List in the Instance List, and go to the Database List page. Click the Object List in the Database List to go to the Object List page, switch the upper programmable object tab, and click the Create button on the upper left to visually create a programmable object in the Query Window. In the list, you can click Edit to edit the programmable object.

Data Management Service (DMS)