Oracle Database Sink
Provided by: "Apache Software Foundation"
Support Level for this Kamelet is: "Stable"
Send data to an Oracle Database. This Kamelet expects a JSON-formatted body. Use key:value pairs to map the JSON fields and parameters.
Configuration Options
The following table summarizes the configuration options available for the oracle-database-sink
Kamelet:
Property | Name | Description | Type | Default | Example |
---|---|---|---|---|---|
Database Name | Required The name of the Oracle Database. | string | |||
Password | Required The password to access a secured Oracle Database. | string | |||
Query | Required The query to execute against the Oracle Database. | string | INSERT INTO accounts (username,city) VALUES (:#username,:#city) | ||
Server Name | Required The server name for the data source. | string | localhost | ||
Username | Required The username to access a secured Oracle Database. | string | |||
Server Port | The server port for the data source. | string | 1521 |
Dependencies
At runtime, the oracle-database-sink
Kamelet relies upon the presence of the following dependencies:
-
camel:jackson
-
camel:kamelet
-
camel:sql
-
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:timer-source"
parameters:
period: 10000
message: 'test'
steps:
- to:
uri: "kamelet:oracle-database-sink"
You can now run it directly through the following command
camel run route.yaml
Oracle Database Sink Kamelet Description
Enterprise Database Integration
This Kamelet provides integration with Oracle Database, a leading enterprise-grade relational database management system known for its performance, reliability, and advanced features.
JDBC Connectivity
Uses Oracle’s thin JDBC driver for efficient database connectivity. The thin driver provides a pure Java implementation that doesn’t require Oracle client software installation.
Data Processing
Expects JSON input data which is unmarshalled before SQL execution. The JSON data fields can be referenced in SQL queries using named parameters for secure data binding.
Query Parameterization
Supports named parameters in SQL queries (e.g., :#username
, :#city
) that correspond to incoming JSON data fields. This provides secure, injection-resistant query execution.