Hi All
Is there any built in function available in datastage to encrypt and decrypt a field present in a *.csv file?
Thanks,
Snehal
Encrypting a column in Datastage 9.1
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Out of curiosity, what kind of encryption are you thinking about / needing to do? And just to be clear, this is about handling an encrypted column in a file, this rather than taking a single column from a file and encrypting it in some other target, yes?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 11
- Joined: Tue May 10, 2011 2:39 am
- Location: Bangalore
Encrypting a column in Datastage 9.1
Currently we are using encryption function in netezza to achieve this, as the target DB is Netezza .But now the requirement has changed and we need to use encryption function (built in) in DS.
In Informatica we have AES_ENCRYPT and DECRYPT to do this.
So I was curious, if the newer version of DS has any such kind of functions?
Source csv ->Target Netezza
Thanks,
Snehal Patil
In Informatica we have AES_ENCRYPT and DECRYPT to do this.
So I was curious, if the newer version of DS has any such kind of functions?
Source csv ->Target Netezza
Thanks,
Snehal Patil
Why? Any idea what is driving this "need"? You've got something that is working, after all.
As noted by Ray, there is only encryption with this being what I assume he meant. However, it does not note the type of encryption - a critical piece of information if you ever want to be able to decrypt it. Also note that it says you can "create and configure your own encryption provider. If you want to provide your own encryption, you can do so by creating an implementation of the EncryptionProvider interface." which means you could roll up whatever you needed and leverage it via this interface. More discussion of other aspects of this here including mention of the Encode/Decode stages which you could look into. An exact search here will turn up several more.
Make sure whatever path you choose is something Netezza supports and can decrypt... Netezza or whatever tool / app will be tasked with that.
![Confused :?](./images/smilies/icon_confused.gif)
As noted by Ray, there is only encryption with this being what I assume he meant. However, it does not note the type of encryption - a critical piece of information if you ever want to be able to decrypt it. Also note that it says you can "create and configure your own encryption provider. If you want to provide your own encryption, you can do so by creating an implementation of the EncryptionProvider interface." which means you could roll up whatever you needed and leverage it via this interface. More discussion of other aspects of this here including mention of the Encode/Decode stages which you could look into. An exact search here will turn up several more.
Make sure whatever path you choose is something Netezza supports and can decrypt... Netezza or whatever tool / app will be tasked with that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: