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-X, 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 TX 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 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-X) PolarDB-X 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 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 service ✔️ ✔️ ✔️ ✔️ ✔️ ❌ ✔️ ✔️ ✔️ ✔️ ✔️
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 service ✔️ ✔️ ✔️ ❌ ✔️ ✔️ ❌
Data visualization ✔️ ✔️ ✔️ ❌ ✔️ ✔️ ❌
Task orchestration ✔️ ✔️ ✔️ ❌ ✔️ ✔️ ✔️
Data warehouse development ✔️ ✔️ ✔️ ❌ ❌ ❌ ❌
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ❌
Security rule ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ❌
Approval process ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ❌