Topik ini menjelaskan item fungsi yang didukung oleh berbagai sumber data.
✅ menunjukkan didukung, sedangkan spasi kosong menunjukkan tidak didukung.
Jenis sumber data | Sumber data | Fitur yang didukung | |||||||||
Init SQL | Unggah file | Minggu kustom | Pernyataan HINT | Percepatan Ekstraksi Mesin Cepat | Persiapan data | Entri data | Entri tabel kompleks | Fungsi bawaan sistem | Tabel analisis tren/multidimensi (rata-rata/kumulatif) | ||
Sumber data mandiri | MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
MariaDB | ✅ | ✅ | ✅ | ||||||||
Oracle | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
ClickHouse | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
Presto | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Hive | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Impala (EMR tidak didukung) | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Spark SQL | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
Hbase | |||||||||||
MongoDB | ✅ | ✅ | ✅ | ||||||||
Apache Doris | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
StarRocks | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
SelectDB | ✅ | ✅ | ✅ | ||||||||
Elasticsearch | |||||||||||
SAP HANA | ✅ | ✅ | |||||||||
SAP IQ (Sybase IQ) | |||||||||||
IBM DB2 LUW | |||||||||||
Vertica | |||||||||||
Kingbase | |||||||||||
Gbase 8a | ✅ | ||||||||||
Snowflake | |||||||||||
Kylin | |||||||||||
TiDB | ✅ | ✅ (Fungsi BI_MID tidak didukung) | ✅ | ||||||||
Dameng | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Shentong | ✅ | ||||||||||
Greenplum | ✅ | ✅ | ✅ | ✅ | |||||||
Sumber data Alibaba Cloud | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for MariaDB | ✅ | ✅ | ✅ | ||||||||
MaxCompute | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
Hologres | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
ClickHouse | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
AnalyticDB for MySQL 2.0 | ✅ | ✅ | |||||||||
AnalyticDB for MySQL 3.0 | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ||
AnalyticDB for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ||||
PolarDB for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
PolarDB for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ||||
PolarDB for PostgreSQL (Kompatibel dengan Oracle) | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
PolarDB-X | ✅ | ✅ | ✅ | ✅ | |||||||
Lindorm | |||||||||||
OceanBase | ✅ | ||||||||||
E-MapReduce Serverless StarRocks | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
Layanan Log Sederhana | |||||||||||
Elasticsearch | |||||||||||
SelectDB | ✅ | ✅ | |||||||||
E-MapReduce Serverless Spark | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
Sumber data AWS | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Aurora MySQL | ✅ | ✅ | ✅ | ✅ | |||||||
Aurora PostgreSQL | ✅ | ✅ | ✅ | ✅ | |||||||
Redshift | ✅ | ||||||||||
Databricks | ✅ | ✅ | ✅ | ✅ | |||||||
Amazon Athena | ✅ | ✅ | |||||||||
Sumber data Huawei Cloud | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
GaussDB | ✅ | ||||||||||
GaussDB (DWS) | ✅ | ||||||||||
Sumber data Tencent Cloud | TencentDB for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
TencentDB for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
TDSQL-H LibraDB | ✅ | ||||||||||
Sumber data Microsoft Cloud | Azure Database for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
Azure Database for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Azure Database for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Databricks | ✅ | ✅ | ✅ | ✅ | |||||||
Sumber data aplikasi | Dataphin | ✅ (untuk koneksi JDBC) | ✅ | ✅ | ✅ | ||||||
DMS | ✅ | ✅ | |||||||||