Is there a generate method(template) of update&insert record to database(mysql,oracle,vertica ) use NIFI processor?

[#1]

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

[#2]

@Team

Could you advise a best practices for update&insert records to any type RDBMS with NIFI processor? 

Thanks,

Paul