I have configured Redshift Data server in ODI for this i have copied the suitable JDBC drivers for Redshift in odi installed folder.
After this when I am trying to test Red shift connection from local agent it is connecting successfully. But trying to test it from standalone agent it is giving below mentioned error.
I have done below changes in Redhsift Dataserver and added the Jdbc drivers in below mentioned paths. Before testing the connection i have restarted Admin server and ODI Agents :
JDBC Driver:com.amazon.redshift.jdbc42.Driver
JDBC URL: jdbc:redshift://endpoint:port/database
Path
C:\Oracle\product\middleware\odi\odi\sdk\lib\RedshiftJDBC42-1.2.10.1009.jar
C:\Oracle\config\odidev-domain\lib\RedshiftJDBC42-1.2.10.1009.jar
C:\%APPDATA%\Roaming\odi\oracledi\userlib\RedshiftJDBC42-1.2.10.1009.jar
Error:
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.amazon.redshift.jdbc42.Driver]
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:439)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1118)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:748)
Please guide me to resolve this issue. Thank you in Advance.