第75章 Microsoft SQL Server Sink

Send data to a Microsoft SQL Server Database.

In your Pipe file, you must explicitly declare the SQL Server driver dependency in spec→integration→dependencies:

This Kamelet expects a JSON-formatted body. Use key:value pairs to map the JSON fields and parameters. For example, here is a query:

'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'

Here is example input for the example query:

'{ "username":"oscerd", "city":"Rome"}'

75.1. Configuration Options
リンクのコピー

The following table summarizes the configuration options available for the sqlserver-sink Kamelet:

Expand

Property	Name	Description	Type	Default	Example
databaseName *	Database Name	The name of the SQL Server Database.	string
password *	Password	The password to access a secured SQL Server Database.	string
query *	Query	The query to execute against the SQL Server Database.	string		INSERT INTO accounts (username,city) VALUES (:#username,:#city)
serverName *	Server Name	The server name for the data source.	string		localhost
username *	Username	The username to access a secured SQL Server Database.	string
encrypt	Encrypt Connection	Encrypt the connection to SQL Server.	boolean	False
serverPort	Server Port	The server port for the data source.	string	1433
trustServerCertificate	Trust Server Certificate	Trust Server Certificate	boolean	True

* = Fields marked with an asterisk are mandatory.