[NIFI-3676] Support Expression Language (and BEGIN and COMMIT verbs) for ConvertJSONToSQL

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Extensions
• Assignee: Unassigned
• Reporter: Matt Burgess
• Created: 06/Apr/17 16:42
• Updated: 06/Apr/17 16:42

Description

Currently, ConvertJSONToSQL allows the user to select from a drop-down list of verbs (INSERT, UPDATE, DELETE). However in automated flows, it would be nice to specify the verb via an Expression Language statement; otherwise the workaround will be a RouteOnAttribute with one ConvertJSONToSQL per verb. As we add verbs (UPSERT, BEGIN, COMMIT, etc.) this could get overly complex.

Speaking of added verbs, it would be nice to add support for BEGIN and COMMIT to help handle transactions. Although each RDBMS has their own syntax for various features of transactions, many of the popular ones (MySQL, Oracle, PostgreSQL, SQL Server) support BEGIN as a lone keyword for starting a transaction, and COMMIT to end it. This would also help simplify CDC flows (using the CaptureChangeMySQL processor in NIFI-3413, for example).