SHA-256 hashing for Data

Database

SHA-256 hashing for Data

Hi

I need to apply SHA-256 hashing on two columns while extracting the data. If any one has done it, please share how to do it.

Thanks

Navneet

4 REPLIES
N/A

Re: SHA-256 hashing for Data

To calculate the hash values within the DB you would need to write a UDF. A sha1 UDF is available in the download section but I am not aware of an SHA256 implementation.

Alternative is to extract the data and post process it. 

Do you use a ETL tool? Some provide hashing functions.

Re: SHA-256 hashing for Data

Yes we are using Abinitio for ETL

N/A

Re: SHA-256 hashing for Data

Did you check if as SHA256 function is available for columns?

If not ask AI, they might be able to help you.

Teradata Employee

Re: SHA-256 hashing for Data

Navneet,  I have the same need for a SHA-256 udf, did you found one?   Patrice.berube@teradata.com