How to encrypt and decrypt a file in datastage

partha.natta · Post by **partha.natta** » Thu Feb 09, 2012 11:53 pm

I need to decrypt some files in datastage which are coming as encrypted from the source system and also after generation of new files and sending them to other location I need to encrypt them again and then need to send. Can anyone help me how can I achieve it in datastage in windows environment.

kandyshandy · Post by **kandyshandy** » Fri Feb 10, 2012 12:53 am

Partha, you said your input from source system is encrypted. If you want to decrypt them, you need the encryption/decryption software(/code) used by the source system. Once you have access to it, you can try to execute the same from DataStage to decrypt and encrypt whenever needed.

For e.g., if the encryption/decryption code is java based, then you can execute (call) the same in DataStage using Java stages and achieve what you want.

partha.natta · Post by **partha.natta** » Fri Feb 10, 2012 1:12 am

Could you please provide the detail information regarding this?
We are using windows platform and to achieve it what are the steps we need to follow, once we install the software what stage we need to use to develop the same.

pandeesh · Post by **pandeesh** » Fri Feb 10, 2012 1:35 am

Partha,
Please tell, how the source file has been encrypted.
Using which alogorithm ?
Unless that's revealed, we can't proceed for decryption.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2012 1:54 am

pandeesh wrote:Partha,
Please tell, how the source file has been encrypted.
Using which alogorithm ?
Unless that's revealed, we can't proceed for decryption.

Of course we can! The answer is "with the same software".

qt_ky · Post by **qt_ky** » Fri Feb 10, 2012 12:32 pm

Partha, Kandy has given you the complete answer already. You have not yet given sufficient details in order for anyone to provide you with a more detailed resolution.

partha.natta · Post by **partha.natta** » Mon Feb 13, 2012 1:42 am

The requirement is like this. We shall receive files from different source systems as encrypted (key protected). It can be multiple files combined in a single encrypted folder or individually encrypted file. We need to decrypt them (file and folder both in our environment through datastage and then do all kind of transformation to generate the output file.
Once we generate the output file we need to encrypt them before sending them to other location. So how can we implement the same in datastage.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 13, 2012 2:26 am

Why "through datastage"?

Who's idea was that?

pandeesh · Post by **pandeesh** » Mon Feb 13, 2012 2:48 am

You can , in a before/after job subroutine using ExecDOS by calling a batch script.
In the batch script you need to implement all those decryption mechanisms.

kandyshandy · Post by **kandyshandy** » Mon Feb 13, 2012 2:51 am

Partha, is this an ACTUAL requirement or evaluation of tool or doing any POC?

ray.wurlod · Post by **ray.wurlod** » Mon Feb 13, 2012 3:30 pm

None of that helps really. The new feature is really about enabling you to encrypt passwords for use on command lines or in authentication files.

qt_ky · Post by **qt_ky** » Mon Feb 13, 2012 9:36 pm

You have many possible options but still only you have access to the information that is key to answering your question, such as the name of the encryption software and the exe file you would call from DataStage to use it.