Help Center/ ROMA Connect/ User Guide/ Data Source Management/ Connecting to a Gauss100 Data Source
Updated on 2024-05-07 GMT+08:00

Connecting to a Gauss100 Data Source

Overview

ROMA Connect can use the Gauss100 data source for creating data integration tasks or data APIs. Before using the Gauss100 data source, connect it to ROMA Connect.

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 Gauss100 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 database connection mode.

    • Default: The system automatically concatenates data source connection character strings based on your configured data.
    • Professional: You need to specify the data source connection string manually.

    Version Number

    Select the version number of the database to be connected. V100R003C20 and V300R001C00 are supported.

    Connection Address

    Mandatory only when Connection Mode is set to Default.

    Enter the IP address and port number for connecting the database.

    Database Name

    Mandatory only when Connection Mode is set to Default.

    Enter the name of the database to be connected.

    Connection String

    Mandatory only when Connection Mode is set to Professional.

    Enter the JDBC connection string of the Gauss100 database, in the format of jdbc:postgresql://host:port/dbname.

    • host 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 Gauss100 database to be connected.

    Username

    Enter the username for logging in to the database.

    Password

    Enter the password for logging in to the database.

    The connection configuration of the Gauss100 data source is similar to that of the DB2 data source. For details, see Connecting to a DB2 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.