Support Questions
Find answers, ask questions, and share your expertise

Nifi: Use a value from message formatted in Avro to update a record in database

Highlighted

Nifi: Use a value from message formatted in Avro to update a record in database

Contributor

Hello All,

I have an Avro message coming out of SplitAvro processor. This message contains a field and its value VAL. I want to run an update SQL against a database table as follows:

Update table X set Status='Processed' where ID = VAL;

How can I achieve this in NiFi?

Thanks!!

1 REPLY 1
Highlighted

Re: Nifi: Use a value from message formatted in Avro to update a record in database

Contributor

I was able to accomplish this by using SplitAvro --> QueryRecord --> PutSQL