KB221507: How to connect to a Vertica database in MicroStrategy Secure Enterprise Platform running on a Linux operating system

SUMMARY:
Starting with Strategy 10 Secure Enterprise Platform, in order to better align to Vertica's documentation, Vertica's [Driver] section will be removed from the odbcinst.ini. The creation of a new vertica.ini file will be required and a VERTICAINI variable will be added to the odbc.sh file to reference that vertica.ini file.
STEPS TO CONNECT TO VERTICA in Strategy 10 Secure Enterprise Platform:
Add the following entry to the ODBC.sh file. This file is located at <HOME_PATH>/env where <HOME_PATH> is the directory specified as the Home Directory of the Strategy installation on Linux.

#
# ODBC Driver for HP Vertica
#
VERTICAINI='(PATH TO THE NEWLY CREATED FILE IN STEP 3)/vertica.ini’ 

if [ "${VERTICAINI}" != '<VERTICAINI_PATH>' ]; then
                export VERTICAINI

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

Users will need to add 'write' privileges to ODBC.sh file first (chmod u+w ODBC.sh). After adding the entry, save the file and remove the 'write' privilege from this file (chmod a-w ODBC.sh).

1. Create the DSN to Vertica by manually adding the following entry to the odbc.ini file (this file is located in the Home Directory of the Strategy installation on Linux):

[TEST_VERTICA_DSN]
Description=Vertica driver
Driver=<VERTICA_ODBC_PATH>/libverticaodbc.so
Database=DATABASE
Servername=HOST
UID=USER
PWD=PASSWORD
Port=5433
ConnSettings=
Locale=en_US
DriverManagerEncoding=UTF-8
ErrorMessagesPath=<VERTICA_ODBC_PATH>

1. Create a new "vertica.ini" file with the following information:

[Driver]
DriverManagerEncoding=UTF-8
ErrorMessagesPath=/path/to/odbc/driver/lib64

1. Remove the [Driver] section located at the bottom of the Vertica DSN in the odbcinst.ini file. Also remove the "ErrorMessagesPath" parameter on top of it:

[Vertica]
Driver=<VERTICA_ODBC_PATH>/libverticaodbc.so
Description=Vertica driver
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
Setup=<VERTICA_ODBC_PATH>/libverticaodbc.so
SQLLevel=0
ConnSettings=
Locale = en_US
ErrorMessagePath=<VERTICA_ODBC_PATH>
[Driver]
DriverManagerEncoding=UTF-8

If this information is not already seen in the odbcinst.ini, add the text above without the removed sections.

1. Test connectivity to the Vertica Database using Strategy DB QueryTool.