GaussDB 200
The Gauss 200 connector is used to connect to the Gauss 200 database by establishing and maintaining the connection between applications and the database, and managing data transmission.
- Gauss 200 adopts the Massive Parallel Processing (MPP) architecture, supports both row-based and column-based storage, and is capable of processing PB-level data.
- The default Gauss 200 port number is 25308. The administrator can change the port number as required.
Creating a Gauss 200 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 Gauss 200 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.
- 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.
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 200 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
Parameter |
Description |
---|---|
Table Name |
Name of the table where data will be queried. |
Column Name |
Column name of the data table. |
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 pagination query. |
Parameter |
Description |
---|---|
Table Name |
Name of the table where data will be inserted. |
Data to Insert |
Enter the value (enclose it in single quotation marks) to be inserted. |
Parameter |
Description |
---|---|
Table Name |
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. |
Parameter |
Description |
---|---|
Table Name |
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot