1 Reply Latest reply on May 21, 2014 5:46 AM by Phanikanth

    How to add new JDBC driver to ODI 12c

    Allan Wei

      Hi,

       

      Would someone help on add new JDBC driver to ODI 12c? I need add DBF JDBC driver to ODI 12c in order to load DBase III data to the Oracle DB.

       

      Thanks,

       

      Allan

        • 1. Re: How to add new JDBC driver to ODI 12c
          Phanikanth

          Hi Allan,

           

          You can download respective Driver /jar file from support.oracle.com or from another website and place it in your loca machine and follow below steps

           

          ODI 12c Studio (and Local/No Agent)

          On Windows operating systems place the driver / jar file in: 

          \Users\<yourUserName>\AppData\Roaming\odi\oracledi\userlib
          On UNIX/Linux operating systems,

          $ODI_HOME/.odi/oracledi/userlib
          then stop and relaunch ODI and reperform operations.



          ODI 12c Standalone Agent:

          Place the driver or jar file in:

          <YourODIAgentHome>\odi\agent\lib

          Do not forget to stop and restart the Agent from either
          •the command prompt
          •or using the appropriate nodemanager

           

          Hope this may helps you to fix the issue

           

          Regards,

          Phanikanth