Staf IT dan pengembang data menganalisis data dari berbagai sumber. Quick BI mendukung sumber data cloud serta sumber data buatan pengguna. Topik ini menjelaskan sumber data yang didukung oleh Quick BI.
Sumber Data yang Didukung
Sumber data database
Tabel berikut menjelaskan versi database dan metode koneksi yang didukung.
menunjukkan dukungan, sedangkan 
menunjukkan tidak didukung.
Data source | Data source type | Supported database versions | Database connection methods | |||||
Public network connection (add the IP addresses on the interface to the whitelist) | VPC connection (if the connection fails, try adding 100.104.0.0/16 to the whitelist) | Supported regions for VPC | Is password required? | Is SSH supported? | Is SSL supported? | |||
MySQL | Alibaba Cloud | Versions 5.5, 5.6, 5.7, and 8.0 |
|
| All regions |
|
|
|
Tencent Cloud | Versions 5.5, 5.6, 5.7, and 8.0 |
|
| Not applicable |
|
|
| |
Huawei Cloud | Versions 5.5, 5.6, 5.7, and 8.0 |
|
| Not applicable |
|
|
| |
Microsoft Cloud | Versions 5.5, 5.6, 5.7, and 8.0 |
|
| Not applicable |
|
|
| |
AWS | Versions 5.5, 5.6, 5.7, and 8.0 |
|
| Not applicable |
|
|
| |
Self-hosted | Versions 5.5, 5.6, 5.7, and 8.0 |
|
| All regions |
|
|
| |
MySQL DuckDB | Alibaba Cloud | Versions 5.7 and 8.0 |
|
| All regions |
|
|
|
Alibaba MaxCompute | Alibaba Cloud | Versions 1.0 and 2.0 |
|
| Not applicable |
|
|
|
Alibaba AnalyticDB for MySQL | Alibaba Cloud | Version 3.0 |
|
| Only central regions are supported |
|
|
|
Alibaba Cloud | Version 2.0 |
|
| Not applicable |
|
|
| |
SQL Server | Alibaba Cloud | Versions 2008 to 2022 |
|
| All regions |
|
|
|
Tencent Cloud | Versions 2008 to 2022 |
|
| Not applicable |
|
|
| |
Huawei Cloud | Versions 2008 to 2022 |
|
| Not applicable |
|
|
| |
Microsoft Cloud | Versions 2008 to 2022 |
|
| Not applicable |
|
|
| |
AWS | Versions 2008 to 2022 |
|
| Not applicable |
|
|
| |
Self-hosted | Versions 2008 to 2022 |
|
| All regions |
|
|
| |
PostgreSQL | Alibaba Cloud | Version 8.2 and later |
|
| Only central regions are supported |
|
|
|
Tencent Cloud | Version 8.2 and later |
|
| Not applicable |
|
|
| |
Huawei Cloud | Version 8.2 and later |
|
| Not applicable |
|
|
| |
Microsoft Cloud | Version 8.2 and later |
|
| Not applicable |
|
|
| |
AWS | Version 8.2 and later |
|
| Not applicable |
|
|
| |
Self-hosted | Version 8.2 and later |
|
| All regions |
|
|
| |
Alibaba Hologres | Alibaba Cloud | Data warehouse edition |
|
| All regions |
|
|
|
ClickHouse | Alibaba Cloud | Versions 20.3 and 22.8 |
|
| All regions |
|
|
|
Self-hosted | Versions 20.3 and 22.8 |
|
| All regions |
|
|
| |
Alibaba AnalyticDB for PostgreSQL | Alibaba Cloud | Versions 6.0 and 4.3 |
|
| All regions |
|
|
|
Presto | / | prestoDB version 0.219, Trino version 354 and later |
|
| All regions |
|
|
|
Alibaba Data Lake Analytics | Alibaba Cloud |
|
| Not applicable |
|
|
| |
Alibaba PolarDB for MySQL | Alibaba Cloud | Versions 5.6, 5.7, 8.0.1, and 8.0.2 |
|
| Only central regions are supported |
|
|
|
Oracle | Alibaba Cloud | Version 11.0 |
|
| All regions |
|
|
|
Hive | / | Apache Hive versions 2.0.1 to 2.3.3 |
|
| Not applicable |
|
|
|
Alibaba PolarDB distributed edition (DRDS, Alibaba PolarDB-X) | Alibaba Cloud | Versions 1.0 and 2.0 |
|
| All regions |
|
|
|
Alibaba PolarDB for PostgreSQL | Alibaba Cloud | Versions 11.0 and 14.0 |
|
| Only central regions are supported |
|
|
|
SAP HANA | Self-hosted | Version 2.0 |
|
| All regions |
|
|
|
Alibaba PolarDB for Oracle (formerly PPAS) | Alibaba Cloud | Versions 1.0 and 2.0 |
|
| All regions |
|
|
|
Alibaba Lindorm | Alibaba Cloud |
|
| All regions |
|
|
| |
IBM DB2 LUW | Self-hosted | DB2 v10.5.3 and v11.1.4.4 |
|
| All regions |
|
|
|
Vertica | Self-hosted | Vertica Analytic Database v9.2.0-7 and v24.1.0-0 |
|
| All regions |
|
|
|
Alibaba OceanBase | Alibaba Cloud | Versions 4.2.1.3 and 4.3 |
|
| Not applicable |
|
|
|
SAP IQ (Sybase IQ) | Self-hosted | SAP IQ/16.1.030.1031/10645/ |
|
| All regions |
|
|
|
Kingbase | Self-hosted | Version 7.1.2 |
|
| All regions |
|
|
|
Gbase 8a | Self-hosted | Versions 8.6 and 9.5 |
|
| All regions |
|
|
|
Impala | Self-hosted | Versions 2.10.0 and 3.4.0 |
|
| All regions |
|
|
|
Snowflake | Self-hosted |
|
| All regions |
|
|
| |
Kylin | Self-hosted | Version 3.0 |
|
| All regions |
|
|
|
Spark SQL | Self-hosted | Version 3.1.2 |
|
| All regions |
|
|
|
Alibaba Cloud | Version 3.1.2 |
|
| Not applicable |
|
|
| |
MongoDB | Self-hosted | Version 5.0 |
|
| All regions |
|
|
|
Apache Doris | Self-hosted | Version 1.2.4 |
|
| All regions |
|
|
|
Dameng | Self-hosted | Versions 7.0 and 8.0 |
|
| All regions |
|
|
|
StarRocks | Alibaba Cloud | Versions 2.5.18, 3.1.7, 3.1.9, and 3.2.6 |
|
| All regions |
|
|
|
Self-hosted | Versions 2.5.18, 3.1.7, 3.1.9, and 3.2.6 |
|
| All regions |
|
|
| |
SelectDB | Self-hosted |
|
| All regions |
|
|
| |
Alibaba Cloud |
|
| All regions |
|
|
| ||
Alibaba SLS | Alibaba Cloud |
|
| Not applicable |
|
|
| |
Huawei GaussDB | Huawei Cloud |
|
| Not applicable |
|
|
| |
Huawei GaussDB (data warehouse service (DWS)) | Huawei Cloud |
|
| Not applicable |
|
|
| |
Elasticsearch | Alibaba Cloud | Version 7.8.1 and later, and requires the X-Pack plugin (Platinum Edition) |
|
| Not applicable |
|
|
|
Self-hosted | Version 7.8.1 and later, and requires the X-Pack plugin (Platinum Edition) |
|
| Not applicable |
|
|
| |
TDSQL-H LibraDB | Tencent Cloud |
|
| Not applicable |
|
|
| |
TiDB | Self-hosted | Version 7.1.3 |
|
| Not applicable |
|
|
|
MariaDB | Alibaba Cloud | Version 10.3 |
|
| All regions |
|
|
|
Self-hosted | Version 10.3 |
|
| Not applicable |
|
|
| |
Shentong | Self-hosted | Version 8.0 |
|
| Not applicable |
|
|
|
Greenplum | Self-hosted | Version 6.10.0 |
|
| All regions |
|
|
|
Aurora MySQL | AWS | Versions 2.11.5 and 3.05.2 |
|
| Not applicable |
|
|
|
Aurora PostgreSQL | AWS | Version 15.4 |
|
| Not applicable |
|
|
|
Redshift | AWS |
|
| Not applicable |
|
|
| |
Databricks | AWS |
|
| Not applicable |
|
|
| |
Microsoft Cloud |
|
| Not applicable |
|
|
| ||
Amazon Athena | AWS |
|
| Not applicable |
|
|
| |
Sumber data file
Anda dapat mengunggah file lokal ke database dan menggunakannya sebagai sumber data. Untuk daftar database yang mendukung unggahan file, lihat Fitur lanjutan sumber data.
Sumber data aplikasi
Dataphin (Edisi Profesional)
DMS
Sumber data API
Anda dapat menggunakan operasi API untuk mengambil data bisnis dari sistem eksternal. Hanya Edisi Profesional yang mendukung pembuatan sumber data API.
Persyaratan Jaringan untuk Sumber Data
Persyaratan jaringan berikut berlaku saat Anda menambahkan sumber data ke Quick BI:
Instans RDS di VPC dapat mengakses Quick BI melalui titik akhir publik. Namun, akses melalui titik akhir internal dalam satu wilayah hanya didukung untuk instans MySQL dan SQL Server.
Quick BI dapat mengakses instans di jaringan klasik melalui titik akhir publik atau titik akhir internal dalam satu wilayah. Jika menggunakan titik akhir publik, Anda harus mengonfigurasi daftar putih alamat IP untuk instans RDS. Untuk informasi selengkapnya, lihat Setel daftar putih.
Anda dapat mengakses Quick BI melalui Internet.
Anda dapat mengakses Quick BI dari database MySQL dan SQL Server self-hosted pada instans ECS VPC melalui titik akhir internal dalam satu wilayah.
Operasi Lainnya
Untuk informasi selengkapnya tentang operasi sumber data, lihat: