Data Sources Supported by ROMA Connect

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

**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