Help Center/ ROMA Connect/ User Guide/ Data Source Management/ Data Sources Supported by ROMA Connect
Updated on 2024-11-27 GMT+08:00

Data Sources Supported by ROMA Connect

Data Sources Supported by Data Integration Task

  • Table 1 lists all the data source types for data integration. For details about the task types and integration modes supported by each data source, see Connecting to Data Sources.
  • Users who connect to a data source must have permission to create a session for connecting to the database.
Table 1 Data sources supported for data integration

Data Source Type

Compatibility

API

N/A

ActiveMQ

5.15.9

ArtemisMQ

2.9.0

DB2

9.7

DIS

N/A

DWS

1.3.4

DM

-

FTP

N/A

Gauss100

FusionInsight_LibrA_V100R003C20 and FusionInsight_LibrA_V300R001C00

HL7

2.1, 2.2, 2.3, 2.3.1, 2.4, 2.5, 2.6, 2.7, 2.8, or 2.8.1

HANA

1.0

IBM MQ

9.1

Kafka

1.1.0 and 2.3.0

LDAP

N/A

MongoDB

3.4

MQS

N/A

MRS HBase

MRS 3.*.*

MRS HDFS

MRS 3.*.*

MRS Hive

MRS 3.*.*

MRS Kafka

MRS 3.*.*

MySQL

5.7, 8.0

OBS

3

Oracle

11.2g (not recommended), 12.1g (not recommended), 12.2g, and 19c

PostgreSQL

11

RabbitMQ

3.6.10

RocketMQ

4.7.0

Redis

3.0.7, 4.0.11

SAP

SAP Java Connector 3.0.19

SNMP

v1, v2, v3

SQL Server

2014, 2019, and 2022

GaussDB(for MySQL)

2.0.15.6

WebSocket

N/A

Custom data sources

N/A

Data Sources Supported by Data APIs

Table 2 Data sources supported by data APIs

Data Source Type

Compatibility

Gauss100

FusionInsight_LibrA_V100R003C20 and FusionInsight_LibrA_V300R001C00

MySQL

5.6, 5.7, 8.0

MRS HBase

MRS 3.*.*

MRS Hive

MRS 3.*.*

Oracle

11g

PostgreSQL

11.0

SQL Server

2012, 2014, 2016, 2017

DWS

1.3.4

HIVE

2.3.2

HANA

1.0

MongoDB

3.4

Redis

2.8.x, 3.x.x