All Products
Search
Document Center

Data Management:Configuration management

Last Updated:Sep 21, 2023

Data Management (DMS) allows DMS administrators to manage system configurations. If you are a DMS administrator, you can modify the system configuration items to flexibly meet your business requirements. This topic describes how to modify the system configuration items.

Prerequisites

You are a DMS administrator. For more information about how to view the role of a user, see View system roles.

Procedure

  1. Log on to the DMS console V5.0.
  2. In the top navigation bar, click O&M. In the left-side navigation pane, click Configuration Management.

    Note

    If you use the DMS console in simple mode, move the pointer over the 2022-10-21_15-25-22.png icon in the upper-left corner of the DMS console and choose All functions > O&M > Configuration Management.

  3. On the Configuration Management page, find the configuration item that you want to modify and click Change in the Actions column.

    Note

    For more information about configuration items, see the Configuration items section of this topic.

  4. In the Change Parameter Configuration dialog box, change the value as needed.

  5. Click Submit.

Configuration items

Parameter

Description

Whether to enable access source IP control

Valid values:

  • Y: enables the IP address whitelist feature. To configure an IP address whitelist, a DMS administrator can click Security and Specifications in the top navigation bar of the DMS console. On the page that appears, click Access IP Whitelists in the left-side navigation pane. Only the access from the specified IP addresses or CIDR blocks in the whitelist is allowed.

  • N: disables the IP address whitelist feature. In this case, the users within the current tenant account can access DMS from all IP addresses.

Whether to enable automatic synchronization of instance resources on the cloud

Valid values:

  • Y: automatically registers all the ApsaraDB RDS instances of the current Alibaba Cloud account with DMS.

  • N: does not automatically register all the ApsaraDB RDS instances of the current Alibaba Cloud account with DMS.

Whether large table archive notification is enabled in SQLConsole

Valid values:

  • Y: notifies users when large tables are archived in the SQLConsole.

  • N: does not notify users when large tables are archived in the SQLConsole.

Data export reason classification

The reason for a data export. The possible reasons are classified into the following categories:

  • Data analysis: You export specific data for analysis.

  • Troubleshooting: You export specific data for troubleshooting.

  • Data synchronization: You export specific data for synchronization.

  • Data test: You export specific data for testing.

  • Business operations: You export specific data to check whether business operation requirements are met.

The whitelist of users who are allowed to create a task flow.

Specifies one or more users who are allowed to create task flows.

List of disabled functional modules

Specifies one or more features that you want to disable. After a feature is disabled, the entry point of the corresponding operation is hidden.

Access control is enabled for new users by default

Valid values:

  • Y: enables access control for new users.

  • N: disables access control for new users.

Enable SQL statement field sensitive level propagation (prerequisite: Sensitive Data protection is enabled for the instance)

Valid values:

  • Y: enables SQL statement field sensitive level propagation.

  • N: disables SQL statement field sensitive level propagation.

Whether to enable RAM permission verification

Valid values:

  • Y: enables RAM permission verification.

  • N: disables RAM permission verification.

Allow sub-accounts to automatically join the tenant

Valid values:

  • Y: allows RAM users to be automatically added to the current tenant account.

  • N: does not allow RAM users to be automatically added to the current tenant account.

Whether to force rollback SQL to be entered when submitting a data change work order

Valid values:

  • Y: requires the user to enter executable SQL statements for rolling back the data change.

  • N: does not require the user to enter executable SQL statements for rolling back the data change.

Whether to enable the super SQL mode.

Valid values:

  • Y: enables the super SQL mode.

  • N: disables the super SQL mode.

The timeout period for the number of rows affected by data change verification.

The timeout period for calculating the number of rows that may be affected. The value must be an integer. Before a data change is performed, DMS calculates the number of rows that may be affected. The calculation takes a long period of time if the data volume is large. You can specify a timeout period for the calculation in seconds to ensure that the data change can be performed as required. DMS automatically terminates the calculation after the specified timeout period.

