Connecting to a 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 your data source is in.
  • Same VPC: Let the instance directly access the data source.
  • Two VPCs in the same region: Connect the instance and the data source with a peering connection. For details, see VPC Peering Connection.
  • Two VPCs in two regions: Create a cloud connection and load the VPCs that need to communicate with each other. 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 private access, configure the routes between the instance and the subnet your data source is in.

Connecting to a Data Source

• 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