Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to install a new jdbc driver and get it in a list to select.

793997Mar 16 2012 — edited Mar 16 2012
I have placed the driver in the directory with the rest of the drivers. and followed the instructions below.
The HUGE missing part is typing in the driver name. WHERE? I there isn't a field that I can edit to add the name.
The URL and connection string are no problem, but how do I get ODI to recognize the new driver is there and how can I select it?

This has to be something simple that I am missing. Any help would be appreciated.





Follow these steps to add a new driver for Oracle Data Integrator.

■Copy the driver packages (.zip or .jar files) to the /drivers sub-directory under the Oracle
Data Integrator installation folder (ODI_Home\oracledi\drivers) if they are not already referenced in the Java classpath.

Oracle Data Integrator will automatically detect the driver the next time it starts and will add these packages to the classpath. This must be done on each machine executing an Oracle Data Integrator component.

■If the driver is used to connect a repository and you wish to use Metadata Navigator to
connect to this repository, then copy the driver's packages in the /WEB-INF/lib sub- directory of the Metadata Navigator installation folder, then restart the application server.

Refer to the driver's documentation for specific setup operations.

Drivers added to Oracle Data Integrator do not automatically appear in the list of drivers and URL in the Oracle Data Integrator GUI. The URL and drivers must be typed in manually in the appropriate fields, using the syntax provided in the drivers' documentations.

The automatic detection of the drivers does not work on certain systems, including Windows 95 and
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2012
Added on Mar 16 2012
1 comment
1,205 views