Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use		x
Input Parameters	Array of Object	Specifies a list of maps, which contain the parameter names as keys and the value the parameter is bound to, and in which every list item represents a row to insert.	#[payload]
Transactional Action	Enumeration, one of: ALWAYS_JOIN JOIN_IF_POSSIBLE NOT_SUPPORTED	The type of joining action that operations can take regarding transactions	JOIN_IF_POSSIBLE
Query Timeout	Number	Indicates the minimum amount of time before the JDBC driver attempts to cancel a running statement. By default, no timeout is used.	0
Query Timeout Unit	Enumeration, one of: NANOSECONDS MICROSECONDS MILLISECONDS SECONDS MINUTES HOURS DAYS	A time unit that qualifies the #queryTimeout. Values specified in nanoseconds, microseconds, or milliseconds are rounded to seconds.	SECONDS
Fetch Size	Number	Indicates how many rows to fetch from the database when rows are read from a ResultSet. This property is required when streaming is true, in which case a default value of 10 is used.
Max Rows	Number	Sets the limit for the maximum number of rows that any ResultSet object generated by this message processor can contain for the given number. If the limit is exceeded, the excess rows are silently dropped.
SQL Query Text	String	The text of the SQL query to execute		x
Parameter Types	Array of Parameter Type	This parameter allows you to optionally specify the type of one or more of the parameters in the query. If a value is provided, you're not required to reference all of the parameters; but you cannot reference a parameter that is not present in the input values.
Target Variable	String	The name of a variable to store the operation's output
Target Value	String	An expression to evaluate against the operation's output and store the expression outcome in the target variable	#[payload]
Reconnection Strategy	Reconnect Reconnect Forever	A retry strategy in case of connectivity errors