All Products
Search
Document Center

Quick BI:Overview of Creating a Database Data Source

Last Updated:Jan 20, 2025

This topic describes the entry points for creating database data sources, the supported data sources, and the available connectivity solutions.

Entry Points for Creating Data Sources

You can log on to the or the international Quick BI console and access the data source creation interface through any of the methods illustrated below.

  • Method 1: Create an ad hoc query from the Quick Start section on the Workbench tab within a workspace.

    image

  • Method 2: Create from the data source module inside a workspace.

    image

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

    image

Once you create a new data source using any of these entry points, you will be taken to the Connect to Data Source interface to select and configure the appropriate data source.

image

Copy Whitelist

To connect Quick BI to a database over the Internet, you must add Quick BI's CIDR blocks to the database instance's whitelist for network connectivity.

You can retrieve the Quick BI IP address by clicking Copy Whitelist on the datasource config interface. (Example shown uses Alibaba Cloud MySQL)

image

Supported Data Sources and Types

Data source

Data source type

MySQL

Alibaba Cloud Data Source MySQL

Tencent Cloud Data Source MySQL

HUAWEI CLOUD Data Source MySQL

Microsoft Cloud Data Source MySQL

AWS Data Sources MySQL

Add a User-created MySQL Data Source

Alibaba MaxCompute

Add a MaxCompute Data Source

Alibaba AnalyticDB for MySQL

Add an Alibaba AnalyticDB for MySQL 3.0 Data Source

Add an Alibaba AnalyticDB for MySQL 2.0 Data Source

SQL Server

Alibaba Cloud Data Source SQL Server

Tencent Cloud Data Source SQL Server

HUAWEI CLOUD Data Source SQL Server

Microsoft Cloud Data Source SQL Server

AWS Data Sources MySQL

Add a User-created SQL Server Data Source

PostgreSQL

Alibaba Cloud Data Source PostgreSQL

Tencent Cloud Data Source PostgreSQL

HUAWEI CLOUD Data Source PostgreSQL

Microsoft Cloud Data Source PostgreSQL

AWS Data Sources PostgreSQL

Add a User-created PostgreSQL Data Source

Alibaba Hologres

Alibaba Cloud Data Source Hologres

ClickHouse

Alibaba Cloud Data Source ClickHouse

Add a User-created ClickHouse Data Source

Alibaba AnalyticDB for PostgreSQL

Add an Alibaba AnalyticDB for PostgreSQL Data Source

Presto

Add a Presto Data Source

Alibaba Data Lake Analytics

Add a Data Lake Analytics Data Source

Alibaba PolarDB for MySQL

Add a PolarDB for MySQL Data Source

Oracle

Add a User-created Oracle Data Source

Hive

Add a Hive Data Source

Alibaba PolarDB distributed edition

Add an Alibaba PolarDB distributed edition Data Source

Alibaba PolarDB for PostgreSQL

Add a PolarDB for PostgreSQL Data Source

SAP HANA

Add a User-created SAP HANA Data Source

Alibaba PolarDB for Oracle

Add an Alibaba PolarDB for Oracle Data Source

IBM DB2 LUW

Add a User-created IBM DB2 LUW Data Source

Vertica

Add a User-created Vertica Data Source

Alibaba Lindorm

Add an Alibaba Lindorm Data Source

Alibaba OceanBase

Add an Alibaba OceanBase Data Source

SAP IQ (Sybase IQ)

Add a User-created SAP IQ (Sybase IQ) Data Source

Kingbase

Add a User-created Kingbase Data Source

Gbase 8a

Add a User-created Gbase 8a Data Source

Impala

Add a User-created Impala Data Source

Snowflake

Add a User-created Snowflake Data Source

Kylin

Add a User-created Kylin Data Source

Spark SQL

Add a User-created Spark SQL Data Source

MongoDB

Add a User-created MongoDB Data Source

Apache Doris

Add a User-created Apache Doris Data Source

Dameng (DM)

Add a User-created Dameng (DM) Data Source

TiDB

Add a User-created TiDB Data Source

MariaDB

Add a MariaDB Data Source

StarRocks

Alibaba Cloud Data Source StarRocks

Add a User-created StarRocks Data Source

SelectDB

Add a User-created SelectDB Data Source

Alibaba SLS

Add an Alibaba SLS Data Source

Huawei GaussDB

HUAWEI CLOUD Data Source GaussDB

Huawei GaussDB(DWS)

HUAWEI CLOUD Data Source GaussDB(DWS)

Elasticsearch

Alibaba Cloud Data Source Elasticsearch

Add a User-created Elasticsearch Data Source

TDSQL-H LibraDB

Tencent TDSQL-H LibraDB Data Source

Shentong

Add a User-created Shentong Data Source