DSXchange

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.

KT?

viewtopic.php?t=135401

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.

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

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.

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