Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Contributor

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

 

1 REPLY 1
Highlighted

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

Contributor

@Team

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

Thanks,

Paul

Don't have an account?
Coming from Hortonworks? Activate your account here