Data Management (DMS) administrators manage the full lifecycle of a DMS tenant: registering database instances, controlling user access, enforcing security policies, and overseeing development workflows. This document describes the initial setup sequence and the complete set of features available to DMS administrators.
Set up DMS
Complete the following steps to make your DMS environment operational.
-
Log on to the DMS console and register a database instance. See Instance management.
-
Go to the Users page. Add Alibaba Cloud accounts or RAM users as DMS users and assign roles. If no role is assigned, the user defaults to the Regular User role. See Manage users.
-
Grant permissions on databases and tables to users. See Permissions.
Features available to DMS administrators
Data assets
| Feature | Description |
|---|---|
| Instance management | Register, view, and modify database instances. |
| Asset category | Classify tables to help administrators, developers, and O&M engineers manage and use tables. |
SQL console
| Feature | Description |
|---|---|
| Single database query | Write SQL statements to query data in a single database. Use this to verify business code, analyze product effects, or identify issues in an online environment. |
| Cross-database query | Run join queries across online heterogeneous databases deployed in different environments. |
Security and specifications
| Feature | Description |
|---|---|
| Security rules | Define which SQL statements can be executed within your DMS tenant. |
| Approval processes | Configure ticket-specific approval workflows. Approval processes are tied to security rules. |
| Operation audit | Review a full history of data changes. Each audit record captures the user, the operation performed, and the timestamp. |
| Access IP whitelist | Restrict access to resources within your DMS tenant to specific IP addresses or CIDR blocks. |
| Sensitive data management | Apply masking algorithms to sensitive data and adjust sensitivity levels. |
| Data watermarks | Embed or extract watermarks to trace data origin during distribution. |
| Permission management | Apply for and view permissions on instances, databases, tables, and sensitive fields. |
Database development
| Feature | Description |
|---|---|
| Schema design | Create or modify tables as part of project development, optimization, or new business requirements. |
| Database and table synchronization | Compare and synchronize table schemas across environments (such as online and offline) to keep schemas consistent. |
| Data changes | Submit data change tickets to initialize data, clean up historical records, fix bugs, or run tests. |
| Data import | Submit data import tickets to bulk-load data into your databases. |
| Data export | Submit data export tickets to extract large datasets for analysis or downstream use. |
| Data tracking | Restore data to a previous state after accidental operations. |
| Test data generation | Generate test data to ensure data security and discreteness, and improve production efficiency. |
| SQL review | Catch SQL statements that lack indexes or violate database development standards, and block SQL injection risks. |
| Database cloning | Clone MySQL databases. |
Data Transmission Service (DTS)
| Feature | Description |
|---|---|
| Task orchestration | Build task flows with one or more task nodes to orchestrate and schedule complex data development workflows. |
Solutions
| Feature | Description |
|---|---|
| Data archiving | Archive data from large tables to other databases on a schedule, then delete the data from source tables and free up tablespace storage. |
| Create data warehouses | Set up real-time data synchronization to an AnalyticDB for MySQL database within seconds using one-click data warehousing. |
| Database migration | Create a migration ticket, run pre-migration checks, and remove the source database after migration completes. |
O&M management
| Feature | Description |
|---|---|
| Notification | Set up notification rules to subscribe to feature events and route alerts to the right recipients. |
| User management | Add, view, and modify DMS users. |
| Configuration management | View and update system configurations, and review the history of configuration changes. |
| Database grouping | Apply data changes or schema designs to all databases in a group at once. |
| Manage tasks | Create, start, and stop tasks. |
| Intelligent O&M | View tenant-wide statistics covering tickets, queries, users, and metadata. |
What's next
After completing the initial setup, configure the following to secure and streamline your DMS environment:
-
Security rules and approval processes — Define which SQL operations require approval and who approves them.
-
Access IP whitelist — Restrict DMS access to trusted networks.
-
Notification rules — Subscribe to key events such as ticket submissions and approvals.
-
Sensitive data management — Identify and protect sensitive fields across your databases.