Document Center
Data Management Service (DMS)
Release Notes
Quick Start
Manage permissions
Register an ApsaraDB instance
Manage a database on the SQLConsole tab
Query and change a schema
Export data
Import data
Authorize DMS to access Alibaba Cloud resources
Share the SQLConsole tab or a ticket
Customize the top navigation bar of the DMS console
Switch between the previous and new versions of the DMS console
Product Introduction
Overview
Benefits
Supported database types and features
Features
Control modes
User Role
System roles
Resource roles
Common user
Security administrator
Database administrator
DMS administrator
Permissions of system roles
View owned system roles
Glossary
Routing algorithm
Logical database
Logical table
Field security level
Metadata
Data owner
Security rule
Pricing
Pricing
Stop using a pay-as-you-go control mode
Service renewal
Service specification upgrade
Solution
Overview
Make preparations
Solutions for R&D processes
Design schemas
Change data
Generate test data
Change schemas without locking tables
Change data without the need to lock tables
Audit operations
Customize usage rules for the SQLConsole
Approve tickets
Data security solutions
Manage permissions
Manage sensitive data
Enforce row-level access control
Perform access control
Customize approval processes for permission applications
Data development solutions
Task orchestration
Data service
Data visualization
Data Assets
Use the category feature
Manage DMS tenants
Configure personal information and notification methods
Send notifications by using a custom webhook URL
Instance Management
Instance management
Instance List
Register an ApsaraDB instance
Register a user-built instance hosted on ECS
Record user-created databases in IDC to DMS
Register a user-built database in an on-premises data center
Register a user-built database in an on-premises data center by using a public endpoint
Register a user-built database in an on-premises data center by using an Express Connect circuit
Register a user-built database in an on-premises data center by using a VPN gateway
register_third-party_cloud_databases
Register a database in a third-party cloud by using a public endpoint
Register a database in a third-party cloud by using a database gateway
Register a database in a third-party cloud by using a VPN gateway
egister a database in a third-party cloud by using a CEN
Log on to a database
Manage databases
Database list
Account permission management
Manage user permissions on MySQL databases
Manage user permissions on MongoDB databases
Manage user permissions on PostgreSQL databases
Generate a risk audit report
Modify an instance
Synchronize the data dictionary for an instance
Enable or disable an instance
View the control mode
Configure the control mode of an instance
Remove database instances
Export instance configurations
Change the environment type of an instance
Manage permissions on instances
Configure an IP address whitelist
Enable metadata access control
SQLConsole
Overview
Cmd Tab
Super SQL mode
SQL diagnosis
Manage schema versions
Adjust field security levels
Table details
Manage table details
Quality rules
Cross-database query
Syntax support for Redis
Syntax support for MongoDB
Database Development
Overview of data plans
Schema Change
Schema design
Design schemas
Resolve metadata inconsistency during schema design
Synchronize schemas
Synchronize shadow tables
Initialize empty databases
Repair table consistency
Data change
Change regular data
Lockless change
Overview
DML-based lockless change
DDL-based lockless change
Appendix to DDL-based lockless change
Advantages of DDL-based lockless change
Enable the Open (DMS OnlineDDL first) feature
Defragment spaces
Clear historical data
Use stored routines to change data
Import data
Data export
Export SQL result sets
Export databases
SQL review
Database clone
Generate test data
Data tracking
DevOps
Manage projects
Manage iterations
Manage iteration templates
Logical databases and logical tables
Logical database
Logical table
Change the schema of a logical table
Query a logical table
Configure a routing algorithm
DTS
Quick Start
Use the task orchestration feature to schedule events
Develop a data warehouse based on AnalyticDB for PostgreSQL
Generate daily, weekly, and monthly reports in DMS
Synchronize data and generate T+1 reports in DMS
Use DBS to periodically back up data and restore data in DMS
Regularly back up data from relational databases to OSS in DMS
Migrate historical data to a database that uses X-Engine in DMS
Use the task orchestration feature of DMS to train a machine learning model
Overview of data migration scenarios
Data Integration
What is ETL?
Task orchestration
Overview
Create a script task
Configure a conditional branch node
Configure SQL assignment nodes
Variables
Task node types
Publish a task flow
Use the task orchestration feature for e-commerce tagging
Task Orchestration (Old)
Configure a task flow
Configure variables
Publish or unpublish a task flow
Operations management
Basic concepts
Task node types
Data Warehouse
Terms
Warehouse project
Data Warehouse Developer overview
Data warehouse table
Task flow
Data services
Best practices of data warehouse development
Data API
Overview
Terms
Develop an API
Publish an API operation
Test an API operation
Call an API operation
Data Visualization
Overview
Terms
Access the data visualization feature
Manage datasets
Manage charts
Manage dashboards
Manage big screens
Appendix - Charts
Security and Specifications
Sensitive data management
Permission management
View owned permissions
Security rule
Create and apply security rules
Configurations of security rules
DSL syntax for security rules
SQLConsole for relational databases
SQLConsole for MongoDB
SQL Console for Redis
SQL Correct
Permission application
Data Export
Schema Design
Synchronize databases and tables
Data Tracking
Sensitive Column Change
Test Data Generate
Database Clone
SQL review optimization
Configure approval processes
Access IP whitelist
Audit operations
Data security protection
Enable the data security protection feature
Authorize a user to access a database instance by using proxy endpoints
Apply for the permissions to access a database instance by using proxy endpoints
Access an instance over the MySQL protocol
Access an instance over the HTTPS protocol
Sensitive data management
Overview
Enable the sensitive data protection feature
Manage sensitive data
Manage sensitive data detection rules
Create a data de-identification rule
Row-level Control
Solution
Data archiving
Data analysis
Operations Management
Manage users
Manage tasks
Manage configurations
Add digital watermarks
Manage notification rules
Database grouping
Metadata access control
Intelligent operation
Database Lab
Overview of DMS Database Lab
FAQ
Connect to a database by using an application
Best Practices
Prepare for large-scale events
Use the SQL review optimization feature
Use the SQL review feature
Manage permissions
Use the schema design feature of DMS to publish schemas
Use AnalyticDB for MySQL and DMS to generate reports on a regular basis
Customize approval processes
Use data development to archive data
Report analysis
Periodically migrate data
Schema design specifications Guarantee the existence of fields
Use SSO to log on to DMS
Register a database instance that is accessible to multiple Alibaba Cloud accounts
Use the one-click data warehouse feature of DLA to develop data in DMS
Change schemas without locking tables
Api-Reference
List of operations by function
Use the API
Common parameters
Signature method
Returned result
User management
RegisterUser
DisableUser
EnableUser
UpdateUser
DeleteUser
ListUsers
ListUserTenants
GetUserActiveTenant
GetUser
Instance management
RegisterInstance
ListInstances
GetInstance
UpdateInstance
DeleteInstance
Operation logs
GetOpLog
Approval process
ListWorkFlowNodes
ListWorkFlowTemplates
Database and table metadata
SearchDatabase
SearchTable
ListDatabases
ListLogicDatabases
ListTables
ListLogicTables
ListColumns
ListIndexes
GetDatabase
GetPhysicalDatabase
GetLogicDatabase
GetDBTopology
GetTableTopology
GetTableDBTopology
GetMetaTableDetailInfo
GetMetaTableColumn
SyncInstanceMeta
SyncDatabaseMeta
Tickets
General-purpose
ListOrders
CreateOrder
ApproveOrder
GetOrderBaseInfo
SubmitOrderApproval
GetApprovalDetail
CloseOrder
Apply for permissions on a logical table
GetOwnerApplyOrderDetail
GetPermApplyOrderDetail
Synchronization between tables and databases
CreateStructSyncOrder
GetStructSyncOrderDetail
GetStructSyncJobDetail
GetStructSyncJobAnalyzeResult
GetStructSyncExecSqlDetail
SubmitStructSyncOrderApproval
ExecuteStructSync
Change data
CreateDataCorrectOrder
CreateDataCronClearOrder
CreateDataImportOrder
CreateFreeLockCorrectOrder
ExecuteDataCorrect
GetDataCorrectTaskDetail
GetDataCronClearTaskDetailList
GetDataCorrectBackupFiles
GetDataCorrectOrderDetail
GetDataCorrectSQLFile
ListDataCorrectPreCheckSQL
ListDataCorrectPreCheckDB
Design schemas
CreatePublishGroupTask
ListDDLPublishRecords
The data export tasks
GetDataExportOrderDetail
GetDataExportDownloadURL
ExecuteDataExport
SQL review
CreateSQLReviewOrder
GetSQLReviewCheckResultStatus
ListSQLReviewOriginSQL
GetSQLReviewOptimizeDetail
Attachment Upload
CreateUploadFileJob
CreateUploadOSSFileJob
GetUserUploadFileJob
SQL tasks
ListDBTaskSQLJob
ListDBTaskSQLJobDetail
Manage permissions
GrantUserPermission
RevokeUserPermission
SetOwners
ListDatabaseUserPermssions
ListUserPermissions
Security management
Data security protection
CreateProxy
CreateProxyAccess
ListProxyAccesses
InspectProxyAccessSecret
ListProxies
GetProxy
DeleteProxyAccess
DeleteProxy
ListSensitiveColumns
ListSensitiveColumnsDetail
Query data
ExecuteScript
Appendixes
DbType parameter
RegionID parameter
Videos
Database Security Data Masking in DMS
FAQ
all-products-head
This Product
This Product
All Products
All Products
Show more
Show less