Personel IT dan pengembang data biasanya menganalisis data berdasarkan sumber datanya. Quick BI mendukung sumber data berbasis cloud maupun self-hosted. Topik ini menjelaskan secara rinci sumber data yang didukung oleh Quick BI.
Sumber data yang didukung
Sumber data database
Tabel berikut mencantumkan versi database yang didukung beserta metode koneksi masing-masing.
menunjukkan dukungan. 
menunjukkan tidak didukung.
Data Source | Data Source Type | Supported Database Versions | Connectivity to Database | |||||
Public Network Connection (add the whitelist on the interface) | VPC Connection (if connection fails, try adding 100.104.0.0/16 to the whitelist) | Supported Regions for VPC | Password Required? | Supports SSH? | Supports SSL? | |||
MySQL | Alibaba Cloud | Versions 5.5, 5.6, 5.7, 8.0 |
|
| All Regions |
|
|
|
Tencent Cloud | Versions 5.5, 5.6, 5.7, 8.0 |
|
| Not applicable |
|
|
| |
Huawei Cloud | Versions 5.5, 5.6, 5.7, 8.0 |
|
| Not applicable |
|
|
| |
Microsoft Cloud | Versions 5.5, 5.6, 5.7, 8.0 |
|
| Not applicable |
|
|
| |
AWS | Versions 5.5, 5.6, 5.7, 8.0 |
|
| Not applicable |
|
|
| |
Self-managed | Versions 5.5, 5.6, 5.7, 8.0 |
|
| All Regions |
|
|
| |
MySQL DuckDB | Alibaba Cloud | Versions 5.7, 8.0 |
|
| All Regions |
|
|
|
Alibaba MaxCompute | Alibaba Cloud | Versions 1.0, 2.0 |
|
| Not applicable |
|
|
|
Alibaba AnalyticDB for MySQL | Alibaba Cloud | Version 3.0 |
|
| Only central regions 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-managed | Versions 2008 to 2022 |
|
| All Regions |
|
|
| |
PostgreSQL | Alibaba Cloud | Version 8.2 and later |
|
| Only central regions 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-managed | Version 8.2 and later |
|
| All Regions |
|
|
| |
Alibaba Hologres | Alibaba Cloud | Data Warehouse Edition |
|
| All Regions |
|
|
|
ClickHouse | Alibaba Cloud | Versions 20.3, 22.8 |
|
| All Regions |
|
|
|
Self-managed | Versions 20.3, 22.8 |
|
| All Regions |
|
|
| |
Alibaba AnalyticDB for PostgreSQL | Alibaba Cloud | Versions 6.0, 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, 8.0.2 |
|
| Only central regions supported |
|
|
|
Oracle | Alibaba Cloud | Version 11.0 |
|
| All Regions |
|
|
|
Hive | / | Apache Hive versions 2.0.1 to 2.3.3 |
|
| Not applicable |
|
|
|
Alibaba Object Storage Service OSS | Alibaba Cloud |
|
| Not applicable |
|
|
| |
Alibaba Distributed PolarDB (DRDS, Alibaba PolarDB-X) | Alibaba Cloud | Versions 1.0, 2.0 |
|
| All Regions |
|
|
|
Alibaba PolarDB for PostgreSQL | Alibaba Cloud | Versions 11.0, 14.0 |
|
| Only central regions supported |
|
|
|
SAP HANA | Self-managed | Version 2.0 |
|
| All Regions |
|
|
|
Alibaba PolarDB for Oracle (formerly PPAS) | Alibaba Cloud | Versions 1.0, 2.0 |
|
| All Regions |
|
|
|
Alibaba Lindorm | Alibaba Cloud |
|
| All Regions |
|
|
| |
IBM DB2 LUW | Self-managed | DB2 versions v10.5.3, v11.1.4.4 |
|
| All Regions |
|
|
|
Vertica | Self-managed | Vertica Vertica Analytic Database version v9.2.0-7 |
|
| All Regions |
|
|
|
Alibaba OceanBase | Alibaba Cloud | Versions 4.2.1.3, 4.3 |
|
| Not applicable |
|
|
|
SAP IQ (Sybase IQ) | Self-managed | SAP IQ/16.1.030.1031/10645/version |
|
| All Regions |
|
|
|
Kingbase | Self-managed | Version 7.1.2 |
|
| All Regions |
|
|
|
Gbase 8a | Self-managed | Versions 8.6, 9.5 |
|
| All Regions |
|
|
|
Impala | Self-managed | Versions 2.10.0, 3.4.0 |
|
| All Regions |
|
|
|
Snowflake | Self-managed |
|
| All Regions |
|
|
| |
Kylin | Self-managed | Version 3.0 |
|
| All Regions |
|
|
|
Spark SQL | Self-managed | Version 3.1.2 |
|
| All Regions |
|
|
|
Alibaba Cloud | Version 3.1.2 |
|
| Not applicable |
|
|
| |
MongoDB | Self-managed | Version 5.0 |
|
| All Regions |
|
|
|
Apache Doris | Self-managed | Version 1.2.4 |
|
| All Regions |
|
|
|
Dameng | Self-managed | Versions 7.0, 8.0 |
|
| All Regions |
|
|
|
StarRocks | Alibaba Cloud | Versions 2.5.18, 3.1.7, 3.1.9, 3.2.6 |
|
| All Regions |
|
|
|
Self-managed | Versions 2.5.18, 3.1.7, 3.1.9, 3.2.6 |
|
| All Regions |
|
|
| |
SelectDB | Self-managed |
|
| All Regions |
|
|
| |
Alibaba Cloud |
|
| All Regions |
|
|
| ||
Alibaba SLS | Alibaba Cloud |
|
| Not applicable |
|
|
| |
Huawei GaussDB | Huawei Cloud |
|
| Not applicable |
|
|
| |
Huawei GaussDB(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-managed | 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-managed | Version 7.1.3 |
|
| Not applicable |
|
|
|
MariaDB | Alibaba Cloud | Version 10.3 |
|
| All Regions |
|
|
|
Self-managed | Version 10.3 |
|
| Not applicable |
|
|
| |
ShenTong | Self-managed | Version 8.0 |
|
| Not applicable |
|
|
|
Greenplum | Self-managed | Version 6.10.0 |
|
| All Regions |
|
|
|
Aurora MySQL | AWS | Versions 2.11.5, 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 untuk digunakan sebagai sumber data. Untuk informasi mengenai database yang mendukung unggahan file, lihat Daftar fitur sumber data.
Sumber data aplikasi
Dataphin (Edisi Profesional)
DMS
Sumber data API
Anda dapat mengambil data bisnis dari sistem eksternal melalui operasi API. Hanya Edisi Profesional yang mendukung pembuatan sumber data API.
Persyaratan jaringan untuk sumber data
Saat menambahkan sumber data, Quick BI memiliki persyaratan jenis jaringan sebagai berikut:
Instans RDS di VPC dapat terhubung ke Quick BI melalui titik akhir publik. Instans MySQL dan SQL Server juga mendukung koneksi melalui titik akhir internal di wilayah yang sama, sedangkan tipe instans RDS lainnya di VPC tidak mendukung koneksi ke Quick BI melalui titik akhir internal tersebut.
Instans dalam jaringan klasik dapat terhubung ke Quick BI melalui titik akhir publik atau titik akhir internal antar-wilayah yang sama. Jika menggunakan titik akhir publik, konfigurasikan daftar putih alamat IP untuk instans RDS tersebut. Untuk informasi selengkapnya, lihat Setel daftar putih.
Quick BI dapat diakses melalui jaringan publik.
Database MySQL dan SQL Server yang di-host sendiri pada instance ECS dalam VPC dapat terhubung ke Quick BI melalui endpoint internal di wilayah yang sama.
Operasi lainnya
Untuk informasi selengkapnya mengenai operasi sumber data, lihat: