Learning Apache Apex

JDBC output

The output operator can write the data produced by the processing pipeline to a table in the JDBC database. A concrete implementation is provided that maps fields of a POJO to columns in the target table and performs an insert operation. The operator is partitionable, although with most JDBC sinks the throughput will typically be limited by the external system and not by the operator writing to a single table.

Details about the operator and example can be found at the following links: http://apex.apache.org/docs/malhar-3.8/operators/AbstractJdbcTransactionableOutputOperator/ and https://github.com/tweise/examples/tree/master/tutorials/fileToJdbc.An example for the use of the operator to achieve exactly-once results (using MERGE) ...