This is an automated email from the ASF dual-hosted git repository. acosentino pushed a commit to branch sql-server in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 45ea5cc365831f4535c5f86ce44531f5a6632e60 Author: Andrea Cosentino <[email protected]> AuthorDate: Mon Jun 14 12:17:42 2021 +0200 Added SQL Server Sink Kamelet --- .../ROOT/assets/images/kamelets/sqlserver-sink.svg | 7 ++ docs/modules/ROOT/pages/sqlserver-sink.adoc | 78 ++++++++++++++++++++++ 2 files changed, 85 insertions(+) diff --git a/docs/modules/ROOT/assets/images/kamelets/sqlserver-sink.svg b/docs/modules/ROOT/assets/images/kamelets/sqlserver-sink.svg new file mode 100644 index 0000000..7e2fac9 --- /dev/null +++ b/docs/modules/ROOT/assets/images/kamelets/sqlserver-sink.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-sink.adoc b/docs/modules/ROOT/pages/sqlserver-sink.adoc new file mode 100644 index 0000000..42809f0 --- /dev/null +++ b/docs/modules/ROOT/pages/sqlserver-sink.adoc @@ -0,0 +1,78 @@ +// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT += image:kamelets/sqlserver-sink.svg[] Microsoft SQL Server Sink + +*Provided by: "Apache Software Foundation"* + +*Support Level for this Kamelet is: "Preview"* + +Send data to a Microsoft SQL Server Database. + +In you KameletBinding file you'll need to explicitly declare the MariaDB driver dependency, like in the following YAML snippet + +spec: + integration: + dependencies: + - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>" + +== Configuration Options + +The following table summarizes the configuration options available for the `sqlserver-sink` 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 MariaDB Database| string| | +| *query {empty}* *| Query| The Query to execute against the MariaDB Database| string| | +| *serverName {empty}* *| Server Name| Server Name for the data source| string| | `"localhost"` +| *username {empty}* *| Username| The username to use for accessing a secured MariaDB Database| string| | +| port| Port| Server Port for the data source| string| `1433`| +|=== + +NOTE: Fields marked with ({empty}*) are mandatory. + +== Usage + +This section summarizes how the `sqlserver-sink` can be used in various contexts. + +=== Knative Sink + +The `sqlserver-sink` Kamelet can be used as Knative sink by binding it to a Knative object. + +.sqlserver-sink-binding.yaml +[source,yaml] +---- +apiVersion: camel.apache.org/v1alpha1 +kind: KameletBinding +metadata: + name: sqlserver-sink-binding +spec: + source: + ref: + kind: InMemoryChannel + apiVersion: messaging.knative.dev/v1 + name: mychannel + sink: + ref: + kind: Kamelet + apiVersion: camel.apache.org/v1alpha1 + name: sqlserver-sink + properties: + databaseName: "The Database Name" + password: "The Password" + query: "The Query" + serverName: "localhost" + username: "The Username" + +---- + +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-sink-binding.yaml` file into your hard drive, then configure it according to your needs. + +You can run the sink using the following command: + +[source,shell] +---- +kubectl apply -f sqlserver-sink-binding.yaml +---- +// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT
