I am having trouble connecting Oracle Data Modeler to a Snowflake database using a JDBC driver.
I am hoping someone can share some trouble shooting tips with me to help solve my problem.
The error I am getting when I try to test the connection is
"Status : Failure -Test failed: Driver class not found.
Verify the Driver location"
I have downloaded the jar file from the nominated spot in the Snowflake documentation.
I am able to add the jar file to Tools->Preferences->Data Model->Third Party JDBC Drivers.
When I add the data source using File->Import->Data Dictionary using
url - jdbc:snowflake://.ap-southeast-2.snowflakecomputing.com driver class - net.snowflake.client.jdbc.SnowflakeDriver I get the error when I try to Test.
I suppose the hint if 'Verify the Driver location' but didn't I specify that when I set up my preferences.
Is there a trick with path or another variable that helps with this problem?
Thanks in advance.
Don't forget to use net.snowflake.client.jdbc.SnowflakeDriver as the driver class in your JDBC application. Also, your connection string should have the following syntax: jdbc:snowflake://account_name.snowflakecomputing.com