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.

ODI 11g Additional Drivers to the Standalone Agent and ODI Studio

ODI 11g connect to Firebird SQL

ODI installation includes a set of Data Direct drivers for the following technologies: Oracle, Hypersonic SQL, SQL Server, Sybase ASE, and DB2 UDB. If additional drivers and open tools are needed, they must be added to the Standalone Agent and the ODI Studio.

Even though this post explains how we can connect to Firebird SQL but same steps can be used to any JDBC supported database.

Create a new physical architecture

Create a new Data Server.

Driver Class  : org.firebirdsql.jdbc.FBDriver

Sample JDBC URL: jdbc:firebirdsql://hostname:port/F:/RESPAKDB/respak.gdb

On Windows operating systems, go to the following directory (not created until after ODI Studio is launched for the first time)

%APPDATA%\odi\oracledi\userlib

This folder contains the additional_path.txt file that allows you to declare additional files or folders outside of the /userlib directory from which the ODI Studio acquires its libraries and drivers.

Sample

; Additional paths file; You can add here paths to additional libraries

; Examples:

; C:\ java\libs\myjar.jar

; C:\ java\libs\myzip.zip

; C:\java\libs\*.jar will add all jars contained in the C:\java\libs\ directory

; C:\java\libs\**\*.jar will add all jars contained in the C:\java\libs\ directory and subdirectories

C:\Users\xxxxxxx\AppData\Roaming\odi\oracledi\userlib\jaybird-full-2.1.6.jar

Now click on the Test Connection and you should be able to see the success message as below.

Now you can proceed to create the logical schema and use it in the models and reverse engineer and use in projects.