Connecting to Data Sources
Overview
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.
Prerequisites
- Before accessing a data source, ensure that the ROMA Connect instance can connect to the network where your data source resides.
- Same VPC: The instance can directly access the data source.
- Two VPCs in the same region: Connect the instance and the data source using a peering connection. For details, see VPC Peering Connection.
- Two VPCs in two regions: Connect the instance and the data source using a peering connection. For details, see Network Communications Among VPCs Across Regions.
- Communication over the public network: Ensure that the ROMA Connect instance has been bound with an EIP.
- To enable cross-VPC communication over the private network, configure the routes between the instance and the subnet where the data source resides.
Connecting to a Data Source
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, CDM is recommended.
Data Source Connection |
Common Task Integration Mode (Source) |
Common Task Integration Mode (Destination) |
Composite Task Integration Mode (Source) |
Composite Task Integration Mode (Destination) |
---|---|---|---|---|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
Scheduled |
Scheduled |
|
Scheduled |
- |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
Real-Time |
|
Scheduled |
Scheduled, Real-Time |
Scheduled, Real-Time |
Scheduled, Real-Time |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
Scheduled |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
Scheduled, Real-Time |
Scheduled, Real-Time |
|
Scheduled |
Scheduled, Real-Time |
Scheduled, Real-Time |
Scheduled, Real-Time |
|
- |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
Scheduled, Real-Time |
- |
- |
|
Scheduled |
- |
- |
- |
|
Scheduled |
- |
- |
- |
|
Scheduled |
Scheduled, Real-Time |
Scheduled, Real-Time |
Scheduled, Real-Time |
|
Scheduled |
Scheduled, Real-Time |
- |
- |
|
Real-Time |
- |
- |
- |
|
Scheduled |
Scheduled |
- |
- |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot