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.