2 Home

gitea_admin edited this page 2026-10-12 05:34:17 +00:00

Table of Contents

• Microsoft SQL Server Source
• Metadata
• Properties
• Dependencies

Microsoft SQL Server Source

Query data from a Microsoft SQL Server Database.

Metadata

Property	Value
Type	source
Group	SQL
Namespace	Database
Support Level	Stable
Provider	Apache Software Foundation

Properties

Name	Type	Required	Default	Description
serverName	string	✓		The server name for the data source.
serverPort	string		1433	The server port for the data source.
username	string	✓		The username to access a secured SQL Server Database
password	string	✓		The password to access a secured SQL Server Database
query	string	✓		The query to execute against the SQL Server Database
databaseName	string	✓		The name of the Database.
consumedQuery	string			A query to run on a tuple consumed
encrypt	boolean		false	Encrypt the connection to SQL Server.
trustServerCertificate	boolean		true	Trust Server Certificate
delay	integer		500	The number of milliseconds before the next poll

Dependencies

• camel:jackson
• camel:kamelet
• camel:sql
• mvn:org.apache.commons:commons-dbcp2:2.14.0