2 Home

gitea_admin edited this page 2026-03-11 14:39:26 +00:00

Table of Contents

• Oracle Database Source
• Metadata
• Properties
• Dependencies

Oracle Database Source

Query data from an Oracle Database.

In your Pipe file, you must explicitly declare the Oracle Database driver dependency in spec->integration->dependencies.

• "mvn:com.oracle.database.jdbc:ojdbc11:"

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		1521	The server port for the data source.
username	string	✓		The username to access a secured Oracle Database.
password	string	✓		The password to access a secured Oracle Database.
query	string	✓		The query to execute against the Oracle Database.
databaseName	string	✓		The name of the Oracle Database.
consumedQuery	string			A query to run on a tuple consumed.

Dependencies

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