SQL Database Connector

Read and write data from a Camunda process directly to a SQL database (e.g., Microsoft SQL Server, MySQL, PostgreSQL)

outbound io.camunda:connector-jdbc:1

Required inputs

Key	Label	Type
`database`	Select a database	string
`connection.uri`	URI	FEEL expression
`connection.host`	Host	FEEL expression
`connection.port`	Port	FEEL expression
`data.query`	SQL Query to execute	FEEL expression

Optional inputs

Key	Label	Type
`connection.authType`	Connection type	string
`connection.uriProperties`	Properties	FEEL expression
`connection.username`	Username	FEEL expression
`connection.password`	Password	secret
`connection.databaseName`	Database name	FEEL expression
`connection.properties`	Properties	FEEL expression
`data.returnResults`	Return results	string
`data.variables`	SQL Query variables	FEEL expression
`resultVariable`	Result variable	string
`resultExpression`	Result expression	FEEL expression
`errorExpression`	Error expression	FEEL expression
`retryCount`	Retries	FEEL expression
`retryBackoff`	Retry backoff	string

Apply this connector with @bpmnkit/connectors

import { applyConnectorTemplate } from "@bpmnkit/connectors" const result = applyConnectorTemplate("io.camunda.connectors.Jdbc.v1", { "database": "MARIADB", "connection.uri": "= ...", "connection.host": "= ...", "connection.port": "= ...", "data.query": "= ...", "connection.authType": "uri", "connection.uriProperties": "= ...", })