In most cases, IT personnel and data engineers analyze data based on data sources.Quick BI currently supports two types of data sources: cloud data sources and self-managed data sources. This topic describes the data sources supported by Quick BI.
Supported Data Sources
Database data sources
The following table describes the database versions supported by Quick BI and the connection methods between Quick BI and databases.
indicates supported, 
indicates not supported.
Data source | Data source type | Supported database versions | Database connection methods | |||||
Internet 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) | VPC-supported regions | Password required | SSH support | SSL support | |||
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 |
|
|
| |
Alibaba MaxCompute | Alibaba Cloud | Versions 1.0 and 2.0 |
|
| Not applicable |
|
|
|
Alibaba Cloud AnalyticDB for MySQL | Alibaba Cloud | Version 3.0 |
|
| Central regions only |
|
|
|
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 |
|
| Central regions only |
|
|
|
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 Cloud 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 Cloud AnalyticDB for PostgreSQL | Alibaba Cloud | Versions 6.0 and 4.3 |
|
| All regions |
|
|
|
Presto | / | prestoDB 0.219, Trino 354 and later |
|
| All regions |
|
|
|
Alibaba Data Lake Analytics | Alibaba Cloud |
|
| Not applicable |
|
|
| |
PolarDB for MySQL | Alibaba Cloud | Versions 5.6, 5.7, 8.0.1, and 8.0.2 |
|
| Central regions only |
|
|
|
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 |
|
|
| |
PolarDB distributed edition (DRDS, PolarDB-X) | Alibaba Cloud | Versions 1.0 and 2.0 |
|
| All regions |
|
|
|
Alibaba Cloud PolarDB for PostgreSQL | Alibaba Cloud | Versions 11.0 and 14.0 |
|
| Central regions only |
|
|
|
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 |
|
| Not applicable |
|
|
| |
IBM DB2 LUW | Self-hosted | DB2 v10.5.3 and v11.1.4.4 |
|
| All regions |
|
|
|
Vertica | Self-hosted | Vertical Analytic Database v9.2.0-7 |
|
| 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-managed | 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 Simple Log Service (SLS) | Alibaba Cloud |
|
| Not applicable |
|
|
| |
Huawei GaussDB | Huawei Cloud |
|
| Not applicable |
|
|
| |
Huawei GaussDB(DWS) | Huawei Cloud |
|
| Not applicable |
|
|
| |
Elasticsearch | Alibaba Cloud | Versions 7.8.1 and later. The X-Pack plugin (Platinum Edition) is required. |
|
| Not applicable |
|
|
|
Self-hosted | Versions 7.8.1 and later. The X-Pack plugin (Platinum Edition) is required. |
|
| 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
Upload local files to the database to use as data sources. For more information about databases that support file upload, see Data Source Function Item List.
Application data sources
Dataphin (Professional Edition)
DMS
API data sources
You can use API operations to retrieve business data from external systems. You can create API data sources only in the Professional Edition.
Network Requirements
When you add a data source, Quick BI has the following requirements for the network type of the data source:
ApsaraDB RDS instances in a VPC can access Quick BI using a public domain name. However, only ApsaraDB RDS instances that run the MySQL or SQL Server engine in a VPC can access Quick BI using an internal domain name.
ApsaraDB RDS instances in the classic network can access Quick BI using either a public domain name or an internal domain name. When you access Quick BI using a public domain name, you must configure an IP address whitelist on the ApsaraDB RDS instance. For more information, see Configure a whitelist.
Quick BI can be connected over the Internet.
User-created MySQL or SQL Server databases hosted on an ECS instance in a VPC can access Quick BI using an internal domain name.
More Operations
For more information about operations that can be performed on data sources, see the following topics: