'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