2 Home

gitea_admin edited this page 2026-10-12 05:33:29 +00:00

Table of Contents

• PostgreSQL Source
• Metadata
• Properties
• Dependencies

PostgreSQL Source

Query data from a PostgreSQL Database.

Metadata

Property	Value
Type	source
Group	SQL
Namespace	Database
Support Level	Stable
Provider	Apache Software Foundation

Properties

Name	Type	Required	Default	Description
serverName	string	✓		The server name for the data source.
serverPort	string		5432	The server port for the data source.
username	string	✓		The username to access a secured PostgreSQL Database.
password	string	✓		The password to access a secured PostgreSQL Database.
query	string	✓		The query to execute against the PostgreSQL Database.
databaseName	string	✓		The name of the PostgreSQL Database.
consumedQuery	string			A query to run on a tuple consumed.
delay	integer		500	The number of milliseconds before the next poll

Dependencies

• camel:jackson
• camel:kamelet
• camel:sql
• mvn:org.postgresql:postgresql:42.7.13
• mvn:org.apache.commons:commons-dbcp2:2.14.0