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:Sep 30, 2025

    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.

    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.

    • Service units and direct connection to data source APIs support different data sources for row-level permission configuration. The details are as follows:

      • When both service units and APIs support a data source and row-level permission is Y, it indicates that both the API and service unit support displaying row-level permissions. If only the API or service unit data source supports displaying row-level permissions, this will be specified.

      • When row-level permission is N, it indicates that neither the service unit nor API supported data sources support displaying row-level permissions.

    Data source

    Service unit

    Direct connection to data source API

    Row-level permission

    MySQL

    Y

    Y

    Y

    AnalyticDB for MySQL 2.0

    Y

    N

    Y

    Elasticsearch

    Y

    Y

    N

    HBase 0.94/1.1.x/2.x

    Y

    Y

    N

    Oracle

    Y

    Y

    Y

    Microsoft SQL Server

    Y

    Y

    Y

    PostgreSQL

    Y

    Y

    Y

    MongoDB

    Y

    N

    N

    AnalyticDB for MySQL 3.0

    Y

    N

    Y

    AnalyticDB for PostgreSQL

    Y

    N

    Y

    IMPALA

    N

    Y

    N

    Hologres

    Y

    Y

    Y

    ClickHouse

    N

    Y

    Y

    Lindrom (wide table)

    N

    Y

    N

    StarRocks

    N

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

    Y

    TDengine

    N

    Y

    N

    SAP HANA

    N

    Y

    N

    DM (only 3.13.12, v3.14.4)

    Y

    Y

    N

    SelectDB

    N

    Y

    Y

    GaussDB (DWS)

    N

    Y

    Y

    Amazon RDS for PostgreSQL

    Y

    Y

    Y (only service unit supported)

    Amazon RDS for MySQL

    Y

    Y

    Y (only service unit supported)

    Amazon RDS for SQL Server

    Y

    Y

    Y (only service unit supported)

    Amazon RDS for Oracle

    Y

    Y

    Y (only service unit supported)

    MaxCompute

    N

    Y (Only asynchronous invocations are supported)

    N

    Databricks

    N

    Y (Supports synchronous calls and asynchronous invocations)

    N

    Amazon Redshift

    Y

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

    N

    TDH Inceptor

    N

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

    N

    OceanBase

    Y

    Y (Supports synchronous and asynchronous invocations)

    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