Connecting to a GaussDB 200 Data Source

Overview

ROMA Connect can use GaussDB 200 as a data source for data integration tasks. Before using the GaussDB 200 data source, you need to connect it to ROMA Connect.

Prerequisites

Each connected data source must belong to an integration application. Before connecting a data source, ensure that an integration application is available. Otherwise, create an integration application in advance.

Procedure

1. Log in to the ROMA Connect console. On the Instances page, click View Console next to a specific instance.
2. In the navigation pane on the left, choose Data Sources. In the upper right corner of the page, click Access Data Source.
3. On the Default tab page, select GaussDB 200 and click Next.
4. Configure the data source connection information.

   Table 1 Data source connection information

   Parameter	Description
   Name	Enter a data source name. It is recommended that you enter a name based on naming rules to facilitate search.
   Integration Application	Select the integration application to which the data source belongs.
   Description	Enter the descriptive information.
   Connection Mode	Select a database connection mode. Default: The system automatically concatenates data source connection character strings based on configured data. Professional: You need to specify the data source connection string manually.
   Connection Address	This parameter is mandatory only if Connection Mode is set to Default. Enter the IP address and port number for connecting the database.
   Database	This parameter is mandatory only if Connection Mode is set to Default. Enter the name of the database to be connected.
   Connection String	This parameter is mandatory only if Connection Mode is set to Professional. Enter the JDBC connection string of the GaussDB 200 database, in the format of jdbc:postgresql://host:port/dbname. host indicates the IP address for connecting to the database. port indicates the port of the database. dbname indicates the name of the GaussDB 200 database to be connected.
   Username	Enter the username used for logging in to the database.
   Password	Enter the password used for logging in to the database.

   The connection configuration of the GaussDB 200 data source is similar to that of the MySQL data source. For details, see Connecting to a MySQL Data Source.

5. Click Check Connectivity to check the connectivity between ROMA Connect and the data source.
   • If the test result is Data source connected successfully, go to the next step.
   • If the test result is Failed to connect to the data source, check the data source status and connection parameters, and click Recheck until the connection is successful.
6. Click Create.