Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

JDBC protocol is used to connect to Snowflake. Snowflake JDBC driver needs to be manually copied to the operating system and accessible to the Java connector.
Download Snowflake JDBC driver. The latest version of the Snowflake JDBC driver is recommended , except (snowflake-jdbc-3.20.0.jar), for the Snowpipe Streaming storage connection - the streaming replication method currently requires JDBC driver version 3.16.1 to 3.18.0 in combination with snowflake-ingest-sdk-23.20.0.jar.
It is recommended to store the drivers in a filesystem shared between the application servers, organized in sub-directories to avoid possible conflicts (some customers connect to multiple different platforms/services). Important information is that while the path to the driver directory is defined in the storage connection (SAP GUI), the drivers themselves are loaded by the Java connector component.

...

Code Block
languagebash
$ ls -l /sapmnt/<SID>/drivers/snowflake
-rwxr-xr-x 1 <sid>adm root 69376363 Jan 15 09:45 snowflake-jdbc-3.1820.0.jar

Sample directory with both JDBC driver and Ingest SDK for Snowpipe Streaming:

Code Block
languagebash
$ ls -l /sapmnt/<SID>/drivers/snowflake_streaming
-rw-r--r-- 1 <sid>adm sapsys 52768695 Dec  1 16:31 snowflake-ingest-sdk-23.20.0.jar
-rw-r--r-- 1 <sid>adm sapsys 33471655 Jan 31 11:53 snowflake-jdbc-3.1820.0.jar

Set its ownership and permissions appropriately to <sid>adm[:sapsys].

...