This article lists the operations supported by different data source types.
Limitations
Notebook analysis is not supported for Dataphin tables when GaussDB is the compute engine.
|
Data source type |
DDL statements |
Data preview / data sampling |
Data profile |
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 metadata database, HMS metadata) |
Yes |
Yes |
No |
No |
Yes |
|
Hive (Amazon Glue metadata) |
Yes |
Yes |
No |
No |
No |
|
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 (Dameng) |
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 |