Hi Team, I have a table in Oracle DB with one column holding BLOB data. Does NiFi support Blob file from oracle to postgressql? if yes, what are the processors do I need to use for convert and store the data? I want to see the original content of the blob data in postgressql. Thank you. ... View more

Hi Team, I have two questions, can anyone help me 1) How will I get the sysdate -1 updated records using NiFi(Ex: I have a timestamp 09:00 today but when I get incremental the processor need to check since 09:01 yesterday or else less than 2 hours of timestamp)? 2) When delete happens in the source how will affect in target? and I need to store delete records in another table in the target how will I achieve using NiFi? Thank you. ... View more

Hi Team, Please help me on the below issue I am ingesting the Data From Oracle to PostgresSql Using NiFi. We have huge data and continuously generating from sources, I want to update attributes and delete attributes using NiFi My Flow is: QueryDatabaseRecord-->UpdateAttribute-->PutDatabaseRecord when matched record found on the final table then define which action you need to take either Update (or) Delete if the record not matched in the final dataset then insert the record. Appreciate your help. Thank you, ... View more