In most cases, IT personnel and data engineers analyze data based on data sources. This topic describes the data sources supported by Quick BI.
Supported data sources
The following table describes the database versions supported by Quick BI and the connection methods of the database.
In the preceding table, indicates that the shortcuts are supported, and indicates that the shortcuts are not supported.
Data sources | Data source type | Supported engine version | Connection mode with the database | ||||||
Classic network (internal network) | Internet connection (you need to add a whitelist on the interface) | VPC connection (if the connection is not available, try adding 100.104.0.0/16 whitelist) | Regions that can be supported by VPC | Whether the password is required | Supports SSH | Supports SSL | |||
MySQL | 5.7 and below and 8.0 | All regions | |||||||
5.7 and below and 8.0 | N/A. | ||||||||
5.7 and below and 8.0 | N/A. | ||||||||
5.7 and below and 8.0 | N/A. | ||||||||
5.7 and below and 8.0 | N/A. | ||||||||
5.7 and below and 8.0 | All regions | ||||||||
Alibaba MaxCompute | All editions | N/A. | |||||||
Alibaba AnalyticDB for MySQL | Version 3.0 | Only central regions are supported. | |||||||
Version 2.0 | N/A. | ||||||||
SQL Server | All editions | All regions | |||||||
All editions | N/A. | ||||||||
All editions | N/A. | ||||||||
All editions | N/A. | ||||||||
All editions | N/A. | ||||||||
All editions | All regions | ||||||||
PostgreSQL | All editions | Only central regions are supported. | |||||||
All editions | N/A. | ||||||||
All editions | N/A. | ||||||||
All editions | N/A. | ||||||||
All editions | N/A. | ||||||||
All editions | All regions | ||||||||
Alibaba Hologres | All editions | N/A. | |||||||
ClickHouse | All editions | All regions | |||||||
All editions | All regions | ||||||||
Alibaba AnalyticDB for PostgreSQL | All editions | All regions | |||||||
Presto | PrestoDB-0.242 and below | All regions | |||||||
Alibaba Data Lake Analytics | All editions | N/A. | |||||||
Alibaba PolarDB for MySQL | 5.7 and below | Only central regions are supported. | |||||||
Oracle | All editions | All regions | |||||||
Hive | Hive2 | N/A. | |||||||
Alibaba PolarDB Distributed Edition (DRDS and Alibaba PolarDB-X) | All editions | All regions | |||||||
Alibaba PolarDB for PostgreSQL | All editions | Only central regions are supported. | |||||||
SAP HANA | All editions | All regions | |||||||
Alibaba PolarDB for Oracle (formerly PPAS) | All editions | N/A. | |||||||
Alibaba Lindorm wide table | All editions | N/A. | |||||||
IBM DB2 LUW | More than 11.1 | All regions | |||||||
Vertica | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x | All regions | |||||||
Alibaba LindormTSDB | All editions | N/A. | |||||||
Alibaba OceanBase | All editions | All regions | |||||||
SAP IQ (Sybase IQ) | 16.0 | All regions | |||||||
Kingbase | Version 7.1.2 | All regions | |||||||
Gbase | All editions | All regions | |||||||
Impala | All editions | All regions | |||||||
Snowflake | All editions | All regions | |||||||
Kylin | 3.1.2 and below | All regions | |||||||
Spark SQL | Version 3.1.2 | All regions | |||||||
MongoDB | All editions | All regions | |||||||
Apache Doris | All editions | All regions | |||||||
Dameng (DM) | 7.0, 8.0 version | All regions | |||||||
StarRocks | Version 2.0.1 | All regions | |||||||
SelectDB | All editions | All regions | |||||||
Alibaba SLS | All editions | N/A. | |||||||
Huawei GaussDB | All editions | N/A. | |||||||
Huawei GaussDB(DWS) | All editions | N/A. | |||||||
Elasticsearch | All editions | N/A. | |||||||
All editions | N/A. |
Network requirements
When you add a data source, take note of the following network requirements:
ApsaraDB RDS instances in a VPC can access Quick BI by 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 by using an internal domain name.
ApsaraDB RDS instances in the classic network can access Quick BI by using either a public domain name or an internal domain name. Before you connect an ApsaraDB RDS instance to Quick BI by using a public domain name, you must configure an IP address whitelist for 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 by using an internal domain name.
Related operations
For more operations that can be performed on data sources, see the following topics: