https://community.cloudera.com/t5/Support-Questions/Looking-to-encrypt-data-while-copying-data-into-database/m-p/369710#M240537 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/104781">@Vas_R</a>,</P><P><BR />How would you like to encrypt that data, as I see you want to do this on each column and each row? Have you something in mind or are you searching for something built in NiFi directly? If you want something directly in NiFi, I do not think that you will find anything that specific.<BR /><BR />You could try exporting your relevant data into attributes and use something like <SPAN>CryptographicHashAttribute</SPAN> Processor in order to use a hash algorithm on those attributes. Next, you can use an AttributesToCSV/AttributesToJSON Processor and generate a new FlowFile with the hashed data. If CSV or JSON is not the best format for you, you can add an extra ConvertRecord and transform your data in whatever format you want. But be careful as this solution will require many resources if you are playing with large amounts of data.<BR /><BR />Another solution would be to find an encryption algorithm and implement it within a Script. Add an ExecuteStreamCommand Processor, which will read the AVRO File, perform the encryption and write out the newly generated AVRO File.</P> Fri, 28 Apr 2023 09:21:27 GMT cotopaul 2023-04-28T09:21:27Z