KB275528: How to connect to a Snowflake 2.x database in MicroStrategy Secure Enterprise Platform 10.2

INTRODUCTION
Strategy Secure Enterprise Platform 10.2 has been post-certified to work with Snowflake - a cloud-based Data Warehouse system. Details on how to connect to this data source is found below.
 
Driver Setup on Windows
 

1. Extract and run the driver.exe file on a windows machine to install the driver
2. From the ODBC Administrator, select the SnowflakeDSIIDriver to configure the DSN
3. The Host field should be populated with the URL provided by the snowflake team. The port is always set to 443

 
Driver Setup on Linux

1. Install the Snowflake driver in the required location.
2. Update the odbc.ini file (found in the home directory of the Strategy installation) with an entry similar to the following by adding the required entries for Server, database, account and warehouse.

[ODBC Data Sources]
SnowflakeDSIII=SnowflakeDSIIDriver

[SNowflakeDSII]
Description=Snowflake DSII
Driver=/root/Snowflake/snowflake_odbc/lib/libSnowflake.so
Locale=en-US
Server=<host_name/URL>
schema=public
account=<account_name>
database=<database_name>
port=443
warehouse=<warehouse_name>
SSL=on

#
# ODBC Driver for Snowflake
#
# Please replace <SNOWFLAKE_PATH> with the path to the folder containing 
the drivername.so file
# Please replace <SIMBAINI> below to the exact location of the 
#unixodbc.snowflake.ini file. 
#For example: /path/to/unixodbc.snowflake.ini
# Please note: The unixodbc.snowflake.ini file should include the following: 
# [Driver] 
# DriverManagerEncoding=UTF-8 
# ODBCInstLib=libodbcinst.so
#
SNOWFLAKE_PATH<SNOWFLAKE_PATH>
SIMBAINI=<SIMBAINI>
if [ "${SNOWFLAKE_PATH}" != '<SNOWFLAKE_PATH>' ]; then
 export SNOWFLAKE_PATH
 
 mstr_append_path LD_LIBRARY_PATH "${SNOWFLAKE_PATH:?}"
 export LD_LIBRARY_PATH
 
fi

if [ "${SIMBAINI}" != '<SIMBAINI>' ]; then
 export SIMBAINI
if [ ! -f "${SIMBAINI:?}" ]; then
 echo "${0##*/}: WARNING: ${SIMBAINI:?} does not exist" >&2
 fi
fi

SNOWFLAKE_PATH=/root/MicroStrategy/snowflake/snowflake_odbc/lib
SIMBAINI=/root/MicroStrategy/snowflake/snowflake_odbc/conf/unixodbc.snowflake.ini
if [ "${SNOWFLAKE_PATH}" != '<SNOWFLAKE_PATH>' ]; then
 export SNOWFLAKE_PATH
 
 mstr_append_path LD_LIBRARY_PATH "${SNOWFLAKE_PATH:?}"
 export LD_LIBRARY_PATH
 
fi

if [ "${SIMBAINI}" != '<SIMBAINI>' ]; then
 export SIMBAINI
if [ ! -f "${SIMBAINI:?}" ]; then
 echo "${0##*/}: WARNING: ${SIMBAINI:?} does not exist" >&2
 fi
fi

 6. Once the above is set, it should be possible to connect