Versions Compared

Key

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

...

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.

...

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:

...