Different collection source types support different operations, such as viewing DDL statements, data preview, data sampling, data exploration, NoteBook analysis, and Quick BI consumption.
Limits
NoteBook analysis tasks are not supported when the data table is a Dataphin table and the compute engine 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 |
Yes |
|
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 |