Data Change reason classification

The reason for a data change. The value must be a JSON string. For more information, see Appendix: Reasons for data changes.

How data changes are performed

Valid values:

  • COMMITOR: The data change is performed by the user who submits the ticket.

  • AUTO: The data change is automatically performed after the ticket is approved.

  • LAST_AUDITOR: The data change is performed by the last user who approves the ticket.

Whether the approval node of the approval flow automatically eliminates the submitter (valid when there are multiple approvers)

Valid values:

  • Y: excludes the user who submits a ticket from the list of approvers on an approval node.

  • N: does not exclude the user who submits a ticket from the list of approvers on an approval node.

Enable workflow approval to exceed your authority (DBA administrator only)

Valid values:

  • Y: allows a DBA or DMS administrator to approve or reject a ticket if the previous approver, such as a data owner of the relevant resource, fails to perform the operation.

  • N: does not allow a DBA or DMS administrator to act beyond its authority to approve or reject a ticket.

Default value: Y

Minimum Word Limit for Work Order Business Background

The minimum number of characters that are entered to describe the business background of a ticket. If the value is less than or equal to 0, no limits are imposed on the number of characters.

Allow OWNER to authorize users

Valid values:

  • Y: allows a data owner to grant permissions on data resources to other users.

  • N: does not allow a data owner to grant permissions on data resources to other users.

Maximum number of queries for the day

The maximum number of queries that each user is allowed to perform per day. The value must be an integer. After the number of queries that a user performs in a day reaches the specified upper limit, the user cannot perform more queries for the rest of the day. This configuration item applies to all the users within the current tenant account.

Day query rows upper limit

The maximum number of data rows that can be returned to each user per day. The value must be an integer. After the number of data rows that are returned to a user in a day reaches the specified upper limit, the user cannot perform more queries for the rest of the day. This configuration item applies to all the users within the current tenant account.

Redis gets the maximum number of polls for the key list.

The maximum number of polls for the key list that Redis gets. The value must be an integer. If the value is less than or equal to 0, no limits are imposed on the number of polls.

Maximum number of returned rows for cross-database queries

The maximum number of rows returned for cross-database queries. The value must be an integer. Default value: 100. Maximum value: 3000.

DMS locale: ZH/EN/JA/ZT

The language of the operation logs that are returned by DMS. Valid values:

  • ZH: simplified Chinese

  • EN: English

  • JA: Japanese

  • ZT: traditional Chinese

[Data Security] Anti-leakage Digital Watermarking Function

Specifies whether to enable digital watermarks. Valid values:

  • Y: enables digital watermarks.

  • N: disables digital watermarks.

Watermark for Exported SQL Result Sets

Valid values:

  • Y: enables watermark for exported SQL result sets.

  • Y: disables watermark for exported SQL result sets.

Appendix: Reasons for data changes

DMS provides the following default reasons for data changes, in the format of JSON strings:

[{"key":"config_correct","value":"Modify Config"},
{"key":"project_init_data","value":"Init Project Data"},
{"key":"program_bug","value":"Program Bug"},
{"key":"require_deal_without_backend_function","value":"Requirements Without Backend Function"},
{"key":"history_data_clear","value":"History Data Clean"},
{"key":"test","value":"Test"},
{"key":"mis_operation","value":"Mis Operation"},
{"key":"others","value":"Others"}]

The following table describes the default reasons for data changes.

key

value

Description

config_correct

Modify Config

Modify configurations.

project_init_data

Init Project Data

Initialize the data for a project.

program_bug

Program Bug

Fix a bug.

require_deal_without_backend_function

Requirements Without Backend Function

Manage the data of an application that does not support backend management.

history_data_clear

History Data Clean

Clears historical data.

test

Test

Perform a test.

mis_operation

Mis Operation

Restore data after an accidental operation.

others

Others

Change data for other reasons.