2 Home
gitea_admin edited this page 2026-03-11 14:38:42 +00:00

MariaDB Sink

Send data to a MariaDB Database.

In your Pipe file, you must explicitly declare the MariaDB Server driver dependency in spec->integration->dependencies.

  • "mvn:org.mariadb.jdbc:mariadb-java-client:"

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

Property Value
Type sink
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 3306 The server port for the data source.
username string The username to access a secured MariaDB Database.
password string The password to access a secured MariaDB Database.
query string The query to execute against the MariaDB Database.
databaseName string The name of the MariaDB Database.

Dependencies

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