第 58 章 MySQL Sink

Send data to a MySQL Database.

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

spec:
  ...
  integration:
      ...
      dependencies:
      - "mvn:mysql:mysql-connector-java:<version>"

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

58.1. Configuration Options
复制链接

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

Expand

Property	Name	Description	Type	Default	Example
databaseName *	Database Name	The name of the MySQL Database.	string
password *	Password	The password to access a secured MySQL Database.	string
query *	Query	The query to execute against the MySQL 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 MySQL Database.	string
serverPort	Server Port	The server port for the data source.	string	3306

* = Fields marked with an asterisk are mandatory.