This article details the operations supported by various data source types.
Limitations
NoteBook analysis tasks are not supported for Dataphin tables that use the GaussDB computing engine.
Data source type | View DDL statement | Data preview / data sampling | Data profiling | NoteBook analysis | 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 metastore, HMS metadata) | Yes | Yes | No | No | Yes |
StarRocks | Yes | Yes | No | Yes | Yes |
Hologres | Yes | Yes | No | Yes | No |
Greenplum | Yes | Yes | No | No | No |
OceanBase (MySQL tenant mode) | Yes | No | No | Yes | No |
OceanBase (Oracle tenant mode) | 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 |
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 |
TDSQL for PostgreSQL | Yes | Yes | Yes | Yes | No |