Supported database types and features - Data Management - Alibaba Cloud Documentation Center

This topic describes the database types that are supported by Data Management (DMS) and the DMS features that are supported by each database type.

Supported database types

Relational databases:
- MySQL: ApsaraDB RDS for MySQL, PolarDB for MySQL, MyBase for MySQL, PolarDB for Xscale, and MySQL databases from other sources
- SQL Server: ApsaraDB RDS for SQL Server, MyBase for SQL Server, and SQL Server databases from other sources
- PostgreSQL: ApsaraDB RDS for PostgreSQL, PolarDB for PostgreSQL, MyBase for PostgreSQL, and PostgreSQL databases from other sources
- MariaDB: ApsaraDB for MariaDB and MariaDB databases from other sources
- OceanBase: ApsaraDB for OceanBase in MySQL mode, ApsaraDB for OceanBase in Oracle mode, and self-managed OceanBase databases
- PolarDB for PostgreSQL(Compatible with Oracle)
- Self-managed Oracle
- DamengDB
- IBM Db2
NoSQL databases:
- Redis: ApsaraDB for Redis, MyBase for Redis, and Redis databases from other sources
- MongoDB: ApsaraDB for MongoDB and MongoDB databases from other sources
  Note
  ApsaraDB for MongoDB of Serverless Edition is not supported.
- ApsaraDB for Lindorm
- ApsaraDB for Cassandra
- Graph Database
Data warehouses, Hologres, and OSS:
- AnalyticDB for MySQL
- AnalyticDB for PostgreSQL
- Data Lake Analytics
- ClickHouse: ApsaraDB for ClickHouse and ClickHouse databases from other sources
- MaxCompute
- Hologres
- Object Storage Service

Note

Databases from other sources refer to databases from other cloud service providers or self-managed databases.

Symbol description

This section describes the symbols that are used in the tables of this topic:

️✔️ indicates that the feature is supported.
➖ indicates that the feature will be supported soon.
❌ indicates that the feature is not supported.

Relational databases

The following table describes the features that are supported by relational databases.

Feature	MySQL (except PolarDB for Xscale)	PolarDB for Xscale	SQL Server	PostgreSQL (except PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB OceanBase for MySQL	Self-managed Oracle and ApsaraDB OceanBase for Oracle	PolarDB for PostgreSQL(Compatible with Oracle)	DM	Db2
Query	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Query on logical databases or tables	✔️	❌	✔️	✔️	✔️	➖	✔️	✔️	✔️	❌	✔️
Cross-database query	✔️	✔️	✔️	✔️	✔️	❌	❌	❌	✔️	❌	❌
SQL result set export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Table data export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️
Data change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Historical data cleaning	✔️	✔️	❌	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌
Lockless data change	✔️	✔️	❌	✔️	✔️	✔️	✔️	❌	✔️	❌	❌
Data import	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	❌
Test data generation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	❌	❌
Data tracking	✔️	➖	❌	❌	❌	➖	❌	❌	➖	❌	❌
Database cloning	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌	❌
Schema change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	❌	❌
Visualized schema modification	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	✔️	❌	❌
Schema synchronization	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌	❌
Empty database initialization	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌	❌
Programmable object	✔️	❌	✔️	✔️	✔️	✔️	❌	❌	✔️	❌	❌
Schema export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Schema design pro	✔️	✔️	❌	❌	➖	➖	✔️	❌	➖	❌	❌
Lock-free schema change	✔️	➖	❌	❌	❌	➖	❌	❌	❌	❌	❌
Database creation	✔️	❌	❌	➖	❌	✔️	❌	❌	❌	❌	❌
Database user creation	✔️	❌	❌	➖	❌	✔️	❌	❌	❌	❌	❌
SQL review	✔️	➖	❌	✔️	✔️	➖	➖	✔️	✔️	❌	❌
SQL and instance diagnostics	✔️	❌	❌	✔️	✔️	➖	❌	❌	✔️	❌	❌
Sensitive data management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Access control system	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Operation log	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data visualization	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️	✔️
Task orchestration	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️	✔️
Data warehouse development	✔️	✔️	❌	❌	❌	❌	❌	❌	❌	❌	❌
Ticket system	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Security rule	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

NoSQL databases

The following table describes the features that are supported by NoSQL databases.

Feature	MongoDB	Redis	Lindorm	Cassandra	GDB
Query	✔️	✔️	✔️	✔️	✔️
Cross-database query	❌	✔️	❌	❌	❌
SQL result set export	✔️	❌	✔️	✔️	❌
Table data export	❌	❌	➖	➖	❌
Data change	✔️	✔️	✔️	✔️	✔️
Schema change	❌	❌	✔️	✔️	❌
Database creation	✔️	❌	❌	❌	❌
Database user creation	✔️	❌	❌	❌	❌
SQL review	✔️	❌	❌	❌	❌
SQL and instance diagnostics	✔️	✔️	❌	❌	❌
Sensitive data management	❌	❌	✔️	➖	❌
Access control system	✔️	✔️	✔️	✔️	✔️
Operation log	✔️	✔️	✔️	✔️	✔️
Ticket system	✔️	✔️	✔️	✔️	✔️
Security rule	✔️	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️	✔️

Data warehouses, Hologres, and OSS

The following table describes the features that are supported by data warehouses, Hologres, and OSS.

Feature	AnalyticDB for MySQL V2.0	AnalyticDB for MySQL V3.0	AnalyticDB for PostgreSQL	ClickHouse	DLA	MaxCompute and Hologres	OSS
Query	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Query on logical databases or tables	❌	✔️	✔️	❌	❌	❌	❌
Cross-database query	❌	✔️	✔️	❌	❌	❌	❌
SQL result set export	✔️	✔️	✔️	✔️	✔️	✔️	❌
Table data export	❌	✔️	✔️	❌	❌	❌	❌
Data change	✔️	✔️	✔️	✔️	✔️	✔️	❌
Data import	✔️	✔️	✔️	❌	❌	❌	❌
Test data generation	✔️	✔️	✔️	❌	➖	❌	❌
Database cloning	❌	❌	➖	❌	❌	❌	❌
Schema change	❌	✔️	✔️	✔️	✔️	❌	❌
Visualized schema modification	❌	✔️	✔️	❌	➖	❌	❌
Schema synchronization	❌	✔️	➖	❌	❌	❌	❌
Empty database initialization	❌	✔️	➖	❌	❌	❌	❌
Programmable object	❌	❌	✔️	❌	❌	❌	❌
Schema export	✔️	✔️	✔️	❌	✔️	❌	❌
Schema design pro	❌	❌	➖	❌	➖	❌	❌
Database creation	❌	➖	➖	❌	❌	❌	❌
Database user creation	❌	➖	➖	❌	❌	❌	❌
SQL review	❌	➖	➖	❌	❌	❌	❌
Sensitive data management	✔️	✔️	✔️	❌	✔️	✔️	❌
Access control system	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Operation log	✔️	✔️	✔️	✔️	✔️	✔️	❌
Data visualization	✔️	✔️	✔️	❌	✔️	✔️	❌
Task orchestration	✔️	✔️	✔️	❌	✔️	✔️	✔️
Data warehouse development	✔️	✔️	✔️	❌	❌	❌	❌
Ticket system	✔️	✔️	✔️	✔️	✔️	✔️	❌
Security rule	✔️	✔️	✔️	✔️	✔️	✔️	❌
Approval process	✔️	✔️	✔️	✔️	✔️	✔️	❌