This topic describes the changes to the features of Data Management (DMS) and provides links to the related topics.

2021

Release time Feature Description References
May 2021 PostgreSQL databases can be managed in DMS. DMS allows you to manage native PostgreSQL and AnalyticDB for PostgreSQL databases and user permissions on the databases.
April 2021 The data security protection feature is supported. The data security protection feature can generate proxy endpoints for a database instance to protect data security when programs access databases. This feature allows you to manage data security, enable access control, de-identify data, and audit operations for the databases of your enterprise in a more comprehensive manner. Enable the data security protection feature
Dameng (DM) databases are supported. DMS allows you to perform various operations on a DM database. For example, you can import, query, change, export, and visualize data for a DM database. In addition, you can provide data services based on a DM database. Supported database types and features
The category feature is supported. The category feature can be used to classify tables. This helps DMS administrators, developers, and O&M engineers to better manage and use tables. Use the category feature
The Tables page is optimized. DMS allows you to view the technical metadata, business metadata, and management metadata of a table on the Tables page. Technical metadata includes the instance and database to which the table belongs, table name, and fields. Business metadata includes the business description and tags of the table. Management metadata includes the owner of the table and your permissions on the table. DMS also allows you to manage the table by performing simple operations on this page. The Tables page can help you fully understand and efficiently use the data of the table. Table details
The schema read-only role is supported. A user who assumes the schema read-only role has all the permissions that a regular user has. In addition, this user has permissions to query the metadata of instances, databases, and tables. For example, this user can view the details of a table or export an entire database. To query data, this user must apply for the required query permissions. System roles
March 2021 Task flows can be published or unpublished. After you configure or modify a task flow, you must publish the latest task flow to an online environment. This effectively prevents the modified task flow from being published before the modifications to the task flow are confirmed. Publish or unpublish a task flow
The SQL Result Set Export feature is supported. SQL result sets can be exported at regular intervals. You can export relevant data after you perform operations. Export SQL result sets
The syntax prompts for Redis are supported in the SQLConsole. The syntax prompts for Redis are supported in the SQLConsole. In addition, DMS allows you to enable the super SQL mode feature for ApsaraDB for MongoDB and ApsaraDB for Redis databases. Overview
The SQL review feature is optimized. You can use this feature to review the submitted SQL statements and acquire optimization suggestions. This prevents the SQL statements that do not use indexes or do not conform to standards from being published to an online environment. This also reduces the risk of SQL injection attacks. SQL review
The data analysis feature is optimized. You can use this feature to go to the details page of a task in Data Transmission Service (DTS). Data analysis
February 2021 The data analysis feature is supported. The data analysis feature of DMS allows you to create an AnalyticDB for MySQL V3.0 data warehouse with a few clicks from an ApsaraDB RDS for MySQL database. You can create a report, run recurring tasks, and visualize data in the data warehouse. Data analysis
The data archiving feature is supported. DMS allows you to periodically archive the data that is stored in ApsaraDB RDS for MySQL or PolarDB for MySQL databases to Object Storage Service (OSS). Data archiving
January 2021 Risk audit reports can be generated. DMS allows you to generate risk audit reports for database instances. Risk audit reports collect and assess various risks that are involved in the O&M of database instances. Risk audit reports also provide optimization suggestions for you to improve the security and stability of your instances. Generate a risk audit report
The schema versions of tables can be managed. In DMS, the schema versions of a table in a database can be saved. After you change the schema of a table in a database in DMS, DMS adds the latest schema to the schema version list of the database. You can download and compare schema versions, and restore an earlier schema version in the schema version list. Manage schema versions
The super SQL mode feature is supported. DMS provides the super SQL mode feature. After you enable this feature as a DMS administrator or a database administrator (DBA), all SQL statements that you execute on the SQLConsole tab are directly executed without the limit of security rules. Super SQL mode
The SQL review feature is optimized. You can use the SQL review feature to review DDL statements and acquire optimization suggestions. This feature is available for the instances that are managed in Flexible Management mode. SQL review
The data factory feature is optimized. The SQL editor that is used to edit the code of task nodes in task orchestration and data warehouse development is optimized. The SQL editor supports intelligent code completion. Configure a task flow

2020

