IT staff and data developers analyze data from various data sources. Quick BI supports cloud data sources and user-created data sources. This topic describes the data sources supported by Quick BI.
Supported Data Sources
Database data sources
The following table describes the supported database versions and connection methods.
indicates support, and 
indicates no support.
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 |
|
|
| |
File data sources
You can upload local files to a database and use them as a data source. For a list of databases that support file uploads, see Advanced features of data sources.
Application data sources
Dataphin (Professional Edition)
DMS
API data sources
You can use API operations to retrieve business data from external systems. Only the Professional Edition supports creating API data sources.
Network Requirements for Data Sources
The following network requirements apply when you add a data source to Quick BI:
RDS instances in a VPC can access Quick BI using public endpoints. However, access through internal same-region endpoints is supported only for MySQL and SQL Server instances.
Quick BI can access instances in the classic network using a public endpoint or an internal same-region endpoint. If you use a public endpoint, you must configure the IP address whitelist for the RDS instance. For more information, see Set a whitelist.
You can access Quick BI over the Internet.
You can access Quick BI from self-hosted MySQL and SQL Server databases on VPC ECS instances using an internal same-region endpoint.
More Operations
For more information about data source operations, see: