This topic describes the features that are supported for Data Management (DMS) administrators.
Operations in the DMS console
- Log on to the DMS console. Add a database instance to DMS. For more information, see Instance management.
- Go to the User page. On this page, add Alibaba Cloud accounts or RAM users as DMS users, and assign roles to them as needed. If you do not assign a role to a DMS user, the user automatically assumes the common user role. For more information, see User management.
- Grant permissions on databases and tables to users. For more information, see Permission management.
Features that are supported for DMS administrators
|System management||Instance management||You can manage instances, for example, add, view, or edit an instance.|
|User management||You can manage the users under your DMS tenant, for example, add, view, or edit a user.|
|Task management||You can manage tasks, for example, create, start, or stop a task.|
|Configuration management||You can view and modify system configurations, or view historical modifications of the configurations.|
|Intelligent operation||You can use this feature to view overall information about your DMS tenant, such as statistics about tickets, queries, users, and metadata.|
|Security management||Security rules||After you configure security rules, only SQL statements that conform to the rules can be properly executed.|
|Approval processes||Approval processes are associated with security rules. You can configure different approval processes for different types of tickets.|
|Operations logs||Operations logs record data changes. Each record contains information such as the user, specific operation, and time at which the operation was complete. You can trace historical user operations at any time.|
|Access IP whitelists||After you configure an access IP whitelist, only the IP addresses or Classless Inter-Domain Routing (CIDR) blocks in the whitelist can access the resources under your DMS tenant. This effectively enhances data security.|
|Sensitive data management||You can use this feature to manage sensitive data, for example, adjust the security levels of fields or configure data de-identification or masking for sensitive and confidential fields.|
|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 query||You can write SQL statements to query data in a single database. This feature can be used to verify business code, analyze product effects, and identify issues in an online environment.|
|Cross-database query||You can perform join queries across online heterogeneous data sources that are 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.|
|Database and table synchronization||You can use this feature to compare and synchronize the schemas of tables that are stored in different environments, such as online and offline environments. This feature helps ensure 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 run a test.|
|Data import||You can submit data import tickets to import a large amount of data to your databases at a time.|
|Data export||You can submit data export tickets to extract a large amount of data for analysis.|
|Data tracking||If specific data fails to meet your requirement due to reasons such as misoperation, you can use this feature to trace historical data changes. Then, you can execute rollback statements to restore data to the normal state.|
|Test data generation||Some business scenarios may require you to frequently prepare data. In this case, you can generate test data to ensure data security and discreteness and improve production efficiency.|
|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 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 API operations to Alibaba Cloud Marketplace for sale.|
|Database cloning||You can use this feature to clone MySQL databases.|
|Tickets||Ticket management||You can use this feature to configure notifications about the approval or execution status of tickets. This way, DMS can send you notifications by DingTalk or email.|