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\

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\

ODI 12C Studio installation

Oracle Data Integrator Studio is a developer's interface for configuring and managing ODI. To install ODI download the latest files Disk 1 & Disk 2 from OTN and extract to a local folder.



Make sure you have Java 8 installed on your system.If you have a older version of Java and would like to update to newer one use the below commands from the command prompt.

Click Start, type cmd. When the cmd.exe icon appears, right click and select Run as administrator.To add/update system environment variables permanently:

setx -m JAVA_HOME "C:\Program Files\Java\jdk1.8.0"

setx -m PATH "%PATH%;%JAVA_HOME%\bin";

Open command prompt as administrator and execute the jar file as below



















Select Standalone Installation
















Click Finish to complete installation.

Open the studio from the windows start menu.

Connecting to the Master Repository

If you have installed any previous version of Oracle Data Integrator on the same computer you are currently using, you may be asked whether or not you want to import preferences and settings from those previous installations into ODI Studio. The tasks and descriptions in this section assume that no previous versions of Oracle Data Integrator exist on your computer.

To connect to the master repository:

1. From the ODI Studio menu, select File, then select New.
   On the New gallery screen, select Create a New ODI Repository Login, then click OK.
2. On the Oracle Data Integrator Login screen, click the plus sign (+) icon to create a new login. On the Repository Connection Information screen:
   • Oracle Data Integrator Connection section:
     • Login Name: Specify a custom login name.
     • User: Specify SUPERVISOR (all CAPS).
     • Password: Specify the supervisor password of RCU Custom Variable screen.
   • Database Connection (Master Repository) section
     • User: Specify the schema user name for the Master repository. This should be prefix_ODI_REPO as specified on the Select Components screen in RCU.
     • Password: Specify the schema password for the Master repository. This was specified on the Schema Passwords screen in RCU.
     • Driver List: Select the appropriate driver for your database from the drop-down list.
     • URL: Specify the connection URL. Click on the magnifying glass icon for more information about the connection details for your driver.
   • In the Work Repository section, select  Master Repository Only.

1. Click Test to test the connection, and fix any errors. After the test is successful, click OK to create the connection.
2. Specify and confirm a new wallet password on the New Wallet Password screen.
3. After you have successfully created a new login, you are returned to ODI Studio.
   Select Connect to Repository and, when prompted, provide your new wallet password.
   After providing your wallet password, the Oracle Data Integrator Login screen appears. Provide the following information to log in:
1. In the drop-down menu in the Login Name field, select the name of the new login you just created.
2. Specify SUPERVISOR as the user name.
3. Provide the password for the Supervisor user.