Thursday, September 22, 2016

ODI Decrypt password

Below java code can be used to decrypt the passwords stored in Oracle Data Integrator. 



 import com.sunopsis.dwg.DwgObject;  
 public class OdiDecrypt {  
   public OdiDecrypt() {  
     super();  
   }  
   @SuppressWarnings("deprecation")  
   public static void main(String[] args) {  
     OdiDecrypt odiDecrypt = new OdiDecrypt();  
     @SuppressWarnings("deprecation")  
     String strMasterPassEnc="gHyXQ5WaJua6RFCRmP1l";  
     String strMasterPass=DwgObject.snpsDecypher(strMasterPassEnc);  
     System.out.println(strMasterPass);  
   }  
 }  





Required .jars:

apache-commons-lang.jar
odi-core.jar which is available at $ORACLE_HOME\oracledi.common\odi\lib\

1 comment:

  1. Hello Venkatesh, the above does not work in 12.2. Are you familiar with method for 12.2 to decrypt pwd for use in procedure?

    ReplyDelete