Hello,
I would like to look for a generate method(template) of update&insert record to database(mysql,oracle,vertica ) use NIFI processors.
I google the method that like the below steps:
1. build sql from attribute then putsql for mysql (INSERT INTO ON DUPLICATE KEY UPDATE )
2. To check the record is exists, then decided to build update sql(if exists) or build insert sql(if not exists) the putSql(oracle, vertica).
Is there a generate method(template) for any relational database?
Thanks
Paul