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