PostgreSQL Source

Provided by: "Apache Software Foundation"

Support Level for this Kamelet is: "Stable"

Query data from a PostgreSQL Database.

Configuration Options

The following table summarizes the configuration options available for the postgresql-source Kamelet:

Property	Name	Description	Type	Default	Example
databaseName	Database Name	Required The name of the PostgreSQL Database.	string
password	Password	Required The password to access a secured PostgreSQL Database.	string
query	Query	Required The query to execute against the PostgreSQL Database.	string		INSERT INTO accounts (username,city) VALUES (:#username,:#city)
serverName	Server Name	Required The server name for the data source.	string		localhost
username	Username	Required The username to access a secured PostgreSQL Database.	string
consumedQuery	Consumed Query	A query to run on a tuple consumed.	string		DELETE FROM accounts where user_id = :#user_id
delay	Delay	The number of milliseconds before the next poll.	integer	500
serverPort	Server Port	The server port for the data source.	string	5432

Property

Name

Description

Type

Default

Example

databaseName

Database Name

Required The name of the PostgreSQL Database.

string

password

Password

Required The password to access a secured PostgreSQL Database.

string

query

Query

Required The query to execute against the PostgreSQL Database.

string

INSERT INTO accounts (username,city) VALUES (:#username,:#city)

serverName

Server Name

Required The server name for the data source.

string

localhost

username

Username

Required The username to access a secured PostgreSQL Database.

string

consumedQuery

Consumed Query

A query to run on a tuple consumed.

string

DELETE FROM accounts where user_id = :#user_id

delay

Delay

The number of milliseconds before the next poll.

integer

500

serverPort

Server Port

The server port for the data source.

string

5432

Dependencies

At runtime, the postgresql-source Kamelet relies upon the presence of the following dependencies:

camel:jackson
camel:kamelet
camel:sql
mvn:org.postgresql:postgresql:42.7.5
mvn:org.apache.commons:commons-dbcp2:2.13.0

Camel JBang usage

Prerequisites

You’ve installed JBang.
You have executed the following command:

jbang app install camel@apache/camel

Supposing you have a file named route.yaml with this content:

- route:
    from:
      uri: "kamelet:postgresql-source"
      parameters:
        .
        .
        .
      steps:
        - to:
            uri: "kamelet:log-sink"

You can now run it directly through the following command

camel run route.yaml

Kamelet source file

https://github.com/apache/camel-kamelets/blob/main/kamelets/postgresql-source.kamelet.yaml