You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by ac...@apache.org on 2021/06/18 13:22:08 UTC
[camel-kamelets] branch sql-server-source created (now d40c810)
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a change to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git.
at d40c810 Added SQL Server Source Kamelet
This branch includes the following new commits:
new 1c3a6f9 Added SQL Server Source Kamelet
new 1382197 Added SQL Server Source Kamelet
new d82b372 Added SQL Server Source Kamelet
new 6701e75 Added SQL Server Source Kamelet
new 35e42b2 Added SQL Server Source Kamelet
new 072f6cb Added SQL Server Source Kamelet
new d40c810 Added SQL Server Source Kamelet
The 7 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
[camel-kamelets] 05/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 35e42b2a3469c58c34f79c4f0a1368799f471012
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:20:49 2021 +0200
Added SQL Server Source Kamelet
---
sqlserver-source.kamelet.yaml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/sqlserver-source.kamelet.yaml b/sqlserver-source.kamelet.yaml
index 719f2b6..2015372 100644
--- a/sqlserver-source.kamelet.yaml
+++ b/sqlserver-source.kamelet.yaml
@@ -12,7 +12,7 @@ metadata:
camel.apache.org/kamelet.type: "source"
spec:
definition:
- title: "Microsoft SQL Server Sink"
+ title: "Microsoft SQL Server Source"
description: |-
Query data from a Microsoft SQL Server Database.
[camel-kamelets] 04/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 6701e753322e80820747526bffcf340bc0b2cf6d
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:20:12 2021 +0200
Added SQL Server Source Kamelet
---
.../assets/images/kamelets/sqlserver-source.svg | 7 ++
docs/modules/ROOT/pages/sqlserver-source.adoc | 76 ++++++++++++++++++++++
2 files changed, 83 insertions(+)
diff --git a/docs/modules/ROOT/assets/images/kamelets/sqlserver-source.svg b/docs/modules/ROOT/assets/images/kamelets/sqlserver-source.svg
new file mode 100644
index 0000000..7e2fac9
--- /dev/null
+++ b/docs/modules/ROOT/assets/images/kamelets/sqlserver-source.svg
@@ -0,0 +1,7 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- Svg Vector Icons : http://www.onlinewebfonts.com/icon -->
+<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
+<svg version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" x="0px" y="0px" viewBox="0 0 1000 1000" enable-background="new 0 0 1000 1000" xml:space="preserve">
+<metadata> Svg Vector Icons : http://www.onlinewebfonts.com/icon </metadata>
+<g><path d="M426.9,90c10.3,0-21.7-80-21.7-80S291.9,60.3,285.1,66C278.2,71.8,416.6,90,426.9,90z"/><path d="M356.9,149.5l72-44.6c-17.4,2.3-158.7-29.7-158.7-29.7c2.3,6.9,68.6,74.3,68.6,74.3L356.9,149.5L356.9,149.5z"/><path d="M461.2,166.7l-20.6-49.2l-59.5,36.6L461.2,166.7L461.2,166.7z"/><path d="M306.8,142.1l-50.3-58.9c0,0-40,27.4-34.3,34.3C227.9,124.4,306.8,142.1,306.8,142.1L306.8,142.1z"/><path d="M248.5,149.5c20.6,14.9,68.6,77.8,68.6,77.8l-18.3-60.6L248.5,149.5L248.5,149.5z"/><path d="M3 [...]
+</svg>
\ No newline at end of file
diff --git a/docs/modules/ROOT/pages/sqlserver-source.adoc b/docs/modules/ROOT/pages/sqlserver-source.adoc
new file mode 100644
index 0000000..937779b
--- /dev/null
+++ b/docs/modules/ROOT/pages/sqlserver-source.adoc
@@ -0,0 +1,76 @@
+// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT
+= image:kamelets/sqlserver-source.svg[] Microsoft SQL Server Sink
+
+*Provided by: "Apache Software Foundation"*
+
+*Support Level for this Kamelet is: "Preview"*
+
+Query data from a Microsoft SQL Server Database.
+
+In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+- "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+
+== Configuration Options
+
+The following table summarizes the configuration options available for the `sqlserver-source` Kamelet:
+[width="100%",cols="2,^2,3,^2,^2,^3",options="header"]
+|===
+| Property| Name| Description| Type| Default| Example
+| *databaseName {empty}* *| Database Name| The Database Name we are pointing| string| |
+| *password {empty}* *| Password| The password to use for accessing a secured SQL Server Database| string| |
+| *query {empty}* *| Query| The Query to execute against the SQL Server Database| string| | `"INSERT INTO accounts (username,city) VALUES (:#username,:#city)"`
+| *serverName {empty}* *| Server Name| Server Name for the data source| string| | `"localhost"`
+| *username {empty}* *| Username| The username to use for accessing a secured SQL Server Database| string| |
+| consumedQuery| Consumed Query| A query to run on a tuple consumed| string| | `"DELETE FROM accounts where user_id = :#user_id"`
+| port| Port| Server Port for the data source| string| `1433`|
+|===
+
+NOTE: Fields marked with ({empty}*) are mandatory.
+
+== Usage
+
+This section summarizes how the `sqlserver-source` can be used in various contexts.
+
+=== Knative Source
+
+The `sqlserver-source` Kamelet can be used as Knative source by binding it to a Knative object.
+
+.sqlserver-source-binding.yaml
+[source,yaml]
+----
+apiVersion: camel.apache.org/v1alpha1
+kind: KameletBinding
+metadata:
+ name: sqlserver-source-binding
+spec:
+ source:
+ ref:
+ kind: Kamelet
+ apiVersion: camel.apache.org/v1alpha1
+ name: sqlserver-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: InMemoryChannel
+ apiVersion: messaging.knative.dev/v1
+ name: mychannel
+
+----
+
+Make sure you have xref:latest@camel-k::installation/installation.adoc[Camel K installed] into the Kubernetes cluster you're connected to.
+
+Save the `sqlserver-source-binding.yaml` file into your hard drive, then configure it according to your needs.
+
+You can run the source using the following command:
+
+[source,shell]
+----
+kubectl apply -f sqlserver-source-binding.yaml
+----
+// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT
[camel-kamelets] 03/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit d82b372865d65e8ce1290f90d4ea98410cd9de6a
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:20:06 2021 +0200
Added SQL Server Source Kamelet
---
docs/modules/ROOT/nav.adoc | 1 +
1 file changed, 1 insertion(+)
diff --git a/docs/modules/ROOT/nav.adoc b/docs/modules/ROOT/nav.adoc
index 6e7c245..7f744fb 100644
--- a/docs/modules/ROOT/nav.adoc
+++ b/docs/modules/ROOT/nav.adoc
@@ -100,6 +100,7 @@
* xref:ROOT:sftp-source.adoc[image:kamelets/sftp-source.svg[] SFTP Source]
* xref:ROOT:slack-source.adoc[image:kamelets/slack-source.svg[] Slack Source]
* xref:ROOT:sqlserver-sink.adoc[image:kamelets/sqlserver-sink.svg[] Microsoft SQL Server Sink]
+* xref:ROOT:sqlserver-source.adoc[image:kamelets/sqlserver-source.svg[] Microsoft SQL Server Sink]
* xref:ROOT:ssh-source.adoc[image:kamelets/ssh-source.svg[] SSH Source]
* xref:ROOT:telegram-sink.adoc[image:kamelets/telegram-sink.svg[] Telegram Sink]
* xref:ROOT:telegram-source.adoc[image:kamelets/telegram-source.svg[] Telegram Source]
[camel-kamelets] 02/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 1382197e39bfed7a00cb887bd30ae158b61926e8
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:19:56 2021 +0200
Added SQL Server Source Kamelet
---
.../kamelets/sqlserver-source.kamelet.yaml | 95 ++++++++++++++++++++++
1 file changed, 95 insertions(+)
diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml
new file mode 100644
index 0000000..719f2b6
--- /dev/null
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml
@@ -0,0 +1,95 @@
+apiVersion: camel.apache.org/v1alpha1
+kind: Kamelet
+metadata:
+ name: sqlserver-source
+ annotations:
+ camel.apache.org/kamelet.support.level: "Preview"
+ camel.apache.org/catalog.version: "main-SNAPSHOT"
+ camel.apache.org/kamelet.icon: "data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz4NCjwhLS0gU3ZnIFZlY3RvciBJY29ucyA6IGh0dHA6Ly93d3cub25saW5ld2ViZm9udHMuY29tL2ljb24gLS0+DQo8IURPQ1RZUEUgc3ZnIFBVQkxJQyAiLS8vVzNDLy9EVEQgU1ZHIDEuMS8vRU4iICJodHRwOi8vd3d3LnczLm9yZy9HcmFwaGljcy9TVkcvMS4xL0RURC9zdmcxMS5kdGQiPg0KPHN2ZyB2ZXJzaW9uPSIxLjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiIHg9IjBweCIgeT0iMHB4IiB2aWV3Qm [...]
+ camel.apache.org/provider: "Apache Software Foundation"
+ camel.apache.org/kamelet.group: "SQL"
+ labels:
+ camel.apache.org/kamelet.type: "source"
+spec:
+ definition:
+ title: "Microsoft SQL Server Sink"
+ description: |-
+ Query data from a Microsoft SQL Server Database.
+
+ In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+ - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+ required:
+ - serverName
+ - username
+ - password
+ - query
+ - databaseName
+ type: object
+ properties:
+ serverName:
+ title: Server Name
+ description: Server Name for the data source
+ type: string
+ example: localhost
+ port:
+ title: Port
+ description: Server Port for the data source
+ type: string
+ default: 1433
+ username:
+ title: Username
+ description: The username to use for accessing a secured SQL Server Database
+ type: string
+ password:
+ title: Password
+ description: The password to use for accessing a secured SQL Server Database
+ type: string
+ format: password
+ x-descriptors:
+ - urn:alm:descriptor:com.tectonic.ui:password
+ query:
+ title: Query
+ description: The Query to execute against the SQL Server Database
+ type: string
+ example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+ databaseName:
+ title: Database Name
+ description: The Database Name we are pointing
+ type: string
+ consumedQuery:
+ title: Consumed Query
+ description: A query to run on a tuple consumed
+ type: string
+ example: 'DELETE FROM accounts where user_id = :#user_id'
+ types:
+ in:
+ mediaType: application/json
+ dependencies:
+ - "camel:jackson"
+ - "camel:kamelet"
+ - "camel:sql"
+ - "mvn:org.apache.commons:commons-dbcp2:2.8.0"
+ flow:
+ beans:
+ - name: dsBean
+ type: "#class:org.apache.commons.dbcp2.BasicDataSource"
+ property:
+ - key: username
+ value: '{{username}}'
+ - key: password
+ value: '{{password}}'
+ - key: url
+ value: 'jdbc:sqlserver://{{serverName}}:{{port}};databaseName={{databaseName}}'
+ - key: driverClassName
+ value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
+ from:
+ uri: "sql:{{query}}"
+ parameters:
+ dataSource: "#bean:{{dsBean}}"
+ onConsume: "{{?consumedQuery}}"
+ steps:
+ - marshal:
+ json:
+ library: Jackson
+ - to: "kamelet:sink"
[camel-kamelets] 06/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 072f6cbe42780cced4c67c1e85388e95766793f9
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:21:06 2021 +0200
Added SQL Server Source Kamelet
---
.../src/main/resources/kamelets/sqlserver-source.kamelet.yaml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml
index 719f2b6..2015372 100644
--- a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-source.kamelet.yaml
@@ -12,7 +12,7 @@ metadata:
camel.apache.org/kamelet.type: "source"
spec:
definition:
- title: "Microsoft SQL Server Sink"
+ title: "Microsoft SQL Server Source"
description: |-
Query data from a Microsoft SQL Server Database.
[camel-kamelets] 01/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 1c3a6f91a28602615536b3df106ad472ec2430ae
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:18:15 2021 +0200
Added SQL Server Source Kamelet
---
sqlserver-source.kamelet.yaml | 95 +++++++++++++++++++++++++++++++++++++++++++
1 file changed, 95 insertions(+)
diff --git a/sqlserver-source.kamelet.yaml b/sqlserver-source.kamelet.yaml
new file mode 100644
index 0000000..719f2b6
--- /dev/null
+++ b/sqlserver-source.kamelet.yaml
@@ -0,0 +1,95 @@
+apiVersion: camel.apache.org/v1alpha1
+kind: Kamelet
+metadata:
+ name: sqlserver-source
+ annotations:
+ camel.apache.org/kamelet.support.level: "Preview"
+ camel.apache.org/catalog.version: "main-SNAPSHOT"
+ camel.apache.org/kamelet.icon: "data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz4NCjwhLS0gU3ZnIFZlY3RvciBJY29ucyA6IGh0dHA6Ly93d3cub25saW5ld2ViZm9udHMuY29tL2ljb24gLS0+DQo8IURPQ1RZUEUgc3ZnIFBVQkxJQyAiLS8vVzNDLy9EVEQgU1ZHIDEuMS8vRU4iICJodHRwOi8vd3d3LnczLm9yZy9HcmFwaGljcy9TVkcvMS4xL0RURC9zdmcxMS5kdGQiPg0KPHN2ZyB2ZXJzaW9uPSIxLjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiIHg9IjBweCIgeT0iMHB4IiB2aWV3Qm [...]
+ camel.apache.org/provider: "Apache Software Foundation"
+ camel.apache.org/kamelet.group: "SQL"
+ labels:
+ camel.apache.org/kamelet.type: "source"
+spec:
+ definition:
+ title: "Microsoft SQL Server Sink"
+ description: |-
+ Query data from a Microsoft SQL Server Database.
+
+ In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+ - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+ required:
+ - serverName
+ - username
+ - password
+ - query
+ - databaseName
+ type: object
+ properties:
+ serverName:
+ title: Server Name
+ description: Server Name for the data source
+ type: string
+ example: localhost
+ port:
+ title: Port
+ description: Server Port for the data source
+ type: string
+ default: 1433
+ username:
+ title: Username
+ description: The username to use for accessing a secured SQL Server Database
+ type: string
+ password:
+ title: Password
+ description: The password to use for accessing a secured SQL Server Database
+ type: string
+ format: password
+ x-descriptors:
+ - urn:alm:descriptor:com.tectonic.ui:password
+ query:
+ title: Query
+ description: The Query to execute against the SQL Server Database
+ type: string
+ example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+ databaseName:
+ title: Database Name
+ description: The Database Name we are pointing
+ type: string
+ consumedQuery:
+ title: Consumed Query
+ description: A query to run on a tuple consumed
+ type: string
+ example: 'DELETE FROM accounts where user_id = :#user_id'
+ types:
+ in:
+ mediaType: application/json
+ dependencies:
+ - "camel:jackson"
+ - "camel:kamelet"
+ - "camel:sql"
+ - "mvn:org.apache.commons:commons-dbcp2:2.8.0"
+ flow:
+ beans:
+ - name: dsBean
+ type: "#class:org.apache.commons.dbcp2.BasicDataSource"
+ property:
+ - key: username
+ value: '{{username}}'
+ - key: password
+ value: '{{password}}'
+ - key: url
+ value: 'jdbc:sqlserver://{{serverName}}:{{port}};databaseName={{databaseName}}'
+ - key: driverClassName
+ value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
+ from:
+ uri: "sql:{{query}}"
+ parameters:
+ dataSource: "#bean:{{dsBean}}"
+ onConsume: "{{?consumedQuery}}"
+ steps:
+ - marshal:
+ json:
+ library: Jackson
+ - to: "kamelet:sink"
[camel-kamelets] 07/07: Added SQL Server Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sql-server-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit d40c810e8f7de665351ad56da78bbfec7baba49e
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 15:21:19 2021 +0200
Added SQL Server Source Kamelet
---
docs/modules/ROOT/nav.adoc | 2 +-
docs/modules/ROOT/pages/sqlserver-source.adoc | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/docs/modules/ROOT/nav.adoc b/docs/modules/ROOT/nav.adoc
index 7f744fb..361151a 100644
--- a/docs/modules/ROOT/nav.adoc
+++ b/docs/modules/ROOT/nav.adoc
@@ -100,7 +100,7 @@
* xref:ROOT:sftp-source.adoc[image:kamelets/sftp-source.svg[] SFTP Source]
* xref:ROOT:slack-source.adoc[image:kamelets/slack-source.svg[] Slack Source]
* xref:ROOT:sqlserver-sink.adoc[image:kamelets/sqlserver-sink.svg[] Microsoft SQL Server Sink]
-* xref:ROOT:sqlserver-source.adoc[image:kamelets/sqlserver-source.svg[] Microsoft SQL Server Sink]
+* xref:ROOT:sqlserver-source.adoc[image:kamelets/sqlserver-source.svg[] Microsoft SQL Server Source]
* xref:ROOT:ssh-source.adoc[image:kamelets/ssh-source.svg[] SSH Source]
* xref:ROOT:telegram-sink.adoc[image:kamelets/telegram-sink.svg[] Telegram Sink]
* xref:ROOT:telegram-source.adoc[image:kamelets/telegram-source.svg[] Telegram Source]
diff --git a/docs/modules/ROOT/pages/sqlserver-source.adoc b/docs/modules/ROOT/pages/sqlserver-source.adoc
index 937779b..a1d5c7a 100644
--- a/docs/modules/ROOT/pages/sqlserver-source.adoc
+++ b/docs/modules/ROOT/pages/sqlserver-source.adoc
@@ -1,5 +1,5 @@
// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT
-= image:kamelets/sqlserver-source.svg[] Microsoft SQL Server Sink
+= image:kamelets/sqlserver-source.svg[] Microsoft SQL Server Source
*Provided by: "Apache Software Foundation"*