Forum Stats

  • 3,780,909 Users
  • 2,254,454 Discussions
  • 7,879,490 Comments

Discussions

Hooking up Oracle Data Modeler with Snowflake database using JDBC driver

Marg Brown
Marg Brown Member Posts: 7

Hi,

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://<account_name>.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.

Marg BrownDave SchleisKent Graziano

Best Answer

«1

Answers