All Products
Search

This Product

    Dataphin:Data sources and compute engines supported by DataService Studio

    Document Center

    Dataphin:Data sources and compute engines supported by DataService Studio

    Last Updated:Mar 05, 2026

    This topic lists the data sources that Data Service supports for creating service units and APIs. It also lists the compute engines that logical table APIs support.

    Legend

    Y indicates that the feature supports the data source or compute engine. N indicates that the feature does not support the data source or compute engine.

    Limits

    Only direct-connection data source APIs support add, delete, and modify operations.

    Data sources supported by Data Service

    • Direct-connection data source APIs support synchronous calls and asynchronous invocations. If a data source supports asynchronous invocations, this is noted.

    • Support for configuring row-level permissions, paged queries, and returning the total number of entries differs between service units and direct-connection data source APIs. The following notes apply:

      • If the value for these features is Y, both service units and APIs provide support. If support is limited to only one, a specific note is included.

      • If the value is N, neither service units nor APIs support the feature.

    • For synchronous calls, the maximum number of returned query results is 10,000. The total number of query results is not limited for either synchronous calls or asynchronous invocations.

    • Logical table APIs support paged queries.

    • If a data source supports transactions, this is noted.

    Data source

    Data source version

    Service unit

    Direct-connection data source API

    Row-level permissions

    Supports paged query

    Supports returning total count

    Supports add, delete, and modify operations

    Big data storage

    MaxCompute

    /

    N

    Y (Supports only asynchronous invocation)

    N

    N

    Y

    N

    Hologres

    /

    Y

    Y

    Y

    Y

    Y

    N

    Impala

    • CDH5:2.11.0

    • CDH6:3.2.0

    • CDP7.1.3:3.4.0

    • E-MapReduce 3.x: 3.4.0

    • E-MapReduce 5.x: 3.4.0

    • E-MapReduce 5.x: 4.2.0

    N

    Y

    N

    Y

    Y

    N

    TDH Inceptor

    • 6.2.x

    • 9.3.x

    N

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    Doris

    /

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    SelectDB

    V3.x

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    Y

    Y

    Y

    N

    TDengine

    /

    N

    Y

    N

    Y

    Y

    N

    StarRocks

    /

    N

    Y (Supports synchronous calls and asynchronous invocations)

    Y

    Y

    Y

    N

    Databricks

    2.6.40

    N

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    Amazon Redshift

    1.0.x

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    DolphinDB

    v2.00.11.2

    N

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    Relational database

    PolarDB-X 2.0

    /

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    MySQL

    • MySQL 5.1.43

    • MySQL 5.6/5.7

    • MySQL 8

    • RDS for MySQL

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    SAP HANA

    /

    N

    Y

    N

    N

    N

    N

    Microsoft SQL Server

    /

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    PostgreSQL

    /

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    AnalyticDB for MySQL 2.0

    /

    Y

    N

    Y

    Y (Supported by service units only)

    Y (Supported by service units only)

    N

    AnalyticDB for MySQL 3.0

    /

    Y

    N

    Y

    Y (Supported by service units only)

    Y (Supported by service units only)

    N

    AnalyticDB for PostgreSQL

    /

    Y

    N

    Y

    Y (Supported by service units only)

    Y (Supported by service units only)

    N

    OceanBase

    /

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    Oracle

    • Oracle 11g

    • Oracle 12c

    • Oracle 18c

    • Oracle 19c

    • Oracle 21c

    • Oracle 23c

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    ClickHouse

    /

    N

    Y

    Y

    Y

    Y

    N

    Dameng DM (only 3.13.12, v3.14.4)

    /

    Y

    Y

    N

    Y

    Y

    N

    GBase 8c

    /

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    GaussDB (DWS)

    /

    N

    Y

    Y

    Y

    Y

    N

    Amazon RDS for PostgreSQL

    /

    Y

    Y

    Y (Supported by service units only)

    Y

    Y

    N

    Amazon RDS for MySQL

    • MySQL 5.6/5.7

    • MySQL 8

    Y

    Y

    Y (Supported by service units only)

    Y

    Y

    N

    Amazon RDS for SQL Server

    /

    Y

    Y

    Y (Supported by service units only)

    Y

    Y

    N

    Amazon RDS for Oracle

    • Oracle 19c

    • Oracle 21c

    Y

    Y

    Y (Supported by service units only)

    Y

    Y

    N

    GBase 8a

    /

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    NoSQL

    Elasticsearch

    • Elasticsearch 6.x

    • Elasticsearch 7.x

    • Elasticsearch 8.x

    Y

    Y

    N

    Y (Supported by service units only)

    Y (Supported by service units only)

    N

    HBase

    • HBase 0.94

    • HBase 1.1.x

    • HBase 2.x

    Y

    Y

    N

    N

    N

    N

    MongoDB

    • MongoDB 3.2

    • MongoDB 3.4+

    Y

    N

    N

    Y (Supported by service units only)

    Y (Supported by service units only)

    N

    Lindorm (wide table)

    /

    N

    Y

    N

    Y

    Y

    N

    OpenSearch

    2.x

    N

    Y

    N

    Y

    Y

    N

    Compute engines supported by logical table APIs in Data Service

    Compute engine

    Logical table API

    MaxCompute

    Y

    CDH 5.x, CDH 6.x

    Y

    Cloudera Data Platform 7.x

    Y

    AsiaInfo DP 5.3

    Y

    AnalyticDB for PostgreSQL

    Y