'ODI connection to Snowflake using JDBC driver
I followed all the steps mentioned for ODI to connect to Snowflake and I am able to connect 'without agent'
I also 'unset' the SSL/TLS parameter using code below but still ODI is not able to connect to Snowflake when I use ODI Agent
ODI_SSL_PROPERTIES=""
what else I should try?
Error that I get when using ODI Agent is:
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [net.snowflake.client.jdbc.SnowflakeDriver]
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:475)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1988)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:1023)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$12.doInBackground(SnpsDialogTestConnet.java:981)
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)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|