Connecting to a GaussDB(for MySQL) Data Source

Overview

ROMA Connect can use the GaussDB(for MySQL) database as a data source for data integration tasks. Connect to the GaussDB(for MySQL) data source before using it.

Prerequisites

Each connected data source must belong to an integration application. Ensure that an integration application is available before connecting a data source, or create one first.

Procedure

1. Log in to the ROMA Connect console. On the Instances page, click View Console of an 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(for MySQL) and click Next.
4. Configure the data source connection information.

   Table 1 Data source connection information

   Parameter	Description
   Name	Enter a data source name. Using naming rules facilitates future search.
   Encoding Format	Default: utf-8
   Integration Application	Select the integration application to which the data source belongs.
   Description	Enter a brief description of the data source.
   Connection Mode	Select a connection mode for the database. Default Professional: JDBC is used for database connection.
   Connection Address	Mandatory only when Connection Mode is set to Default. Enter the IP address and port number for connecting the database.
   Connection String	Mandatory only when Connection Mode is set to Professional. Enter the JDBC connection string of the GaussDB(for MySQL) database, for example, jdbc:mysql://{hostname}:{port}/{dbname}?characterEncoding=utf8&useSSL=true. {hostname} indicates the IP address for connecting to the database. {port} indicates the port number for connecting to the database. {dbname} indicates the name of the database to be connected.
   Database Name	Mandatory only when Connection Mode is set to Default. Enter the name of the database to be connected.
   Encoding Format	Mandatory only when Connection Mode is set to Default. Enter the encoding format used by the database.
   Username	Enter the username for connecting to the database.
   Password	Enter the password for connecting to the database.

   The following shows how to configure data source connection.

   • Default mode
     Figure 1 Configuration example in default mode
     
   • Professional mode
     Figure 2 Configuration example in professional mode
     
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.