All Products
Search
Document Center

administrator manual

Last Updated: Jun 28, 2020

Operations

  1. Register a database as an instance in the Data Management Service (DMS) console. For more information, see Instance management.
  2. Add owners of Alibaba Cloud accounts or RAM users under the current Alibaba Cloud account as DMS users and assign roles to DMS users as needed. If you add RAM users as DMS users but do not assign roles to them, these users are common users by default. For more information, see User management.
  3. Grant a user the permissions on a database or table. For more information, see Permission management.

Supported features for DMS administrators

Category Feature Description
System management Instance management
You can manage instances. For example, you can register, view, and edit instances.
User management You can manage users as needed. For example, you can add, view, and edit users.
Task management You can manage tasks. For example, you can create, start, and stop tasks.
Configuration management You can view and edit configurations, and view the change history of configurations.
Intelligent operation You can view the statistics on tickets, queries, users, and metadata.
Security management Security rules You can configure security rules on the Security Rules page. Before DMS executes SQL statements, it validates the statements based on the security rules.
Approval processes Approval processes are associated with security rules specified for data operations. You can apply different approval processes on different data operations.
Operations logs DMS records data changes in operations logs so that you can trace data operations, execution time, and operation accounts at any time.
IP address whitelist You can set an IP address whitelist to prevent IP addresses not included in the whitelist from accessing your databases. This enhances database security.
Sensitive data management You can manage sensitive data in tables. For example, you can use algorithms to de-identify sensitive data or adjust security levels of sensitive data.
Permissions Permission management You can apply for permissions on instances, databases, tables, and sensitive fields. You can also view permissions that you have.
SQLConsol Single-database queries You can write SQL statements to query data in a single database. This feature can be used to verify business code, analyze product effect, and locate issues in an online environment.
Cross-database queries You can perform relational queries across online heterogeneous data sources deployed in different environments.
Schemas Schema design When you develop or optimize a project or process a new business requirement, you often need to change schemas. For example, you can use this feature when you create a table or modify an existing table.
Table synchronization You can use this feature to compare and synchronize the schemas of tables located in different environments, such as online and offline environments, to guarantee the consistency of schemas.
Optimization SQL review You can use this feature to avoid publishing SQL statements that do not use indexes or do not conform to database development standards. This feature helps protect against SQL injection attacks.
Data plans Data changes You can submit data change tickets to initialize data for a newly published project, clean up historical data, fix bugs, or conduct a test.
Data import You can use this feature to import a large amount of data to your databases at a time.
Data export You can use this feature to extract a large amount of data for analysis.
Data tracking If any data fails to meet your requirement due to reasons such as misoperations, you can use this feature to quickly trace historical data changes. Then, you can execute rollback statements to quickly restore data to the normal state.
Test data generation You can generate test data to guarantee data security and discreteness and improve production efficiency when you need to prepare data frequently.
Data warehouse development DMS uses databases as the main computing engine and integrates various tools and services in the database ecosystem, such as Data Transmission Service (DTS) and Data Lake Analytics (DLA), for data warehouse development. Therefore, you can easily develop and manage data warehouses in DMS.
Data service You can use this feature to export data at the field or row level, display data in a visualized manner, and publish data in Alibaba Cloud Marketplace for sale through API calls.
Database clone This feature allows you to clone MySQL databases.