Help Center/ ROMA Connect/ User Guide(new)/ Connectors/ Databases/ GaussDB 100
Updated on 2024-04-23 GMT+08:00
View PDF

GaussDB 100

GaussDB 100 is a distributed database system developed by Huawei. It is designed for enterprise applications and features high reliability, availability, performance, and scalability, covering relational, non-relational, document, and graph database services. It also supports distributed transactions, locks, and storage for large-scale data storage and processing.

Creating a Gauss 100 Connection

  1. Log in to the new ROMA Connect console.
  2. In the navigation pane on the left, choose Connector. On the page displayed, click New Connection.
  3. Select the Gauss 100 connector.
  4. In the dialog box displayed, configure the connector and click OK.

    Parameter

    Description

    Name

    Enter the connector instance name.

    Region

    Select a region.

    Project

    Select a project.

    Instance

    Select an instance for subsequent connectivity verification.

    Connection and Security

    Select the connection mode for the database.

    • 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.

    Version

    Select the Gauss 100 version. Options are V100R003C20 and V300R001C00.

    IP Address

    Required when Connection and Security is set to Default.

    Enter the IP address of the database.

    Port

    Required when Connection and Security is set to Default.

    Enter the port number to which the database is connected.

    Database Name

    Required when Connection and Security is set to Default.

    Enter the name of the database to be connected.

    Connection String

    Required when Connection and Security is set to Professional.

    Enter the JDBC connection string of the GaussDB 100 database, for example, jdbc:postgresql://host:port/dbname.

    Username

    Enter the username used to connect to the database.

    Password

    Enter the password used to connect to the database.

    Description

    Enter the description of the connector to identify it.

Action

  • Obtaining records
  • Adding records
  • Updating records
  • Deleting records

Configuration Parameters

Table 1 Obtaining records

Parameter

Description

Table Name

Select the name of the table where data will be queried.

WHERE Condition

Enter the condition value (enclose it in single quotation marks) of the data to be queried.

Order By Field

Enter the sorting fields of the returned result.

Limits

Enter the number of records on each page in the returned result.

Offset

Enter the offset of the page-based query.
Table 2 Adding records

Parameter

Description

Table Name

Select the name of the table where data will be inserted.

Data to Insert

Enter the value (enclose it in single quotation marks) to be inserted.
Table 3 Updating records

Parameter

Description

Table Name

Select the name of the table where data will be updated.

Data to Update

Enter the updated value (enclose it in single quotation marks).

WHERE Condition

Enter the condition value (enclose it in single quotation marks) of the data to be updated.
Table 4 Deleting records

Parameter

Description

Table Name

Select the name of the table where data will be deleted.

WHERE Condition

Enter the condition value (enclose it in single quotation marks) of the data to be deleted.
Parent topic: Databases