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 connect to postgresql database from ODI 12.2.1.4 using jdbc drivers

Ramakrishna BoppanaOct 13 2022

Hi,
I am trying to connect to postgresql from odi 12.2.1.4 but got below error
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [org.postgresql.Driver]
Details:-
jdbc url given in topology - jdbc:postgresql://999.9.99:4040/testdb;
JDBC Driver name - org.postgresql.Driver
please advise

This post has been answered by Adrian_Popescu-Oracle on Oct 31 2022

Jump to Answer

Added on Oct 13 2022

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

2,172 views