This topic describes the operations supported by different collection sources.
Limits
NoteBook analysis tasks are not supported when the data table is from Dataphin and the compute engine used is GaussDB.
Data source type | Supports viewing DDL statements | Supports data preview/data sampling | Supports data exploration | Supports NoteBook analysis | Supports Quick BI consumption |
MySQL | Yes | Yes | Yes | Yes | Yes |
Amazon RDS for MySQL | Yes | No | No | No | No |
Oracle | Yes | Yes | Yes | Yes | Yes |
Amazon RDS for Oracle | Yes | No | No | No | No |
PostgreSQL | Yes | Yes | Yes | Yes | No |
Amazon RDS for PostgreSQL | Yes | No | No | No | No |
Microsoft SQL Server | Yes | Yes | Yes | Yes | No |
Amazon RDS for SQL Server | Yes | No | No | No | No |
AnalyticDB for MySQL 3.0 | Yes | Yes | No | Yes | No |
PolarDB-X (formerly DRDS) | Yes | No | No | No | No |
SAP HANA | Yes | No | No | No | No |
IBM DB2 | No | No | No | No | No |
Amazon RDS for DB2 | No | No | No | No | No |
Hive (MySQL metadatabase, HMS metadata) | Yes | Yes | No | No | Yes |
StarRocks | Yes | Yes | No | Yes | No |
Hologres | Yes | Yes | No | Yes | No |
GreenPlum | Yes | Yes | No | No | No |
OceanBase (MySQL tenant pattern) | Yes | No | No | Yes | No |
OceanBase (Oracle tenant pattern) | Yes | No | No | Yes | No |
ClickHouse | No | Yes | No | Yes | No |
Amazon Redshift | Yes | No | No | No | No |
SelectDB | Yes | Yes | No | Yes | No |
Doris | Yes | Yes | No | Yes | Yes |
Dameng (DM) | Yes | Yes | No | Yes | No |
DolphinDB | No | No | No | No | No |
openGauss | Yes | Yes | No | Yes | No |
TDSQL for MySQL | Yes | Yes | Yes | No | No |