This topic describes how to create an entry for a database data source, supported data sources, and connectivity solutions.
Create a data source entry
Log on to the Quick BI console Quick BI the console and use one of the methods shown in the figure to go to the Create Data Source page.
Method 1: Create a workbook from Quick Start on the Workbench tab out of a workspace.
Entry 2: Create data from the Data Sources in Space module
Entry 3: Quickly create a resource list in a space
After you create a data source by using one of the preceding methods, the Connect to Data Source page appears. You can select a data source and configure the connection.
Copy a whitelist
If you use Quick BI to connect to a database over the Internet, you must add the CIDR blocks of Quick BI to a whitelist of the database instance to ensure network connectivity.
You can click Copy Whitelist on the Data Source Configuration page to obtain the Quick BI IP addresses. (Alibaba Cloud MySQL is used as an example)
Supported data sources and data types
Data source | Data Source Type |
MySQL | |
Alibaba MaxCompute | |
Alibaba AnalyticDB for MySQL | |
SQL Server | |
PostgreSQL | |
Alibaba Hologres | |
ClickHouse | |
Alibaba AnalyticDB for PostgreSQL | |
Presto | |
Alibaba Data Lake Analytics | |
Alibaba PolarDB for MySQL | |
Oracle | |
Hive | |
Alibaba PolarDB Distributed Edition | |
Alibaba PolarDB for PostgreSQL | |
SAP HANA | |
Alibaba PolarDB for Oracle | |
Alibaba Lindorm wide table | |
IBM DB2 LUW | |
Vertica | |
Alibaba LindormTSDB | |
Alibaba OceanBase | |
SAP IQ (Sybase IQ) | |
Kingbase | |
Gbase | |
Impala | |
Snowflake | |
Kylin | |
Spark SQL | |
MongoDB | |
Apache Doris | |
Dameng (DM) | |
StarRocks | |
SelectDB | |
Alibaba SLS | |
Huawei GaussDB | |
Huawei GaussDB(DWS) | |
Elasticsearch | |
TDSQL-H LibraDB |