Release time Feature Description References
December 2020 The features in the top navigation bar can be customized. You can add your favorite features to the top navigation bar. This allows you to use these features with ease. Customize the top navigation bar of the DMS console
The shadow table synchronization feature is supported. DMS provides the shadow table synchronization feature to automatically create a shadow table based on the schema of a source table. DMS generates the name of the shadow table by attaching a prefix or suffix to the name of the source table. You can use this feature for end-to-end stress testing. Synchronize shadow tables
Validity periods can be configured for the maximum number of queries to be performed and that of rows to be queried. When you manage users, you can configure the validity periods for the maximum number of queries to be performed and that of rows to be queried. This allows you to restrict queries in a short time period. Manage users
SQL templates are provided. SQL templates are provided in the right-side panel of the SQLConsole tab. A large number of common scripts such as SQL statements, programmable objects, and functions are provided.SQL Template Overview
User permissions on MariaDB databases can be managed in DMS. DMS allows you to manage user permissions on MariaDB databases. Manage user permissions on MySQL databases
User permissions on AnalyticDB for MySQL databases can be managed in DMS. DMS allows you to manage AnalyticDB for MySQL databases and user permissions on the databases. Manage user permissions on MySQL databases
The schema design feature is optimized. The GUI that is used for schema design is improved. N/A
The task orchestration feature is optimized. You can view the status statistics about task flows and the task flow list on the homepage of the Task Orchestration tab. You can also create a task flow from a template. Configure a task flow
The notification feature is optimized. By default, the notification feature is enabled. You can receive notifications at the earliest opportunity. Manage notification rules
November 2020 The operation audit feature is optimized. DMS provides the operation audit feature in addition to the basic features of operation log management. You can use this feature to view and manage the SQL statements that are executed in the SQLConsole, tickets, logon information, and operation logs. You can also use this feature to troubleshoot database issues with ease and audit the operations that are performed on databases. Operation audit
Optimization suggestions are provided in SQL review. After you submit SQL statements for data changes or on the SQLConsole tab, DMS reviews the submitted SQL statements based on the specifications in security rules and provides optimization suggestions. This can help you review SQL statements and optimize the submitted SQL statements before data changes are submitted. This can also prevent database exceptions from being caused by SQL statements that have potential issues. SQL review optimization
ApsaraDB for Lindorm and ApsaraDB for Cassandra databases can be managed in DMS. DMS allows you to manage ApsaraDB for Lindorm and ApsaraDB for Cassandra databases in a centralized manner. You can register instances with DMS. You can also manage permissions and sensitive fields, query data by executing SQL statements, and update data. Supported database types and features
DMS can be accessed by using Alibaba Cloud Security Token Service (STS) tokens. You can use STS to assign a token to a self-managed O&M platform. Then, the platform can access databases that are managed in DMS without logon. N/A
October 2020 ApsaraDB for HBase databases can be managed in DMS. DMS allows you to manage ApsaraDB for HBase databases in a centralized manner. You can register instances with DMS. You can also manage permissions and sensitive fields, query data by executing SQL statements, and update data. Supported database types and features
The data import feature is optimized. You can select the import mode, the type of CSV file, or the execution policy as needed. This can improve the efficiency of data import. Import data
DMS Database Lab is available on the Alibaba Cloud international site (alibabacloud.com). DMS Database Lab is available on the Alibaba Cloud international site (alibabacloud.com). Overview of DMS Database Lab
September 2020 The notification feature is supported.
  • DMS supports a variety of notification methods, such as DingTalk notifications, text messages, emails, and DingTalk chatbot messages.
  • DMS can send notifications about the status updates of tickets and task flows to users.
Manage notification rules
August 2020 The metadata access control feature is supported. After you enable this feature for an instance or a database, only users who have permissions on the instance or database can view information about and access the instance or database. This further enhances data security. Metadata access control
Tickets and the SQLConsole tab of databases can be shared. DMS allows you to share the SQLConsole tab of a database or a ticket with other users by generating a share link. This enhances business efficiency. Share the SQLConsole tab or a ticket
The database grouping feature is supported. DMS allows you to group multiple databases that are of the same engine type and deployed in the same environment together. You can use this feature to apply a data change or a schema change to all of the databases in a database group with ease. Database grouping