All Products
Search
Document Center

Quick BI:Overview of Creating a Database Data Source

Last Updated:Apr 21, 2025

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

    image

  • Method 2: Create from the Data Source module within a workspace

    image

  • Method 3: Create quickly from the resource list within a workspace

    image

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.

image

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)

image

Supported Data Sources and Types

Data source

Data source type

MySQL

Alibaba Cloud RDS for MySQL

Tencent Cloud TencentDB for MySQL

Huawei Cloud RDS for MySQL

Microsoft Azure Database for MySQL

AWS RDS for MySQL

User-created MySQL Data Source

Alibaba MaxCompute

Add a MaxCompute Data Source

Alibaba AnalyticDB for MySQL

Alibaba Cloud AnalyticDB MySQL 3.0

Alibaba Cloud AnalyticDB MySQL 2.0

SQL Server

Alibaba Cloud RDS for SQL Server

Tencent Cloud TencentDB for SQL Server

Huawei Cloud RDS for SQL Server

Microsoft Azure Database for SQL Server

AWS RDS for MySQL

User-created SQL Server Data Source

PostgreSQL

Alibaba Cloud RDS for PostgreSQL

Tencent Cloud PostgreSQL

Huawei Cloud PostgreSQL

Microsoft Azure Database for PostgreSQL

AWS PostgreSQL

User-created PostgreSQL Data Source

Alibaba Hologres

Alibaba Cloud Hologres

ClickHouse

Alibaba Cloud ClickHouse

User-created ClickHouse Data Source

Alibaba AnalyticDB for PostgreSQL

Alibaba Cloud AnalyticDB for PostgreSQL

Presto

Presto Data Source

Alibaba Data Lake Analytics

Alibaba Cloud Data Lake Analytics (to be unpublished)

Alibaba PolarDB for MySQL

Alibaba Cloud PolarDB for MySQL

Oracle

User-created Oracle Data Source

Hive

Hive Data Source

Alibaba PolarDB Distributed Edition

Alibaba Cloud PolarDB Distributed Edition

Alibaba PolarDB for PostgreSQL

Alibaba Cloud PolarDB for PostgreSQL

SAP HANA

User-created SAP HANA Data Source

Alibaba PolarDB for Oracle

Alibaba Cloud PolarDB for PostgreSQL (Compatible with Oracle)

IBM DB2 LUW

User-created IBM DB2 LUW Data Source

Vertica

User-created Vertica Data Source

Alibaba Lindorm

Alibaba Cloud Lindorm

Alibaba OceanBase

Alibaba Cloud OceanBase

SAP IQ (Sybase IQ)

User-created SAP IQ (Sybase IQ) Data Source

Kingbase

User-created Kingbase Data Source

Gbase 8a

User-created Gbase 8a Data Source

Impala

User-created Impala Data Source

Snowflake

User-created Snowflake Data Source

Kylin

User-created Kylin Data Source

Spark SQL

User-created Spark SQL Data Source

MongoDB

User-created MongoDB Data Source

Apache Doris

User-created Apache Doris Data Source

Dameng (DM)

User-created Dameng Data Source

TiDB

User-created TiDB Data Source

MariaDB

Create MariaDB Data Source

StarRocks

Alibaba Cloud E-MapReduce Serverless StarRocks Edition

User-created StarRocks Data Source

SelectDB

User-created SelectDB Data Source

Alibaba SLS

Alibaba Cloud Simple Log Service SLS

Huawei GaussDB

Huawei Cloud GaussDB

Huawei GaussDB(DWS)

Huawei Cloud GaussDB(DWS)

Elasticsearch

Alibaba Cloud Elasticsearch

User-created Elasticsearch Data Source

TDSQL-H LibraDB

Tencent Cloud TDSQL-H LibraDB

Shentong

User-created Shentong Data Source

Greenplum

User-created Greenplum Data Source