All Products
Search

This Product

    Dataphin:Data sources and compute engines supported by DataService

    Document Center

    Dataphin:Data sources and compute engines supported by DataService

    Last Updated:Jan 13, 2026

    This topic describes the data sources supported when you create service units or APIs in DataService Studio and the compute engines supported by logical table APIs.

    Symbol description

    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 APIs generated from a data source support create, update, and delete (CUD) operations.

    Data sources supported by DataService Studio

    • Direct connection to data source API supports both synchronous call mode and asynchronous call mode. If a data source supports asynchronous calls, this will be specified.

    • For service units and APIs with direct data source connections, support for features such as row-level permissions, paged queries, and returning the total number of entries varies depending on the data source. The details are as follows:

      • A value of Y in the Row-level permissions, Supports paged queries, or Supports returning total entries column indicates that both the API and the service unit support the feature. A note is provided if only the API or the service unit supports the feature.

      • A value of N in the Row-level permissions, Supports paged queries, or Supports returning total entries column indicates that neither the service unit nor the API supports the feature.

    • A synchronous API call returns a maximum of 10,000 query results per response. The total number of query results is not limited for synchronous calls or asynchronous invocations.

    • Logical table APIs support paged queries.

    • If a data source supports transactions, a note is provided.

    Data source

    Service unit

    Direct connection to data source API

    Row-level permission

    Support for paged queries

    Support for returning the total number of entries

    Support for CUD operations

    MySQL

    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

    Elasticsearch

    Y

    Y

    N

    Y (Supported by service units only)

    Y (Supported by service units only)

    N

    HBase 0.94/1.1.x/2.x

    Y

    Y

    N

    N

    N

    N

    Oracle

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    Microsoft SQL Server

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    PostgreSQL

    Y

    Y

    Y

    Y

    Y

    Y (Supports transactions)

    MongoDB

    Y

    N

    N

    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

    Impala

    N

    Y

    N

    Y

    Y

    N

    Hologres

    Y

    Y

    Y

    Y

    Y

    N

    ClickHouse

    N

    Y

    Y

    Y

    Y

    N

    Lindrom (wide table)

    N

    Y

    N

    Y

    Y

    N

    StarRocks

    N

    Y (supports both synchronous call mode and asynchronous call mode)

    Y

    Y

    Y

    N

    TDengine

    N

    Y

    N

    Y

    Y

    N

    SAP HANA

    N

    Y

    N

    N

    N

    N

    DM (only 3.13.12, v3.14.4)

    Y

    Y

    N

    Y

    Y

    N

    SelectDB

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    Y

    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

    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

    Y

    Y

    Y (Supported by service units only)

    Y

    Y

    N

    MaxCompute

    N

    Y (Only asynchronous invocations are supported)

    N

    N

    Y

    N

    Databricks

    N

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    Amazon Redshift

    Y

    Y (supports both synchronous call mode and asynchronous call mode)

    N

    Y

    Y

    N

    TDH Inceptor

    N

    Y (supports both synchronous call mode and asynchronous call mode)

    N

    Y

    Y

    N

    OceanBase

    Y

    Y (Supports synchronous and asynchronous invocations)

    N

    Y

    Y

    N

    Doris

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    PolarDB-X 2.0

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    DolphinDB

    N

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    GBase 8c

    Y

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Y

    Y

    N

    Compute engines supported by logical table APIs

    Compute engine

    Logical table API

    MaxCompute

    Y

    CDH5.x, CDH6.x

    Y

    Cloudera Data Platform 7.x

    Y

    AsiaInfo DP5.3

    Y

    AnalyticDB for PostgreSQL

    Y