Semua sumber data di Quick BI mendukung alur kerja analisis data inti, memungkinkan Anda memodelkan set data, membuat dasbor, spreadsheet, dan dasbor data, melakukan analisis ad hoc serta pengambilan data self-service, serta memanfaatkan fitur cerdas seperti Q&A cerdas, laporan, dan interpretasi. Tabel berikut merinci dukungan fitur advanced untuk masing-masing sumber data.
✅ menunjukkan dukungan; sel kosong menunjukkan tidak didukung.
Jenis sumber data | Sumber data | Fitur yang didukung | |||||||||
Initialization SQL | Upload file | Custom week | Hint statement | Quick engine acceleration | Data preparation | Data entry | Complex table entry | Built-in function | Trend / dimensional analysis | ||
Self-hosted data source | MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
MariaDB | ✅ | ✅ | ✅ | ||||||||
Oracle | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
ClickHouse | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
Presto | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Hive | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Impala (EMR not supported) | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Spark SQL | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
HBase | |||||||||||
MongoDB | ✅ | ✅ | ✅ | ||||||||
Apache Doris | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
StarRocks | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
SelectDB | ✅ | ✅ | ✅ | ||||||||
Elasticsearch | ✅ | ||||||||||
SAP HANA | ✅ | ✅ | |||||||||
SAP IQ (Sybase IQ) | ✅ | ||||||||||
IBM Db2 LUW | ✅ | ||||||||||
Vertica | ✅ | ✅ | |||||||||
KingbaseES | |||||||||||
GBase 8a | ✅ | ✅ | |||||||||
Snowflake | |||||||||||
Apache Kylin | |||||||||||
TiDB | ✅ | ✅ | ✅ | ||||||||
DM | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
OSCAR | ✅ | ✅ | |||||||||
Greenplum | ✅ | ✅ | ✅ | ✅ | |||||||
Alibaba Cloud data source | ApsaraDB RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
ApsaraDB RDS for MySQL with DuckDB | ✅ | ✅ (Tidak didukung pada Instansi hanya baca) | ✅ (Tidak didukung pada Instansi hanya baca) | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ||
ApsaraDB RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
ApsaraDB RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
ApsaraDB 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 (Oracle Compatible) | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
PolarDB-X | ✅ | ✅ | ✅ | ✅ | |||||||
Lindorm | ✅ | ||||||||||
OceanBase | ✅ | ||||||||||
Alibaba Cloud EMR Serverless StarRocks | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Log Service | ✅ | ||||||||||
Elasticsearch | |||||||||||
SelectDB | ✅ | ✅ | |||||||||
Alibaba Cloud EMR Serverless Spark | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
AWS data source | Amazon RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
Amazon RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Amazon RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Amazon Aurora MySQL | ✅ | ✅ | ✅ | ✅ | |||||||
Amazon Aurora PostgreSQL | ✅ | ✅ | ✅ | ✅ | |||||||
Amazon Redshift | ✅ | ||||||||||
Databricks | ✅ | ✅ | ✅ | ✅ | |||||||
Amazon Athena | ✅ | ✅ | |||||||||
HUAWEI CLOUD data source | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
GaussDB | |||||||||||
GaussDB(DWS) | ✅ | ||||||||||
Tencent Cloud data source | TencentDB for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
TencentDB for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
TencentDB for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
TDSQL-H LibraDB | ✅ | ||||||||||
Microsoft Azure data source | Azure Database for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
Azure Database for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Azure SQL Database | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Databricks | ✅ | ✅ | ✅ | ✅ | |||||||
Application data source | Dataphin | ✅ (dengan koneksi JDBC) | ✅ | ✅ | ✅ | ||||||
Data Management Service | ✅ | ✅ | |||||||||