nifi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Payne (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (NIFI-853) Create Processors to put JSON data to a Relational Database
Date Fri, 14 Aug 2015 14:32:45 GMT

     [ https://issues.apache.org/jira/browse/NIFI-853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Mark Payne updated NIFI-853:
----------------------------
    Attachment: 0002-NIFI-853-Made-updates-to-processors.patch
                0001-NIFI-853-Added-processors-ConvertFlatJSONToSQL-PutSQ.patch

> Create Processors to put JSON data to a Relational Database
> -----------------------------------------------------------
>
>                 Key: NIFI-853
>                 URL: https://issues.apache.org/jira/browse/NIFI-853
>             Project: Apache NiFi
>          Issue Type: Task
>          Components: Extensions
>            Reporter: Mark Payne
>            Assignee: Mark Payne
>             Fix For: 0.3.0
>
>         Attachments: 0001-NIFI-853-Added-processors-ConvertFlatJSONToSQL-PutSQ.patch,
0002-NIFI-853-Made-updates-to-processors.patch
>
>
> Most of the discussion/design for these processors happened in the comments of NIFI-293,
which was the initial ticket for implementing JDBC functionality in NiFi, but was closed in
a previous version, so this ticket was created to do the work.
> The idea is to have a processor that will take in FlowFiles whose contents are arbitrary
SQL INSERT/UPDATE commands. The commands can be parameterized with the parameters' values
and types in FlowFile attributes.
> We then should have a processor that converts a JSON document into a SQL command to either
update or insert data into a database table. We will also want some other processors in the
future probably to handle other data types, such as converting XML, CSV, Avro, etc. into SQL
commands.
> This breakout gives us a nice coherence to the "do only one thing and do it well" principle
by separating the logic of handling all of the incoming formats from the logic of updating
the database.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message