This topic describes the release notes for Data Management (DMS) in 2021 and provides links to the relevant references.
December 2021
| Feature | Type | Description | References |
|---|---|---|---|
| ApsaraDB for Lindorm is supported for data archiving. | New | You can use this feature to archive the data of large tables to an ApsaraDB for Lindorm instance and perform operations such as deleting the archived data from source tables and optimizing the storage usage of source tables. | None |
| T+1 full data snapshots are supported. | New | You can use this feature to create snapshots for specified tables every hour or day on a T+1 basis. This way, you can view the statistics on data by hour, day, or month. | Create snapshots of full data on a T+1 basis |
November 2021
| Feature | Type | Description | References |
|---|---|---|---|
| The skin and interaction interface of the DMS console can be configured. | New | You can configure the skin and interaction interface of the DMS console. | Configure the DMS console based on your business requirements |
| The data security protection feature is renamed as the secure access proxy feature. | Optimized | The data security protection feature is renamed as the secure access proxy feature. | Enable the secure access proxy feature |
| Object Storage Service (OSS) buckets can be registered with DMS. | New | You can register an OSS bucket with DMS. You can use an OSS bucket as the destination of data output nodes in offline data integration tasks or create cross-database Spark SQL nodes for the OSS bucket in the task orchestration module. | Register an OSS bucket |
October 2021
| Feature | Type | Description | References |
|---|---|---|---|
| The sensitive data protection feature is updated and released as a commercial feature. | Iterated | You can use the sensitive data protection feature to scan the metadata of databases to detect, de-identify, and manage sensitive data. | Overview |
September 2021
| Feature | Type | Description | References |
|---|---|---|---|
| Hologres and Db2 databases are supported. | New | DMS allows you to manage Hologres and Db2 databases and user permissions on the databases. | Supported database types and features |
| Conditional branch nodes are supported for task orchestration. | New | You can use a conditional branch node to perform conditional judgment in a task flow. This allows the task flow to go to specific subsequent tasks based on specific conditions. | Configure a conditional branch node |
| SQL assignment nodes are supported for task orchestration. | New | An SQL assignment node can read data and assign the data to an output variable of the node. | Configure an SQL assignment node |
August 2021
| Feature | Type | Description | References |
|---|---|---|---|
| DMS is updated to V5.0. | Iterated | The DMS console V5.0 classifies functional modules based on scenarios and integrates the features of Data Transmission Service (DTS). | Switch between the previous and new versions of the DMS console |
July 2021
| Feature | Type | Description | References |
|---|---|---|---|
| The offline integration feature is supported. | New | The offline integration feature provides a low-code tool that you can use to develop data processing tasks. You can combine various task nodes to form a data stream and configure periodic scheduling to process or synchronize data. | Overview |
| The DevOps feature is supported. | New | The DevOps feature allows you to customize R&D processes, advance R&D processes stage by stage, and control the quality of R&D processes. |
May 2021
| Feature | Type | Description | References |
|---|---|---|---|
| Script nodes are supported for task orchestration. | New | You can use script nodes and Database Gateway to schedule scripts in a unified manner. | Configure a script node |
| PostgreSQL databases can be managed in DMS. | New | DMS allows you to manage PostgreSQL and AnalyticDB for PostgreSQL databases and user permissions on the databases. |
April 2021
| Feature | Type | Description | References |
|---|---|---|---|
| The data security protection feature is supported. | New | 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, control access, de-identify data, and audit operations for the databases of your enterprise in a more comprehensive manner. | Enable the secure access proxy feature |
| Dameng (DM) databases are supported. | New | 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. | New | The category feature can be used to classify tables. This helps DMS administrators, developers, and O&M engineers better manage and use tables. | Use the category feature |
| The Tables page is optimized. | 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 database 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 perform specific management operations on a table on the Tables page. The Tables page can help you fully understand and efficiently use the data of a table. | Manage table details |
| The schema read-only role is supported. | New | In addition to the permissions that a regular user has, a user who is assigned the schema read-only role can query the metadata of a database instance, a database, and a table, such as viewing the details of a table or exporting the schemas of a database. However, a user who is assigned the schema read-only role must apply for the query permissions to query data. | System roles |
March 2021
| Feature | Type | Description | References |
|---|---|---|---|
| Task flows can be published or unpublished. | Optimized | 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. | New | SQL result sets can be exported at regular intervals. This way, you can configure the system to automatically export relevant data after specified operations are performed. | Export SQL result sets |
| The syntax prompts for Redis are supported in the SQLConsole. | Optimized | The syntax prompts for Redis are supported in the SQLConsole. In addition, DMS allows you to enable the super SQL mode for ApsaraDB for MongoDB and ApsaraDB for Redis databases. | Overview |
| The SQL review feature is optimized. | Optimized | You can use the SQL review feature to review the submitted SQL statements and obtain 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. | Optimized | The data analysis feature allows you to go to the details page of a task in DTS with a few clicks. | Data analysis |
February 2021
| Feature | Type | Description | References |
|---|---|---|---|
| The data analysis feature is supported. | New | You can use the data analysis feature to create an AnalyticDB for MySQL V3.0 data warehouse with a few clicks from an ApsaraDB RDS for MySQL database. You can create reports, run recurring tasks, and visualize data in the data warehouse. | Data analysis |
| The data archiving feature is supported. | New | You can use the data archiving feature to periodically archive the data that is stored in ApsaraDB RDS for MySQL or PolarDB for MySQL databases to OSS. | Archive data to OSS |
January 2021
| Feature | Type | Description | References |
|---|---|---|---|
| Risk audit reports can be generated. | New | 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. | New | 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 is supported. | New | After you enable the super SQL mode as a DMS administrator or a database administrator (DBA), all SQL statements that you execute on the SQLConsole tab are executed without being limited by security rules. | Super SQL mode |
| The SQL review feature is optimized. | Optimized | You can use the SQL review feature to review SQL statements that perform lockless changes and obtain optimization suggestions. This feature is available for the instances that are managed in Flexible Management mode. | SQL review |
| The data factory feature is optimized. | 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 |