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"}'

Metadata

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 SQL Server Database.
`encrypt`	boolean		`false`	Encrypt the connection to SQL Server.
`trustServerCertificate`	boolean		`true`	Trust Server Certificate