PostgreSQL
The PostgreSQL connector allows you to connect applications with the PostgreSQL database, and manage data transmission.
- PostgreSQL is a full-featured, open-source object-relational database.
- The default PostgreSQL port number is 5432. The administrator can change the port number as required.
Creating a PostgreSQL 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 PostgreSQL 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 PostgreSQL database, for example, jdbc:postgresql://{hostname}:{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
- Replicating records
- Obtaining incremental records
- Deleting records
- Custom SQL
Configuring Parameters
The PostgreSQL connector supports English table names only.
Parameter |
Description |
---|---|
Table Name |
Select or enter the table name in the database to be queried. |
Field Name |
Select the field name of the data table to be queried. |
WHERE Condition |
Set the condition value in single quotation marks. |
Order By Field |
Enter the sorting field 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 |
Select or enter the name of the table to which data is to be inserted. |
Data to Insert |
Enter the target field value in single quotation marks. |
Parameter |
Description |
---|---|
Table Name |
Select or enter the name of the table where data is to be updated. |
Update Data |
Enter the target field value in single quotation marks. |
WHERE Condition |
Set the condition value in single quotation marks. |
Parameter |
Description |
---|---|
Table Name |
Select or enter the name of the table where data is to be replicated. |
Clear Table |
Whether to clear the table each time data is replicated. |
Parameter |
Description |
---|---|
Table Name |
Select or enter the name of the table to obtain incremental records. |
Field Name |
Select the field name of the data table to be queried. |
WHERE Condition |
Set the condition value in single quotation marks. |
Order By Field |
Enter the sorting field of the returned result. |
Start Timezone for incremental database selection |
Start time zone for obtaining incremental data. |
Incremental Selection Timestamp Field Name |
Timestamp field for obtaining incremental data. |
Incremental Selection Timestamp Initial Value |
Initial timestamp for obtaining incremental data. |
Reset Initial Incremental Selection Time |
Whether to enable the reset of the initial time for obtaining incremental data. |
Incremental Selection Compensation Period (ms) |
Time compensation for obtaining incremental data. |
Parameter |
Description |
---|---|
Table Name |
Select or enter the name of the table where data is to be deleted. |
WHERE Condition |
Set the condition value in single quotation marks. |
Parameter |
Description |
---|---|
Statement |
Enter the native SQL statement for operating the database.
|
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