KB41098: How to configure MicroStrategy products to work with Vertica 5.1.x on AIX environments

This technical note outlines the procedure to configure the ODBC driver on AIX for connectivity to a Vertica database. Follow the steps below:

1. Install the Vertica 5.01.xx.xx driver files on the AIX system that will host the Strategy Intelligence Server.
2. In a console window, browse to <HOME_PATH>, where <HOME_PATH> is the directory specified as the Home Directory during Strategy installation. Browse to the env directory.
3. Add Write privileges to the ODBC.sh file using the following command:
    
   
   Sample Code/Error
   chmod u+w ODBC.sh
   
    
   
4. Edit the ODBC.sh file and add the following lines at the very end:
    
   
   Sample Code/Error
   #
   # ODBC Driver for Vertica
   #
   VERTICAINI="${HOME_PATH:?}"/odbcinst.ini
   export VERTICAINI
   
   
    
   Where HOME_PATH is the home directory of the Strategy installation.
    
   
5. Save the ODBC.sh file and remove Write privileges from the file using the following command:
    
   
   Sample Code/Error
   chmod a-x ODBC.sh
   
     
   
6. Edit the odbc.ini file and add the following entry:
    
   
   Sample Code/Error
   
    
   Description=Vertica driver
   Driver=<VERTICA_ODBC_PATH>/libverticaodbc.so
   Database=database_name
   Servername=ip_address
   UID=uid
   PWD=pwd
   Port=5433
   ConnSettings=
   Locale = en_US
   ErrorMessagePath=<VERTICA_ODBC_PATH>
   
   
    
   
7. Save the odbc.ini file.
   
8. Edit the odbcinst.ini file and add the following entry to the bottom of the section:
    
   
   Sample Code/Error
   Vertica ODBC Driver 5.1=Installed
   
    
   
9. Add the following entry to the very end of the odbcinst.ini file:
    
   
   Sample Code/Error
   
    
   Description=Vertica driver
   Driver=<VERTICA_ODBC_PATH>/libverticaodbc.so
   APILevel=0
   ConnectFunctions=YYY
   DriverODBCVer=3.52
   FileUsage=0
   Setup=<VERTICA_ODBC_PATH>/verticaodbca.so
   SQLLevel=0
   ConnSettings=
   Locale = en_US
   ErrorMessagePath=<VERTICA_ODBC_PATH>
    
   DriverManagerEncoding=UTF-8
   
   
    
   
10. Save the odbcinst.ini file.
    

  
Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.