Data Management (DMS) is a one-stop data management platform for managing data across its full lifecycle — from development and change management to security, compliance, and operations.
| Level-1 feature | Level-2 feature | Level-3 feature | Description | References |
|---|---|---|---|---|
| Homepage | Left-side navigation pane | Instance registration | Add or import database instances as a database administrator (DBA) or DMS administrator. | Register an Alibaba Cloud database instance |
| Database instance search | Search for a database instance by name, database name, endpoint, or database link name. | N/A | ||
| Instance list | View all normal and abnormal database instances in the current tenant. Disabled or deleted instances are not shown. You can view basic information about each instance, including status, control mode, source from which the instance is imported, type, region, and environment type. Right-click an instance or database to access available operations. | N/A | ||
| Top navigation bar | Alibaba Cloud tickets | Submit a ticket when you encounter an issue in DMS. | N/A | |
| User center | Manage your Alibaba Cloud account: add funds, manage renewals, view orders and bills, and activate, renew, or upgrade DMS service plans. | Renew chargeable DMS items and upgrade service specifications | ||
| Help center | Access DMS documentation or join the DingTalk support group for technical assistance. | Common user | ||
| Language switching | Switch the display language of the DMS console. | N/A | ||
| Display settings | Customize the DMS console layout and skin. Options include drop-down menus in the top navigation bar, Shortcuts, Show Tabs, and Skins (blue or dark; blue by default). | Customize the layout and style of the DMS console | ||
| User information | View account details including username, UID, role, tenant ID, and tenant name. Configure notification preferences, log out, or switch between tenants if your account belongs to multiple tenants. | View system roles | ||
| Resource search | - | Search for databases, database instances, tables, features, or tickets across DMS. | N/A | |
| Entry points | Entry point | Access the asset dashboard, import or create a database instance, and analyze data from a single entry. | N/A | |
| My tickets | Go directly to the My Tickets tab. | N/A | ||
| My iterations | Go to the DevOps tab to view iterations you created or are participating in. | N/A | ||
| Asset list | Recently accessed assets | Open the SQL Console for recently accessed databases, and view their performance and details. | N/A | |
| Assets on which you have permissions | View all permissions you hold — databases, tables, sensitive columns, database instances, and rows. Release permissions you no longer need or renew permissions that are about to expire. | View owned permissions | ||
| Assets that belong to you | View resources you own, see who has permissions on them, and grant or revoke access for specific users. | View resource roles | ||
| Assets that you follow | Access databases and tables you have marked as followed. | N/A | ||
| Data assets | Global search | - | Search for databases, database instances, tables, features, or tickets. | N/A |
| Asset categories | - | Group database instances, databases, and tables into categories so DBAs, developers, and O&M engineers can locate and manage them efficiently. | Use the asset category feature | |
| Instance management | Instance list | - | Perform full lifecycle management of database instances: log on, modify instance settings (control mode, security rules, environment, DBA), refresh metadata, manage user permissions, remove instances, disable instances, enable access control, use the secure access proxy, restrict SQL statements by time window, and run data security checks (geo-redundancy, database audit, fine-grained permission control, sensitive data discovery, data masking). | Modify database instances, synchronize the data dictionary of a database instance, disable or enable database instances, remove database instances, and enable metadata access control |
| Database list | - | View table schemas and indexes, query data with custom SQL, manage user permissions, enable access control, and track schema versions — including auto-generated table creation statements and difference scripts between versions. | Manage a database and enable metadata access control | |
| SQL console | SQL console | Visual operation section | Browse all tables, fields, and indexes for the current database. Right-click a table to modify its schema, import data, or export data. Create, view, run, and manage programmable objects including views, stored procedures, functions, triggers, and events. | GUI of the SQL Console page |
| SQL execution section | Write, format, run, and diagnose SQL statements. Edit result sets, update execution plans, use intelligent SQL completion, and manage saved SQL snippets. | Diagnose SQL statements | ||
| Execution result section | View execution results and history in table format. Export result sets to Excel or text files, generate INSERT scripts, and copy or download individual rows or multiple rows. | N/A | ||
| Table list | View table schemas and indexes, apply for permissions, manage data owners, export table creation statements or schemas, archive data, and adjust sensitivity levels. Use the built-in code generator to produce boilerplate code and reduce development effort. | N/A | ||
| Data analysis | Build an enterprise data warehouse with a few clicks. Synchronize data from ApsaraDB RDS for MySQL instances to AnalyticDB for MySQL V3.0 clusters in real time for data analysis, report development, and scheduled tasks. | Create data warehouses | ||
| Database performance analysis | Use Database Autonomy Service (DAS) for quick diagnostics, real-time performance monitoring, session analysis, and storage analysis — giving you a unified view of database health and enabling fast troubleshooting. | View the performance details of a database instance | ||
| Metadata synchronization | Collect the latest metadata (tables, fields, indexes, programmable objects) from a database to keep permission management current across all security levels. | Synchronize the data dictionary of a database instance | ||
| Database export | Export data, schemas, and table creation statements from a database. | Export databases | ||
| Version management | Track database schema history automatically. View table creation statements for each version, compare two versions to identify differences, and generate fix scripts to resolve inconsistencies. | Manage schema versions | ||
| Operation audit | Audit SQL queries, tickets, and logon records for a single database to troubleshoot issues efficiently. | Audit operations | ||
| Risk audit | Identify risks related to metadata, sensitive data, and SQL statements to improve database security and stability. | Generate a risk audit report | ||
| URL sharing | Share the URL of a SQL Console tab — including its SQL statements — with other users. | Share the SQLConsole tab or a ticket | ||
| Super SQL mode | Bypass security rules for emergency O&M. When enabled by a DMS administrator or DBA, all SQL submitted on the SQL Console tab runs without restriction. | Use the super SQL mode | ||
| Topology | View the physical databases that make up the current logical database. | N/A | ||
| Cross-database query | - | - | Query data across multiple database instances without switching contexts. | Query data across multiple database instances |
| Database development | Schema change | Schema design | Design schemas that meet R&D specifications for specific databases and tables. Customize R&D processes per business line and maintain schema consistency across development, test, and production environments. | Design schemas |
| Schema synchronization | Compare schemas across databases and generate fix scripts to resolve inconsistencies — useful for syncing schemas between production and test environments, different test environments, or different production environments. | Synchronize schemas | ||
| Shadow table synchronization | Automatically create shadow tables based on source table schemas, with a configurable prefix or suffix. Use shadow tables for end-to-end stress testing without affecting production data. | Create shadow tables for synchronization | ||
| Empty database initialization | Synchronize schemas from a source database to an empty database. Useful for deploying consistent schemas across multiple regions and units. | Initialize empty databases | ||
| Table consistency repairing | Compare table schemas between environments (for example, test vs. production), identify differences, and run fix scripts in the target environment. Also supports logical database consistency checks — select a baseline table and verify that all table shards match its schema. | Repair table inconsistency | ||
| Data change | Regular data change | Execute INSERT, UPDATE, DELETE, and TRUNCATE statements to update database data. Covers scenarios such as data initialization, historical data deletion, troubleshooting, and feature testing. | Perform regular data change | |
| Lock-free change | Split large DML operations into batches to avoid locking — ideal for high-volume changes like historical data deletion or full-table field updates. For DDL, change schemas without locking tables, preventing business interruptions and eliminating replication latency between primary and secondary instances that native online DDL can cause. | Overview | ||
| Historical data deletion | Periodically delete historical data using the lock-free change mechanism to prevent data accumulation and protect production stability. | Clear historical data | ||
| Programmable objects | Change stored procedures through a standardized management and approval process. | Change programmable objects by using stored routines | ||
| Data import | Import large volumes of data into databases quickly, reducing manual effort and resource costs. | Import data | ||
| Data export | SQL result set export | Write and run SQL queries, then export the result sets. | Export SQL result sets | |
| Database export | Export an entire database or specific tables — data only, schemas only, or both. | Export databases | ||
| SQL review | SQL review tickets | Automatically review submitted SQL statements against security rules. Flags SQL without indexes, violations of development standards, and SQL injection risks. Customize rules to enforce standards such as requiring primary keys, restricting primary key data types, or limiting primary key column count. | SQL review | |
| Environment construction | Database cloning | Clone a database to replicate its data — useful for initializing databases or syncing data between development and test environments. | Database cloning | |
| Test data generation | Generate large volumes of test data using built-in algorithm engines: random values, region names, virtual IP addresses, and more. | Generate test data | ||
| Data tracking tickets | Data tracking | Find data changes made within a specific time window and export rollback scripts in batches. Submit a data change ticket to run the rollback scripts and restore data. | Data tracking | |
| R&D space | DevOps | Manage R&D processes end-to-end: customize workflows, enforce quality controls, and advance projects stage by stage. Create tickets at each iterative stage to support collaborative development and reduce accidental changes. | Manage iterations | |
| My tickets | View, approve, and track tickets — including pending approvals, submitted tickets, and processed tickets with full status and detail history. | Approve tickets | ||
| Data Transmission Service (DTS) | Data migration | - | Migrate data between homogeneous and heterogeneous data sources using DTS. Covers cloud migration, instance-to-instance migration within Alibaba Cloud, and database splitting and scale-out. | Overview of data migration solutions |
| Change tracking | - | Capture incremental data from ApsaraDB RDS for MySQL, PolarDB for MySQL, PolarDB-X, self-managed MySQL, and self-managed Oracle databases. Use the captured data for cache updates, async business decoupling, heterogeneous data sync, and real-time ETL pipelines. | Overview of change tracking scenarios | |
| Data integration | Data synchronization | Synchronize data between sources in real time using DTS. Supports active geo-redundancy, geo-disaster recovery, zone-disaster recovery, cross-border data synchronization, query load balancing, cloud business intelligence (BI) systems, and real-time data warehousing. | Overview of data synchronization solutions | |
| Batch integration | Build data processing pipelines with a low-code tool. Combine task nodes into data flows and configure scheduled runs to handle complex big data scenarios such as enterprise operations, digital marketing, and intelligent recommendation. | Overview | ||
| Streaming ETL | Extract, transform, and load streaming data in real time to support real-time data processing and computing scenarios. | What is ETL? | ||
| Data development | Task orchestration | Orchestrate multiple task types into scheduled task flows. Supports complex scheduling scenarios and improves data development efficiency. | Overview | |
| Data warehouse development | Manage data warehouse projects by workspace, business scenario, and task flow. Organize warehouse layers to meet complex development and management requirements. | Create a workspace | ||
| Heterogeneous database migration (ADAM) | Database evaluation | Analyze the source database and generate a migration report covering migration solutions, destination database compatibility, migration risks, application transformation recommendations, and estimated costs. | Overview | |
| Database transformation and migration | Transform and migrate database schemas using intelligent tooling — compare source schemas and apply migration changes based on analysis results. | Database transformation and migration | ||
| Application evaluation and transformation | Analyze application frameworks, identify transformation items (focus areas and SQL statements), and get architecture migration guidelines to complete the application transformation. | Overview | ||
| Database cutover | Cut over your service to the cloud database after evaluation, transformation, and application migration are complete. | Create a cutover project | ||
| Migration lab | Periodically collect and consolidate SQL statements from a source database. The SQL adapter converts incompatible SQL statements from Oracle to PolarDB for PostgreSQL (Compatible with Oracle) in real time, and asynchronously records statements that require modification. | Periodic SQL collection and SQL Adapter | ||
| SQL conversion | Convert SQL statements from the source database format to the destination database format, reducing developer rewrite effort during migration. | Convert SQL scripts | ||
| Security and compliance | Permissions | - | Grant tenants specific operation permissions (query, change, export) and control permissions (logon, performance view, database, table, sensitive column, data row, programmable object) on database instances, databases, tables, columns, and rows. Permissions take effect after approval. | Overview |
| Security rules | - | Define fine-grained rules that govern database operations — queries, exports, and data changes. Security rules integrate R&D processes, development standards, and approval workflows. They support multiple SQL engines and customizable SQL checks so teams can enforce consistent database governance across all developers. | Manage security rules | |
| Approval processes | - | Configure tiered approval workflows for different user behaviors. Each approval node represents a stage; add one or more approvers per node. Associated with security rules and fully customizable. | Configure approval processes | |
| IP address whitelists | - | Restrict DMS access to users from specific trusted network environments. | Access IP whitelist | |
| Operation audit | - | Query executed SQL statements, tickets, logon records, and operation logs across DMS for compliance auditing and issue investigation. | Audit operations | |
| Sensitive data management | Sensitive data assets | - | Detect and protect sensitive data assets across your enterprise. Collect sensitive data, enable or disable sensitive data protection per database instance, adjust sensitivity levels and data masking permissions per field, and grant or revoke field-level access for specific users. | Overview, enable the sensitive data protection feature, and manage sensitive data |
| Rule configurations | - | Scan database fields using identification templates to detect sensitive data. Use built-in detection rules for regulatory compliance, or create custom detection models for specific requirements. Apply built-in or custom data masking algorithms to protect sensitive fields. | Manage DMS classification and grading templates, manage detection models, and create a data masking algorithm | |
| Sensitive data audit | - | Track how sensitive data is accessed and used in DMS to detect abnormal usage and potential data breaches. | Audit sensitive data | |
| Data watermarks | - | Embed watermarks in data or files and extract them to trace the source of data during dissemination or distribution. | Use data watermarks | |
| Solutions | Data archiving | - | Archive data from large tables to another database on a schedule. Also delete archived data and reclaim storage to keep production tables lean and queries fast. | Data archiving |
| Data analysis | - | Create a real-time data warehouse with a few clicks. Synchronize data to AnalyticDB for MySQL within seconds for accurate, up-to-date business insights. | Create data warehouses | |
| Database migration | - | Encapsulate end-to-end database migration workflows: prechecks, data migration, post-migration data consistency checks, source database cleanup, and destination database renaming. | Database migration | |
| O&M | User management | - | Add and remove DMS users, and grant or revoke permissions on database instances, databases, tables, rows, and sensitive columns. | Manage users |
| Task management | - | Create SQL tasks and manage existing ones. Tasks are generated from tickets (data change, schema design, database/table synchronization). SQL run directly on the SQL Console is not included. | Manage tasks | |
| Configuration management | - | Modify system-wide settings as a DMS administrator or DBA: enable automatic cloud instance synchronization, configure IP address whitelists, and set approval delegation rules for administrators and DBAs. | Configuration Management | |
| Notification management | - | Configure notification rules for ticket and task flow status updates. Specify recipients to keep the right people informed at each stage. | Manage notification rules | |
| Database grouping | - | Group databases running the same engine in the same environment. Changes or schema designs submitted against a group apply to all databases in that group simultaneously. | Database grouping |
A hyphen (-) indicates that no features are involved.