Help Center/ ROMA Connect/ User Guide(new)/ Connectors/ Databases/ DWS
Updated on 2024-11-25 GMT+08:00
View PDF
Share

DWS

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

GaussDB(DWS) is a cloud-based data warehousing solution that provides scalable, ready-to-use, and fully managed analytical database services. It adheres to ANSI/ISO SQL92, SQL99, and SQL 2003 standards, ensuring compatibility with major database ecosystems such as PostgreSQL, Oracle, Teradata, and MySQL. This makes it a competitive option for petabyte-scale big data analytics across diverse sectors.

Creating a DWS 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 DWS 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. 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.
Table 4 Deleting records

Parameter

Description

Table Name

Enter the name of the data table to be deleted.

WHERE Condition

Enter the conditions for deleting data.
Parent topic: Databases