ADD Driver to ODI (Oracle Data Integration)

I will demonstrate how to add additional library to ODI application, I’am using JDBC Driver for MSSQL 2005(sqljdbc4.jar) as example.

1. Download from the file JDBC for MSSQL 2005 on following url http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
2. Extract the archive file and the file should be appear like below
3. copy your sqljdbc4.jar to following directory “C:\Users\A\AppData\Roaming\odi\oracledi\userlib”, basically your user directory and paste there, the appearance should be like below

      *don’t ever put the file sqljdbc.jar file at the same directory of sqljdbc4.jar, this will trigger the issue

4. Add the reference file to the content of additional_path.txt, like following description
   flicker Tags: Odi, Oracle, BasicData

Change JDK of ODI (Oracle Data Integration)

Sometimes you want to upgrade the version of JDK in ODI client, in case your JDK  version already old, and you already defined the JDK version previously on first installation, then following method the best approach for you to choose. following method is the way to switch or change your JDK version, so these steps consider you already defined/installed the previous JDK and you want to upgrade the latest version

1. Navigate to the ODI installation and find the highlighted configuration file
2. Open the odi.conf and the content similar like following
3. change the directory of JavaHome to your latest java installation directory
4. And Restart your ODI application by close and open it again, THX
   Technorati Tags: ODI,Oracle