Overview of creating a database source

更新时间:
复制 MD 格式

This topic describes the entry points for creating database sources, the supported data sources, and their connection methods.

Limitations

Only users with the Developer user type and a workspace role that includes the Create (Edit) Data Source permission can create database sources.

Entry points

Log on to the Quick BI console. You can open the data source creation page in several ways.

  • Entry 1: From the global resource menu

    image

  • Entry 2: From the Data Sources page within a workspace

    image

  • Entry 3: From the resource list within a workspace

    image

Each of these entry points takes you to the Connect to a Data Source page, where you can select a data source type and configure its connection.

image

IP allowlist

When you connect Quick BI to a database over the public network, you must add the Quick BI IP addresses to the database's allowlist.

On the data source configuration page, click Copy Allowlist to copy the Quick BI IP addresses. The following figure shows an example using Alibaba Cloud RDS for MySQL.

image

Supported data sources and types

Data source

Data source type

MySQL

Alibaba Cloud RDS for MySQL

Alibaba Cloud RDS for MySQL DuckDB

Tencent Cloud TencentDB for MySQL

Huawei Cloud RDS for MySQL

Microsoft Azure Database for MySQL

AWS RDS for MySQL

Self-hosted MySQL

MaxCompute

Alibaba Cloud MaxCompute

AnalyticDB for MySQL

Alibaba Cloud AnalyticDB for MySQL 3.0

Alibaba Cloud AnalyticDB for 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 SQL Server

Self-hosted SQL Server

PostgreSQL

Alibaba Cloud RDS for PostgreSQL

Tencent Cloud PostgreSQL

Huawei Cloud PostgreSQL

Microsoft Azure Database for PostgreSQL

AWS RDS for PostgreSQL

Self-hosted PostgreSQL

Hologres

Alibaba Cloud Hologres

ClickHouse

Alibaba Cloud ClickHouse

Self-hosted ClickHouse

AnalyticDB for PostgreSQL

Alibaba Cloud AnalyticDB for PostgreSQL

Presto

Self-hosted Presto

Data Lake Analytics

Alibaba Cloud Data Lake Analytics (deprecated)

PolarDB for MySQL

Alibaba Cloud PolarDB for MySQL

Oracle

Self-hosted Oracle

Hive

Self-hosted Hive

PolarDB for Xscale

Alibaba Cloud PolarDB for Xscale

PolarDB for PostgreSQL

Alibaba Cloud PolarDB for PostgreSQL

SAP HANA

Self-hosted SAP HANA

PolarDB for Oracle

Alibaba Cloud PolarDB for Oracle

IBM DB2 LUW

Self-hosted IBM DB2 LUW

Vertica

Self-hosted Vertica

Lindorm

Alibaba Cloud Lindorm

OceanBase

Alibaba Cloud OceanBase

SAP IQ (Sybase IQ)

Self-hosted SAP IQ (Sybase IQ)

Kingbase

Self-hosted Kingbase

Gbase 8a

Self-hosted Gbase 8a

Impala

Self-hosted Impala

Snowflake

Self-hosted Snowflake

Kylin

Self-hosted Kylin

Spark SQL

Self-hosted Spark SQL

Alibaba Cloud E-MapReduce Serverless Spark

MongoDB

Self-hosted MongoDB

Apache Doris

Self-hosted Apache Doris

Dameng

Self-hosted Dameng

TiDB

Self-hosted TiDB

MariaDB

Self-hosted MariaDB

StarRocks

Alibaba Cloud E-MapReduce Serverless StarRocks

Self-hosted StarRocks

SelectDB

Self-hosted SelectDB

Alibaba Cloud SelectDB

Simple Log Service (SLS)

Alibaba Cloud Simple Log Service (SLS)

Huawei GaussDB

Huawei Cloud GaussDB

Huawei GaussDB(DWS)

Huawei Cloud GaussDB (DWS)

Elasticsearch

Alibaba Cloud Elasticsearch

Self-hosted Elasticsearch

TDSQL-H LibraDB

Tencent Cloud TDSQL-H LibraDB

Shentong

Self-hosted Shentong

Greenplum

Self-hosted Greenplum

Aurora MySQL

AWS Aurora MySQL

Aurora PostgreSQL

AWS Aurora PostgreSQL

Amazon Redshift

Amazon Redshift

Databricks

AWS Databricks

Microsoft Azure Databricks