Password In Encyrpted format

synsog · Post by **synsog** » Tue Jun 11, 2013 2:33 am

Hi All -

Is there a way Datastage can validate a password value in a txt file which is in encrypted format ?

My requirement is as follows,

We have a external application whose password to connect to Database(DB2) changes very often. They will store the encrypted value in a txt file. I need to decrypt this password value & use it in my Datastage job.

Is this possible ?

Thanks in advance
Sysnog

ray.wurlod · Post by **ray.wurlod** » Tue Jun 11, 2013 3:00 am

Only if you have the decryption algorithm.

DataStage can be used to compare encrypted strings. That is, one encrypted string with/against another encrypted string.

synsog · Post by **synsog** » Tue Jun 11, 2013 5:17 am

Thanks Ray.

The issue here is, the password is generated in Mainframe & they will store this file in Mainframe system. I am not sure how Datastage can interpret this decrypted value.

Thanks again
Synsog

ray.wurlod · Post by **ray.wurlod** » Tue Jun 11, 2013 2:24 pm

DataStage can not "interpret" anything. All it can do is compare two strings - encrypted or otherwise - to determine whether they are the same.