Connecting to a Backend Data Source
Overview
Before creating a data API, connect to a data source to read data from. Access configuration varies depending on the data source type.
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.
- Communication over the public network: Ensure that the ROMA Connect instance has been bound with an EIP.
- To enable cross-VPC private access, configure the routes between the instance and the subnet where the data source resides.
- Users who connect to a data source must have permission to create a session for connecting to the database.
- For details about the data source versions supported by ROMA Connect, see Supported Data and Protocols.
Connecting to a Data Source
The configuration for data source connection varies with data source types. After a data source is connected, click its name to view details, which include relevant task information.
- Connecting to a DWS Data Source
- Connecting to a DM Data Source
- Connecting to a Gauss100 Data Source
- Connecting to a HANA Data Source
- Connecting to a HIVE Data Source
- Connecting to a MongoDB Data Source
- Connecting to a MySQL Data Source
- Connecting to an Oracle Data Source
- Connecting to a PostgreSQL Data Source
- Connecting to a Redis Data Source
- Connecting to an SQL Server Data Source
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.