executeSql bind query

Question

How can I send select queries to the Oracle database to be binded with the executeSql processor in Apache NiFi 1.23.2 version?

vafs · Answer

Hello @hus,

Directly the ExecuteSQL processor does not support binding.
The input should be directly SQL query.
https://nifi.apache.org/components/org.apache.nifi.processors.standard.ExecuteSQL/

But, according to the API docs, the processor can be started via a FlowFile:
https://javadoc.io/static/org.apache.nifi/nifi-standard-processors/2.4.0/org/apache/nifi/processors/standard/ExecuteSQL.html
So technically you should be able to start this query by using ReplaceText to inject values dynamically, for example.

Sign up