All Products
Search
Document Center

Quick BI:Overview of Creating a Database Data Source

Last Updated:Feb 02, 2024

This topic describes how to create an entry for a database data source, supported data sources, and connectivity solutions.

Entry of creating a datasource

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.

    image

  • Entry 2: Create data from the Data Sources in Space module

    image

  • Entry 3: Quickly create a resource list in a space

    image

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.

image

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)

image

Supported data sources and data types

Data source parameters

Source Type

MySQL

ApsaraDB RDS for MySQL

Tencent Cloud data source MySQL

HUAWEI CLOUD MySQL data source

ApsaraDB RDS for MySQL

AWS data source MySQL

User-created MySQL data source

Alibaba MaxCompute

MaxCompute data sources

Alibaba AnalyticDB for MySQL

AnalyticDB for MySQL V3.0 data sources

AnalyticDB for MySQL V2.0 data sources

SQL Server

ApsaraDB RDS for SQL Server data source

Tencent Cloud data source SQL Server

HUAWEI CLOUD data source for SQL Server

ApsaraDB RDS for SQL Server data source

AWS data source MySQL

Self-built data source SQL Server

PostgreSQL

ApsaraDB RDS for PostgreSQL

Tencent Cloud data source PostgreSQL

HUAWEI CLOUD PostgreSQL data source

ApsaraDB RDS for PostgreSQL

AWS data source PostgreSQL

Self-built PostgreSQL data source

Alibaba Hologres

Hologres

ClickHouse

ApsaraCloud ClickHouse

User-created ClickHouse data source

Alibaba AnalyticDB for PostgreSQL

AnalyticDB for PostgreSQL data sources

Presto

Presto data source

Alibaba Data Lake Analytics

Data Lake Analytics (DLA) data sources

Alibaba PolarDB for MySQL

PolarDB for MySQL data sources

Oracle

Self-managed Oracle data source

Hive

Hive data source

Alibaba PolarDB Distributed Edition

Alibaba Cloud PolarDB Distributed Edition

Alibaba PolarDB for PostgreSQL

PolarDB for PostgreSQL data sources

SAP HANA

User-created SAP HANA data source

Alibaba PolarDB for Oracle

Cloud data source Alibaba PolarDB for Oracle

Alibaba Lindorm wide table

Alibaba Cloud Lindorm wide table

IBM DB2 LUW

User-created data source IBM DB2 LUW

Vertica

User-created Vertica data source

Alibaba LindormTSDB

ApsaraDB for LindormTSDB

Alibaba OceanBase

Alibaba Cloud OceanBase

SAP IQ (Sybase IQ)

SAP IQ(Sybase IQ)

Kingbase

Self-managed Kingbase data source

Gbase

Self-built data source GBase

Impala

Self-built data source Impala

Snowflake

Self-built Snowflake data source

Kylin

Self-managed Kylin data source

Spark SQL

Self-built data source Spark SQL

MongoDB

Self-managed MongoDB data source

Apache Doris

Self-built Apache Doris data source

Dameng (DM)

Self-built data source Dameng

StarRocks

Self-built data source StarRocks

SelectDB

User-created data source SelectDB

Alibaba SLS

Alibaba Cloud SLS

Huawei GaussDB

HUAWEI CLOUD GaussDB data source

Huawei GaussDB(DWS)

HUAWEI CLOUD GaussDB(DWS)

Elasticsearch

Alibaba Cloud data source Elasticsearch

User-created data source Elasticsearch