How can I get the Blob file using NiFi?

[#1]

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.

[#2 · Accepted solution]

I left an answer to your SO post, basically there is a bug or two preventing BLOB transfer from source to target DBs, but I presented a possible workaround.