Need some help

chrisjones · Post by **chrisjones** » Tue Aug 17, 2010 2:01 pm

Hi ,

Recently I joined in new project and one person gave KT to me and left the company, today when I am running the jobs, the job is aborting due to some source data issue and when I trying to debug with different stage I am facing some issue i:e password is hard coded in the original job i:e ODBC Stage and when I am trying to use DRDBMS stage I don't the password since it is hardcoded and no one in our project team know the password...can you please tell me how to get the actual password.

chulett · Post by **chulett** » Tue Aug 17, 2010 4:24 pm

KT?

viewtopic.php?t=135401

kris007 · Post by **kris007** » Tue Aug 17, 2010 4:28 pm

My educated guess is Knowledge Transfer.

From OP's post my understanding was the password was hardcoded within the ODBC stage and not at the job parameter level. So not sure if doing an echo #Password# would work in this case.

chulett · Post by **chulett** » Tue Aug 17, 2010 4:29 pm

Good guesses, you may very well be right on both counts.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 17, 2010 4:48 pm

There's no legal way to do this.

If you export the job you will be able to find the encrypted password, then you can search DSXchange for a naughty algorithm that would allow you to decrypt it. By the time you've done that "they" may have changed the password. Change the job design to use a parameter. ALWAYS use parameters for passwords.

HariK · Post by **HariK** » Fri Sep 03, 2010 7:26 am

Do a search for 'DataStage Analysis' and most probably you would get what you are looking for.