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?
Data masking
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Tue Mar 20, 2012 7:00 am
- Location: Chennai
Data masking
Sahana
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.
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3
- Joined: Tue Mar 20, 2012 7:00 am
- Location: Chennai