Oracle Database Source
Provided by: "Apache Software Foundation"
Support Level for this Kamelet is: "Preview"
Query data from a Oracle Database.
In your KameletBinding file you’ll need to explicitly declare the Oracle Database driver dependency in spec→integration→dependencies
-
"mvn:com.oracle.database.jdbc:ojdbc11:<version>"
Configuration Options
The following table summarizes the configuration options available for the oracle-database-source
Kamelet:
Property | Name | Description | Type | Default | Example |
---|---|---|---|---|---|
Database Name |
Required The Database Name we are pointing. |
string |
|||
Password |
Required The password to use for accessing 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 Server Name for the data source. |
string |
localhost |
||
Username |
Required The username to use for accessing a secured Oracle Database. |
string |
|||
Consumed Query |
A query to run on a tuple consumed. |
string |
DELETE FROM accounts where user_id = :#user_id |
||
Server Port |
Server Port for the data source. |
string |
1521 |
Dependencies
At runtime, the oracle-database-source
Kamelet relies upon the presence of the following dependencies:
-
camel:jackson
-
camel:kamelet
-
camel:sql
-
mvn:org.apache.commons:commons-dbcp2:2.9.0
Usage
This section describes how you can use the oracle-database-source
.
Knative source
You can use the oracle-database-source
Kamelet as a Knative source by binding it to a Knative object.
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: oracle-database-source-binding
spec:
source:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: oracle-database-source
properties:
databaseName: The Database Name
password: The Password
query: INSERT INTO accounts (username,city) VALUES (:#username,:#city)
serverName: localhost
username: The Username
sink:
ref:
kind: Channel
apiVersion: messaging.knative.dev/v1
name: mychannel
Prerequisite
You have Camel K installed on the cluster.
Procedure for using the cluster CLI
-
Save the
oracle-database-source-binding.yaml
file to your local drive, and then edit it as needed for your configuration. -
Run the source by using the following command:
kubectl apply -f oracle-database-source-binding.yaml
Procedure for using the Kamel CLI
Configure and run the source by using the following command:
kamel bind oracle-database-source -p "source.databaseName=The Database Name" -p "source.password=The Password" -p "source.query=INSERT INTO accounts (username,city) VALUES (:#username,:#city)" -p "source.serverName=localhost" -p "source.username=The Username" channel:mychannel
This command creates the KameletBinding in the current namespace on the cluster.
Kafka source
You can use the oracle-database-source
Kamelet as a Kafka source by binding it to a Kafka topic.
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: oracle-database-source-binding
spec:
source:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: oracle-database-source
properties:
databaseName: The Database Name
password: The Password
query: INSERT INTO accounts (username,city) VALUES (:#username,:#city)
serverName: localhost
username: The Username
sink:
ref:
kind: KafkaTopic
apiVersion: kafka.strimzi.io/v1beta1
name: my-topic
Prerequisites
-
You’ve installed Strimzi.
-
You’ve created a topic named
my-topic
in the current namespace. -
You have Camel K installed on the cluster.
Procedure for using the cluster CLI
-
Save the
oracle-database-source-binding.yaml
file to your local drive, and then edit it as needed for your configuration. -
Run the source by using the following command:
kubectl apply -f oracle-database-source-binding.yaml
Procedure for using the Kamel CLI
Configure and run the source by using the following command:
kamel bind oracle-database-source -p "source.databaseName=The Database Name" -p "source.password=The Password" -p "source.query=INSERT INTO accounts (username,city) VALUES (:#username,:#city)" -p "source.serverName=localhost" -p "source.username=The Username" kafka.strimzi.io/v1beta1:KafkaTopic:my-topic
This command creates the KameletBinding in the current namespace on the cluster.