Encryption and Decryption of fields using Datastage.

kollurianu · Post by **kollurianu** » Sun Jul 17, 2011 9:10 pm

Hi All,

Just want to encrypt only 2 fields (not the whole file) in a file and also should be able to decrypt those 2 fields in Datastage .

Any inputs , greatly appreciated.

Thanks in advance.

pandeesh · Post by **pandeesh** » Sun Jul 17, 2011 9:32 pm

I don't think there is an in built encryption and decryption mechanisms available in datastage.

But you can have your own routine for that with your own logic.

kollurianu · Post by **kollurianu** » Mon Jul 18, 2011 2:11 pm

Thanks Pandeesh for your response.

Anyways to acheive this other than creating a custom PX routine for it?

Any inputs greatly appreciated..

jwiles · Post by **jwiles** » Mon Jul 18, 2011 7:47 pm

You could always call an external filter, BuildOp or custom operator.

As Pandeesh has indicated, there's not really anything built-in to the parallel engine at this time to do this.

Regards,

pandeesh · Post by **pandeesh** » Mon Jul 18, 2011 7:57 pm

kollurianu wrote:Anyways to acheive this other than creating a custom PX routine for it?

There are ways.. right now, i am building a basic server routine for encryption with SEQ() and CHAR() functions.
You can refer this post:

viewtopic.php?p=400900