Quick BI mendukung sumber data cloud dan sumber data yang dibuat pengguna.
Sumber data yang didukung
-
Sumber data database
Tabel berikut mencantumkan versi database yang didukung beserta metode koneksi.
berarti didukung, dan 
berarti tidak didukung.
|
Data source |
Data source type |
Supported versions |
Connection methods |
|||||
|
Public connection |
VPC connection |
VPC regions |
Password required |
SSH support |
SSL support |
|||
|
MySQL |
Alibaba Cloud |
5.5, 5.6, 5.7, 8.0 |
|
|
All regions |
|
|
|
|
Tencent Cloud |
5.5, 5.6, 5.7, 8.0 |
|
|
N/A |
|
|
|
|
|
Huawei Cloud |
5.5, 5.6, 5.7, 8.0 |
|
|
N/A |
|
|
|
|
|
Microsoft Azure |
5.5, 5.6, 5.7, 8.0 |
|
|
N/A |
|
|
|
|
|
AWS |
5.5, 5.6, 5.7, 8.0 |
|
|
N/A |
|
|
|
|
|
Self-hosted |
5.5, 5.6, 5.7, 8.0 |
|
|
All regions |
|
|
|
|
|
MySQL DuckDB |
Alibaba Cloud |
5.7, 8.0 |
|
|
All regions |
|
|
|
|
MaxCompute |
Alibaba Cloud |
1.0, 2.0 |
|
|
N/A |
|
|
|
|
AnalyticDB for MySQL |
Alibaba Cloud |
3.0 |
|
|
Central region only |
|
|
|
|
Alibaba Cloud |
2.0 |
|
|
N/A |
|
|
|
|
|
SQL Server |
Alibaba Cloud |
2008-2022 |
|
|
All regions |
|
|
|
|
Tencent Cloud |
2008-2022 |
|
|
N/A |
|
|
|
|
|
Huawei Cloud |
2008-2022 |
|
|
N/A |
|
|
|
|
|
Microsoft Azure |
2008-2022 |
|
|
N/A |
|
|
|
|
|
AWS |
2008-2022 |
|
|
N/A |
|
|
|
|
|
Self-hosted |
2008-2022 |
|
|
All regions |
|
|
|
|
|
PostgreSQL |
Alibaba Cloud |
8.2 and later |
|
|
Central region only |
|
|
|
|
Tencent Cloud |
8.2 and later |
|
|
N/A |
|
|
|
|
|
Huawei Cloud |
8.2 and later |
|
|
N/A |
|
|
|
|
|
Microsoft Azure |
8.2 and later |
|
|
N/A |
|
|
|
|
|
AWS |
8.2 and later |
|
|
N/A |
|
|
|
|
|
Self-hosted |
8.2 and later |
|
|
All regions |
|
|
|
|
|
Hologres |
Alibaba Cloud |
data warehouse edition |
|
|
All regions |
|
|
|
|
ClickHouse |
Alibaba Cloud |
20.3, 22.8 |
|
|
All regions |
|
|
|
|
Self-hosted |
20.3, 22.8 |
|
|
All regions |
|
|
|
|
|
AnalyticDB for PostgreSQL |
Alibaba Cloud |
6.0, 4.3 |
|
|
All regions |
|
|
|
|
Presto |
/ |
PrestoDB 0.219, Trino 354 and later |
|
|
All regions |
|
|
|
|
Data Lake Analytics |
Alibaba Cloud |
|
|
N/A |
|
|
|
|
|
PolarDB for MySQL |
Alibaba Cloud |
5.6, 5.7, 8.0.1, 8.0.2 |
|
|
Central region only |
|
|
|
|
Oracle |
Alibaba Cloud |
11.0 |
|
|
All regions |
|
|
|
|
Hive |
/ |
Apache Hive 2.0.1-2.3.3 |
|
|
N/A |
|
|
|
|
Object Storage Service (OSS) |
Alibaba Cloud |
|
|
N/A |
|
|
|
|
|
PolarDB-X |
Alibaba Cloud |
1.0, 2.0 |
|
|
All regions |
|
|
|
|
PolarDB for PostgreSQL |
Alibaba Cloud |
11.0, 14.0 |
|
|
Central region only |
|
|
|
|
SAP HANA |
Self-hosted |
2.0 |
|
|
All regions |
|
|
|
|
PolarDB for Oracle |
Alibaba Cloud |
1.0, 2.0 |
|
|
All regions |
|
|
|
|
Lindorm |
Alibaba Cloud |
|
|
All regions |
|
|
|
|
|
IBM DB2 LUW |
Self-hosted |
v10.5.3, v11.1.4.4 |
|
|
All regions |
|
|
|
|
Vertica |
Self-hosted |
v9.2.0-7, v24.1.0-0 |
|
|
All regions |
|
|
|
|
OceanBase |
Alibaba Cloud |
4.2.1.3, 4.3 |
|
|
N/A |
|
|
|
|
SAP IQ (Sybase IQ) |
Self-hosted |
16.1.030.1031/10645 |
|
|
All regions |
|
|
|
|
Kingbase |
Self-hosted |
7.1.2 |
|
|
All regions |
|
|
|
|
Gbase 8a |
Self-hosted |
8.6, 9.5 |
|
|
All regions |
|
|
|
|
Impala |
Self-hosted |
2.10.0, 3.4.0 |
|
|
All regions |
|
|
|
|
Snowflake |
Self-hosted |
|
|
All regions |
|
|
|
|
|
Kylin |
Self-hosted |
3.0 |
|
|
All regions |
|
|
|
|
Spark SQL |
Self-hosted |
3.1.2 |
|
|
All regions |
|
|
|
|
Alibaba Cloud |
3.1.2 |
|
|
N/A |
|
|
|
|
|
MongoDB |
Self-hosted |
5.0 |
|
|
All regions |
|
|
|
|
Apache Doris |
Self-hosted |
1.2.4 |
|
|
All regions |
|
|
|
|
Dameng |
Self-hosted |
7.0, 8.0 |
|
|
All regions |
|
|
|
|
StarRocks |
Alibaba Cloud |
2.5.18, 3.1.7, 3.1.9, 3.2.6 |
|
|
All regions |
|
|
|
|
Self-hosted |
2.5.18, 3.1.7, 3.1.9, 3.2.6 |
|
|
All regions |
|
|
|
|
|
SelectDB |
Self-hosted |
|
|
All regions |
|
|
|
|
|
Alibaba Cloud |
|
|
All regions |
|
|
|
||
|
Log Service (SLS) |
Alibaba Cloud |
|
|
N/A |
|
|
|
|
|
Huawei GaussDB |
Huawei Cloud |
|
|
N/A |
|
|
|
|
|
Huawei GaussDB (DWS) |
Huawei Cloud |
|
|
N/A |
|
|
|
|
|
Elasticsearch |
Alibaba Cloud |
7.8.1 or later; requires X-Pack plugin (Platinum Edition) |
|
|
N/A |
|
|
|
|
Self-hosted |
7.8.1 or later; requires X-Pack plugin (Platinum Edition) |
|
|
N/A |
|
|
|
|
|
TDSQL-H LibraDB |
Tencent Cloud |
|
|
N/A |
|
|
|
|
|
TiDB |
Self-hosted |
7.1.3 |
|
|
N/A |
|
|
|
|
MariaDB |
Alibaba Cloud |
10.3 |
|
|
All regions |
|
|
|
|
Self-hosted |
10.3 |
|
|
N/A |
|
|
|
|
|
Shentong Database |
Self-hosted |
8.0 |
|
|
N/A |
|
|
|
|
Greenplum |
Self-hosted |
6.10.0 |
|
|
All regions |
|
|
|
|
Aurora MySQL |
AWS |
2.11.5, 3.05.2 |
|
|
N/A |
|
|
|
|
Aurora PostgreSQL |
AWS |
15.4 |
|
|
N/A |
|
|
|
|
Amazon Redshift |
AWS |
|
|
N/A |
|
|
|
|
|
Databricks |
AWS |
|
|
N/A |
|
|
|
|
|
Microsoft Azure |
|
|
N/A |
|
|
|
||
|
Amazon Athena |
AWS |
|
|
N/A |
|
|
|
|
-
Sumber data file
Unggah file lokal ke database untuk digunakan sebagai sumber data. Database yang didukung tercantum dalam Fitur sumber data.
-
Sumber data aplikasi
-
Dataphin (Edisi Profesional)
-
DMS
-
-
Sumber data API
Ambil data bisnis dari sistem eksternal melalui API. Fitur ini memerlukan Edisi Profesional.
Persyaratan jaringan sumber data
Saat menambahkan sumber data, pastikan jaringan Anda memenuhi persyaratan berikut:
-
Instans ApsaraDB RDS di VPC dapat mengakses Quick BI melalui nama domain publik. Hanya instans MySQL dan SQL Server yang mendukung nama domain internal.
-
Instans ApsaraDB RDS di jaringan klasik dapat mengakses Quick BI melalui nama domain publik atau internal. Akses melalui nama domain publik memerlukan daftar putih alamat IP untuk instans tersebut. Konfigurasikan daftar putih.
-
Quick BI dapat diakses melalui jaringan publik.
-
Database MySQL atau SQL Server yang di-host sendiri pada instans ECS berbasis VPC dapat mengakses Quick BI melalui nama domain internal.
Topik terkait
Operasi sumber data: