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

["Matt Burgess (JIRA)" <ji...@apache.org>]

Matt Burgess created NIFI-3676:
----------------------------------

             Summary: Support Expression Language (and BEGIN and COMMIT verbs) for ConvertJSONToSQL
                 Key: NIFI-3676
                 URL: https://issues.apache.org/jira/browse/NIFI-3676
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Extensions
            Reporter: Matt Burgess


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).



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)