Blog

How to use encoded password in ODI SDK

Today I am going to share very interesting thing 😀 . I was struggling a lot to get the work around on this issue. Searched a lot over internet and didn’t get any solution.

Finally I found something that helps to an extent. I would like to give special thanks my friend Tina for her helping hand. Take a look on below code snippet. You can clearly see I have hardcoded the master repository password. Is there any ODI Admin who is going to provide the master repository credentials?? I know everyone will deny due to security issues.

You are now good to go. Actually ODI SDK is very flexible and dynamic in nature. You just need to have little idea on java basics and then dig out to explore new things. Obviously limited to the given API by Oracle.

Okay so far so good. But here we will encounter another problem. The above passoword can be easily decoded by using the decypher method. 😀

System.out.println(dg.snpsDecypher(Master_Pass).toCharArray());

Now you might be thinking what is the use this encoded password then. 😉 Any java developer can print it easily.

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page.
If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

18 comments

you know, the encoded password is written in plain text, if hacker get the file, but he/she does not know the algorithm ,maybe MD5, DES,etc. so he/she may spend some time to decode it, maybe fail finally.
even he/she choose to decompile java class, the class maybe have be obfuscated, so cannot decompile.

Yeah right, if there wouldn’t have any such security then people might not have gone for oracle product. But I am still digging on ODI SDK and trying to explore as much as I can. Lets see what is the next stop.

Disclosure

The views expressed on this blog are those of the author and do not necessarily reflect the views of Oracle. All content and s/w code on this site are offered without any warranty, or promise of operational quality or functionality.