GaussDB

The GaussDB connector allows you to connect applications with the GaussDB database, and manage data transmission.

GaussDB is a distributed relational database developed by Huawei. It uses a distributed architecture and features hybrid transactional/analytical processing (HTAP) capabilities. GaussDB supports intra-city deployment across AZs for zero data loss, petabytes of storage, and more than 1,000 nodes. It is highly available, reliable, secure, and scalable, and provides key capabilities including quick deployment, backup, restoration, monitoring, and alarm reporting for enterprises.

Creating a GaussDB Connection

Log in to the new ROMA Connect console.
In the navigation pane on the left, choose Connector. On the page displayed, click New Connection.
Select the GaussDB connector.

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. Currently, the Default mode is supported. The system automatically concatenates data source connection character strings based on configured data.
Host IP Address	Enter the IP address of the database.
Port	Enter the port number for connecting to the database.
Database Name	Enter the name of the database to be connected.
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 a record
Updating records
Deleting records

Configuring Parameters

**Table 1** Obtaining records
Parameter	Description
Table Name	Enter the name of the data table to be queried.
Field Name	Enter the fields to be queried. Separate multiple field names with commas (,).
WHERE Condition	Enter the conditions for querying data.
Order By Field	Enter the sorting field of the returned result.
Limits	Enter the number of records displayed on each page in the returned result.
Offset	Enter the offset of the pagination query.

**Table 2** Adding a record
Parameter	Description
Table Name	Enter the name of the data table to be inserted.
Data to Insert	Enter the target field value in single quotation marks.

**Table 3** Updating records
Parameter	Description
Table Name	Enter the name of the data table to be updated.
Update Data	Enter the target field value in single quotation marks.
WHERE Condition	Enter the conditions for updating data.