This topic describes the entry points for creating a database data source, supported data sources, and connectivity solutions.
Entry Points for Creating a Data Source
Log on to the Quick BI console and use any of the following methods to access the data source creation interface.
Method 1: Create an ad hoc query from Quick Start on the Workbench tab outside a workspace
Method 2: Create from the Data Source module within a workspace
Method 3: Create quickly from the resource list within a workspace
After creating a new data source from any of the above entry points, you will be redirected to the Connect Data Source interface where you can select and configure the corresponding data source.
Copy 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 interface to obtain the IP addresses of Quick BI. (Using Alibaba Cloud MySQL as an example)
Supported Data Sources and 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 Cloud PolarDB for PostgreSQL (Compatible with Oracle) |
IBM DB2 LUW | |
Vertica | |
Alibaba Lindorm | |
Alibaba OceanBase | |
SAP IQ (Sybase IQ) | |
Kingbase | |
Gbase 8a | |
Impala | |
Snowflake | |
Kylin | |
Spark SQL | |
MongoDB | |
Apache Doris | |
Dameng (DM) | |
TiDB | |
MariaDB | |
StarRocks | |
SelectDB | |
Alibaba SLS | |
Huawei GaussDB | |
Huawei GaussDB(DWS) | |
Elasticsearch | |
TDSQL-H LibraDB | |
Shentong | |
Greenplum |