Strategy started shipping the Snowflake ODBC driver with 2020 update 2 and onwards to simplify the connectivity workflow.
1. Create DSN via Strategy Connectivity Wizard
Then fill in with the necessary connection parameters.
User can either click “Test” to verify the connectivity or just go ahead and click “Finish” to complete the DSN creation.
If user wants to add more connection parameters other than above, they can manually edit DSN just created in the odbc.ini. Here is the available connection parameters: https://docs.snowflake.com/en/user-guide/odbc-parameters.html#connection-parameters
2. Create a new database instance
3. Create a new database connection
Create a database connection using the DSN created on Step 1.
4. Configure and store credentials for the login
DSN-less Connection using ODBC driver are supported in most Strategy Platforms, except for MacOS Workstation/Desktop. Here is an example shows how user can create a DSN-less connection using Snowflake ODBC driver in Strategy Web:
Then choose Snowflake:
Then fill in with the connection parameters:
Strategy started shipping the Snowflake JDBC driver with Strategy 2021 release and onwards to simplify the connectivity workflow.
JDBC driver is also shipped in MacOS Workstation/Desktop. User can connect to snowflake database by following steps:
Then fill in with the connection parameters
