Data masking

Noozeethullah · Post by **Noozeethullah** » Tue Mar 20, 2012 7:15 am

Hi all, This is about encrypt the data for given particular data.

For ex: I have 5 columns: Cust_Name, Address, Amt, designation and DOB. From the above 5 columns i need Cust_Name and Address data to be encrypted. I use 8.1 version. How I can achieve it in DS?

chulett · Post by **chulett** » Tue Mar 20, 2012 7:55 am

Welcome.

First off, masking is completely different from encrypting. Secondly, you need to tell us encrypted how? Were you given any requirements as to the nature of the encryption you need to do? Or do you in fact need to mask it?

qt_ky · Post by **qt_ky** » Tue Mar 20, 2012 7:39 pm

IBM offers an Optim Data Masking Pack for DataStage 8.7, which will do such masking out of the box, while maintaining relationships across tables. That is an add-on option that is new to version 8.7 (and higher). You can do some simple masking on your own, such as with Convert() functions, but those are not likely to pass any security tests or approvals.

If you truly need to encrypt data, then you can use some third party encryption tool at your company or develop your own, and call either one from DataStage jobs. As far as I know there is not a built-in function readily available for encrypting/decrypting your data, although the encrypted parameters do this internally.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 20, 2012 8:54 pm

It's really easy to encrypt data if you never need to decrypt it. For example, in 8.7, a 128-bit encryption utility is provided. But your requirement has not been made clear.

Noozeethullah · Post by **Noozeethullah** » Tue Mar 20, 2012 11:39 pm

Thanks craig,Eric and Ray. Encyrption done by unix script by unix team. Thanks once again for swift reply.