Page Comparison

...

Java connector is a critical middle-ware component. Please follow the steps in /wiki/spaces/ReuseLib/pages/1550812246 Java Connector Setup to set it up/upgrade to a new version before you continue. 

...

The Java runtime environment is narrowed per Snowflake JDBC driver requirement and must be installed in a 64-bit environment and requires Java 1.8 (or higher), link to the official page: https://docs.snowflake.com/en/user-guide/jdbc.html.

WARNING: In case of JCo running on JDK 16, please add a custom argument in the Advanced tab → Additional java starting arguments: -Djdk.module.illegalAccess=permit
JDK 16 introduced strong encapsulation of JDK internals (see the documentation https://www.oracle.com/java/technologies/javase/16-all-relnotes.html#JDK-8256299) that cause problems in combination with the Snowflake JDBC driver.
In JDK 17 option -Djdk.module.illegalAccess=permit does not work anymore and is therefore unusable for connection using the current Snowflake JDBC driver (for more information see https://jdkwww.oracle.com/java.net/technologies/17javase/release-notes#JDK-826685117all-relnotes.html ).

3.2 Storage Management setup

...

Storage ID - Logical name of the storage connection
Storage type - SNOW_STAGE (Snowflake internal stage)
Java connector RFC - TCP/IP RFC destination used for communication with Java connector
Account name - Name of the snowflake account without .snowflakecomputing.com domain, in format: <account name>.<region>.<platform> (more information can be found in Snowflake account name doc).
User role - Role to be used when connecting to Snowflake (parameter is not mandatory, default role is PUBLIC)
JAVA Call Repeat - Number of times failed calls should be retried
Repeat delay (seconds) - Delay between retried calls
Driver path - Absolute path to the directory containing the Snowflake JDBC driver.
NOTE: In previous versions of Storage Management, SAP logical file of type DIR (directory) was used. This is now automatically converted to a physical path.
Connection pool size - Number of connections that can be kept open in the pool, reducing resource-expensive establishment of JDBC connections.
Username - Snowflake user.
Password - User password.
Password for JDBC Connection is Hashed - Indicator whether the password is hashed (you can also create password hash manually by using report /DVD/XOR_GEN).

...

If Key Pair authentication is established according to https://docs.snowflake.com/en/user-guide/key-pair-auth.html#key-pair-authentication-key-pair-rotation, it can be configured with or without a passphrase as follows:

...