Quick BI:Data Source Function Item List

Data source

Supported function items

Init SQL

Upload file

Custom week

HINT statement

Data entry

Complex table entry

System built-in functions

Trend/multidimensional analysis table (average/cumulative)

Database data source

MySQL

✅

✅

✅

✅

✅

✅

✅

Alibaba MaxCompute

✅

✅

✅

✅

✅

✅

Alibaba AnalyticDB for MySQL 2.0

✅

Alibaba AnalyticDB for MySQL 3.0

✅

✅

✅

✅

✅

✅

✅

SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

Alibaba Hologres

✅

✅

✅

✅

✅

✅

✅

✅

ClickHouse

✅

✅

✅

✅

✅

✅

Alibaba AnalyticDB for PostgreSQL

✅

✅

✅

✅

✅

✅

Presto

✅

✅

✅

✅

✅

Alibaba PolarDB for MySQL

✅

✅

✅

✅

✅

✅

✅

Oracle

✅

✅

✅

✅

✅

✅

✅

Hive

✅

✅

✅

✅

Alibaba PolarDB distributed version (DRDS, Alibaba PolarDB-X)

✅

✅

✅

Alibaba PolarDB for PostgreSQL

✅

✅

✅

✅

✅

SAP HANA

Alibaba PolarDB for Oracle (formerly PPAS)

✅

✅

✅

✅

✅

Hbase

Vertica

Impala (EMR not supported)

✅

✅

✅

✅

Spark SQL

✅

✅

✅

✅

Apache Doris

✅

✅

✅

✅

Dameng (DM)

✅

✅

✅

StarRocks

✅

✅

✅

✅

✅

✅

TDSQL-H LibraDB

Lindorm

Alibaba SLS

IBM DB2 LUW

OceanBase

SAP IQ (Sybase IQ)

SAP HANA

✅

Kingbase

Gbase 8a

✅

Snowflake

Kylin

MongoDB

✅

✅

SelectDB

✅

✅

TiDB

✅

✅

MariaDB

✅

✅

GaussDB

GaussDB(DWS)

Elasticsearch

Shentong

✅

Greenplum

✅

✅

✅

✅

Application data source

Dataphin

✅ (under JDBC connection mode)

✅