Quick BI supports cloud and user-created data sources.
Supported data sources
Database data sources
The following table lists supported database versions and connection methods.
means supported, and 
means not supported.
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 |
|
|
|
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 |
|
|
| |
File data source
Upload local files to a database for use as a data source. Supported databases are listed in Features of data sources.
Application data source
Dataphin (Professional Edition)
DMS
API data source
Retrieve business data from external systems via an API. Requires the Professional Edition.
Data source network requirements
When you add a data source, verify that your network meets these requirements:
ApsaraDB RDS instances in a VPC can access Quick BI through a public domain name. Only MySQL and SQL Server instances support internal domain names.
ApsaraDB RDS instances in a classic network can access Quick BI through a public or internal domain name. Public domain name access requires an IP address whitelist for the instance. Configure a whitelist.
Quick BI is accessible over the public network.
Self-hosted MySQL or SQL Server databases on a VPC-based ECS instance can access Quick BI through an internal domain name.
Related topics
Data source operations: