Connecting to Data Sources

Before creating a data integration task, you need to connect data sources at the source and destination to ROMA Connect so that data can be read from the source and written to the destination.

The configuration for data source connection varies depending on data source types. After a data source is connected, click the data source name to view the data source details, which include relevant task information.

ROMA Connect data integration is applicable to data type conversion and integration between heterogeneous data sources. DRS is recommended for data migration and synchronization between mainstream databases. In scenarios where data such as relational database data, big data, and text is migrated to the data lake, DataArts Studio is recommended.
If the destination data source is FI Hive or MRS Hive, the source data source can only be API, MQS, or SAP.

**Table 1** Configurations for data source connections
Data Source Connection	Integration Mode at the Source	Integration Mode at the Destination
Connecting to an API Data Source	Real-time	Scheduled and real-time
Connecting to an ActiveMQ Data Source	Real-time	Scheduled and real-time
Connecting to an ArtemisMQ Data Source	Real-time	Scheduled and real-time
Connecting to a DB2 Data Source	Real-time	Scheduled and real-time
Connecting to a DIS Data Source	Real-time	Scheduled and real-time
Connecting to a DWS Data Source	Real-time	Scheduled and real-time
Connecting to a GaussDB 100 Data Source	Real-time	Scheduled and real-time
Connecting to a GaussDB 200 Data Source	Real-time	Scheduled and real-time
Connecting to an FTP Data Source	Real-time	Real-time
Connecting to an FI HDFS Data Source	Real-time	Scheduled and real-time
Connecting to an FI Hive Data Source	Real-time	Scheduled and real-time
Connecting to an FI Kafka Data Source	Real-time	Scheduled and real-time
Connecting to an HL7 Data Source	Real-time	Scheduled and real-time
Connecting to a HANA Data Source	Real-time	-
Connecting to a HIVE Data Source	Real-time	Scheduled and real-time
Connecting to an LDAP Data Source	Real-time	-
Connecting to an IBM MQ Data Source	Real-time	Scheduled and real-time
Connecting to a Kafka Data Source	Real-time	Scheduled and real-time
Connecting to a MySQL Data Source	Real-time	Scheduled and real-time
Connecting to a MongoDB Data Source	Real-time	Scheduled and real-time
Connecting to an MRS Hive Data Source	Real-time	Scheduled and real-time
Connecting to an MRS HDFS Data Source	Real-time	Scheduled and real-time
Connecting to an MRS HBase Data Source	Real-time	Scheduled and real-time
Connecting to an MRS Kafka Data Source	Real-time	Scheduled and real-time
Connecting to an OBS Data Source	Real-time	Real-time
Connecting to an Oracle Data Source	Real-time	Scheduled and real-time
Connecting to a PostgreSQL Data Source	Real-time	Scheduled and real-time
Connecting to a Redis Data Source	-	Scheduled and real-time
Connecting to a RabbitMQ Data Source	Real-time	Scheduled and real-time
Connecting to an SAP Data Source	Real-time	-
Connecting to an SNMP Data Source	Real-time	-
Connecting to a SQL Server Data Source	Real-time	Scheduled and real-time
Connecting to a TaurusDB Data Source	Real-time	Scheduled and real-time
Connecting to a WebSocket Data Source	Real-time	-
Connecting to a Custom Data Source	Scheduled and real-time	Scheduled and real-time