Microsoft SQL Server Sink
Provided by: "Apache Software Foundation"
Support Level for this Kamelet is: "Stable"
Send data to a Microsoft SQL Server 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 sqlserver-sink
Kamelet:
Property | Name | Description | Type | Default | Example |
---|---|---|---|---|---|
Database Name | Required The name of the SQL Server Database. | string | |||
Password | Required The password to access a secured SQL Server Database. | string | |||
Query | Required The query to execute against the SQL Server 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 SQL Server Database. | string | |||
Encrypt Connection | Encrypt the connection to SQL Server. | boolean | false | ||
Server Port | The server port for the data source. | string | 1433 | ||
Trust Server Certificate | Trust Server Certificate. | boolean | true |
Dependencies
At runtime, the sqlserver-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:sqlserver-sink"
You can now run it directly through the following command
camel run route.yaml
Microsoft SQL Server Sink Kamelet Description
Enterprise Database Platform
This Kamelet integrates with Microsoft SQL Server, a comprehensive database platform that provides enterprise-class data management and business intelligence capabilities.
JDBC Driver
Uses the Microsoft SQL Server JDBC driver for optimal connectivity and performance. The driver supports modern SQL Server features and security protocols.
Security Configuration
Provides configurable encryption and certificate trust options:
-
Connection encryption can be enabled/disabled based on security requirements
-
Server certificate trust settings can be configured for different deployment scenarios
Data Processing
Processes JSON input data through unmarshalling before SQL execution. This enables integration with modern JSON-based applications and data pipelines.
Parameterized Queries
Supports secure SQL query execution using named parameters (e.g., :#username
, :#city
) that map to JSON data fields, preventing SQL injection vulnerabilities.