This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-k-examples.git
commit 03f081cbe756756f9b4466f9c345ad94d6aec6b5
Author: Andrea Cosentino <anco...@gmail.com>
AuthorDate: Thu Aug 5 07:09:42 2021 +0200
Kafka to SQLServer Skeleton
---
kamelets/kafka-to-sqlserver/README.md | 18 +++++++++++++++
kamelets/kafka-to-sqlserver/flow-binding.yaml | 28 +++++++++++++++++++++++
kamelets/kafka-to-sqlserver/log-sink.kamelet.yaml | 22 ++++++++++++++++++
3 files changed, 68 insertions(+)
diff --git a/kamelets/kafka-to-sqlserver/README.md
b/kamelets/kafka-to-sqlserver/README.md
new file mode 100644
index 0000000..af26143
--- /dev/null
+++ b/kamelets/kafka-to-sqlserver/README.md
@@ -0,0 +1,18 @@
+# Kafka to Kafka with Regex Router
+
+- Use the quickstart for https://strimzi.io/quickstarts/ and follow the
minikube guide.
+
+- The Log Sink Kamelet is not available out of the box in 1.5.0 Camel-K
release so you'll have to install it before installing the flow binding.
+
+- If camel-k has been installed in a specific namespace different from the
default one, you'll need to add a parameter to all the commands (-n
<namespace_name>)
+
+- Run the following commands
+
+ - kubectl apply -f log-sink.kamelet.yaml -n kafka
+ - kubectl apply -f flow-binding.yaml -n kafka
+
+- Check logs
+
+kamel logs kafka-to-kafka-with-regex-router
+
+You should data ingesting into the topic-1 topic, after regex router override
the topic name.
diff --git a/kamelets/kafka-to-sqlserver/flow-binding.yaml
b/kamelets/kafka-to-sqlserver/flow-binding.yaml
new file mode 100644
index 0000000..aa156fb
--- /dev/null
+++ b/kamelets/kafka-to-sqlserver/flow-binding.yaml
@@ -0,0 +1,28 @@
+apiVersion: camel.apache.org/v1alpha1
+kind: KameletBinding
+metadata:
+ name: kafka-to-sqlserver
+spec:
+ integration:
+ dependencies:
+ - "mvn:com.microsoft.sqlserver:mssql-jdbc:9.2.1.jre11"
+ source:
+ ref:
+ kind: Kamelet
+ apiVersion: camel.apache.org/v1alpha1
+ name: kafka-not-secured-source
+ properties:
+ brokers: 'my-cluster-kafka-bootstrap:9092'
+ topic: 'test-topic-1'
+ sink:
+ ref:
+ kind: Kamelet
+ apiVersion: camel.apache.org/v1alpha1
+ name: sqlserver-sink
+ properties:
+ serverName: 172.17.0.10
+ username: sa
+ password: Password!
+ query: 'INSERT INTO master.dbo.accounts (user_id,username,city) VALUES
(:#user_id,:#username,:#city)'
+ port: 1433
+ databaseName: master
diff --git a/kamelets/kafka-to-sqlserver/log-sink.kamelet.yaml
b/kamelets/kafka-to-sqlserver/log-sink.kamelet.yaml
new file mode 100755
index 0000000..a48fb41
--- /dev/null
+++ b/kamelets/kafka-to-sqlserver/log-sink.kamelet.yaml
@@ -0,0 +1,22 @@
+apiVersion: camel.apache.org/v1alpha1
+kind: Kamelet
+metadata:
+ name: log-sink
+ annotations:
+ camel.apache.org/kamelet.icon:
"data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZpZXdCb3g9IjAgMCAyNDAgMjQwIj48ZGVmcz48bGluZWFyR3JhZGllbnQgaWQ9ImEiIHgxPSIuNjY3IiB4Mj0iLjQxNyIgeTE9Ii4xNjciIHkyPSIuNzUiPjxzdG9wIG9mZnNldD0iMCIgc3RvcC1jb2xvcj0iIzM3YWVlMiIvPjxzdG9wIG9mZnNldD0iMSIgc3RvcC1jb2xvcj0iIzFlOTZjOCIvPjwvbGluZWFyR3JhZGllbnQ+PGxpbmVhckdyYWRpZW50IGlkPSJiIiB4MT0iLjY2IiB4Mj0iLjg1MSIgeTE9Ii40MzciIHkyPSIuODAyIj48c3RvcCBvZmZzZXQ9IjAiIHN0b3AtY29sb3I9IiNlZmY3Zm
[...]
+ camel.apache.org/provider: "Apache Software Foundation"
+ labels:
+ camel.apache.org/kamelet.type: "sink"
+ camel.apache.org/kamelet.group: "Log"
+spec:
+ definition:
+ title: "Log Sink"
+ description: |-
+ Log something
+ type: object
+ flow:
+ from:
+ uri: "kamelet:source"
+ steps:
+ - to:
+ uri: "log:info?showAll=true"
