All Products
Search
Document Center

Quick BI:Overview of Creating a Database Data Source

Last Updated:Apr 28, 2024

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

Create a data source entry

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

Data 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

Self-built 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-managed PostgreSQL data source

Alibaba Hologres

Hologres

ClickHouse

ApsaraDB for ClickHouse

user-created ApsaraDB for ClickHouse

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-built data source Kingbase

Gbase

Add a self-managed GBase data source

Impala

Self-managed Impala data source

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-managed Apache Doris data source

Dameng (DM)

self-managed data source Dameng

StarRocks

Alibaba Cloud data source StarRocks

User-created 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

TDSQL-H LibraDB

Tencent TDSQL-H LibraDB data source