Quick BI:Data Source Function Item List

Data source type

Data source

Supported features

Init SQL

Upload files

Custom week

HINT statements

Quick engine extraction acceleration

Data preparation

Data entry

Complex table entry

System built-in functions

Trend/Multidimensional analysis table (average/cumulative)

Self-managed data sources

MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

MariaDB

✅

✅

✅

Oracle

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

ClickHouse

✅

✅

✅

✅

✅

✅

✅

✅

Presto

✅

✅

✅

✅

✅

✅

Hive

✅

✅

✅

✅

✅

✅

Impala (EMR is not supported)

✅

✅

✅

✅

✅

✅

Spark SQL

✅

✅

✅

✅

✅

Hbase

MongoDB

✅

✅

✅

Apache Doris

✅

✅

✅

✅

✅

StarRocks

✅

✅

✅

✅

✅

✅

✅

✅

SelectDB

✅

✅

✅

Elasticsearch

SAP HANA

✅

✅

SAP IQ (Sybase IQ)

IBM DB2 LUW

Vertica

Kingbase

Gbase 8a

✅

Snowflake

Kylin

TiDB

✅

✅ (The BI_MID function is not supported)

✅

Dameng

✅

✅

✅

✅

✅

✅

Shentong

✅

Greenplum

✅

✅

✅

✅

Alibaba Cloud data sources

RDS for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for MariaDB

✅

✅

✅

MaxCompute

✅

✅

✅

✅

✅

✅

✅

✅

Hologres

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

ClickHouse

✅

✅

✅

✅

✅

✅

✅

✅

AnalyticDB for MySQL 2.0

✅

✅

AnalyticDB for MySQL 3.0

✅

✅

✅

✅

✅

✅

✅

✅

✅

AnalyticDB for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

PolarDB for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

PolarDB for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

PolarDB for PostgreSQL (Compatible with Oracle)

✅

✅

✅

✅

✅

PolarDB-X

✅

✅

✅

✅

Lindorm

OceanBase

✅

E-MapReduce Serverless StarRocks

✅

✅

✅

✅

✅

✅

✅

✅

Simple Log Service

Elasticsearch

SelectDB

✅

✅

E-MapReduce Serverless Spark

✅

✅

✅

✅

✅

AWS data sources

RDS for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Aurora MySQL

✅

✅

✅

✅

Aurora PostgreSQL

✅

✅

✅

✅

Redshift

✅

Databricks

✅

✅

✅

✅

Amazon Athena

✅

✅

Huawei Cloud data sources

RDS for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

GaussDB

GaussDB (DWS)

✅

Tencent Cloud data sources

TencentDB for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

TencentDB for SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

TDSQL-H LibraDB

✅

Microsoft Cloud data source

Azure Database for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Azure Database for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Azure Database for SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Databricks

✅

✅

✅

✅

Application data sources

Dataphin

✅ (for JDBC connections)

✅

✅

✅

DMS

✅

✅