KB45674: How to configure the Simba BigQuery ODBC driver on Linux for connectivity to a Google BigQuery database in MicroStrategy 9.x-10.x

Summary:
Follow the steps below to configure the Simba BigQuery ODBC driver on Linux for use with Strategy 9.x -10x:

1. Install the Simba BigQuery ODBC files on the Linux system that will host the Strategy Intelligence Server.
2. Create a DSN to the Google BigQuery database 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):

[ODBC Data Sources]  
Sample Simba BigQuery DSN 32=Simba BigQuery ODBC Driver 32-bit     
[Sample Simba BigQuery DSN 32]  
Description=Simba BigQuery ODBC Driver (32-bit) DSN  
Driver=[ODBC_INSTALL_PATH]/lib/32/libsimbabigqueryodbc32.so  
Catalog=[CATALOG_ID]  
MaxRequestsPerSecond=0  
RefreshToken=[REFRESH_TOKEN]  
UseNativeQuery=0  
DriverUnicodeEncoding=2

1.  Save and close the odbc.ini file.
2. Add the settings for environment variables by manually adding the following entry to the end of the /env/ODBC.sh file:

#  
# ODBC Driver for Simba Google BigQuery  
#  
BIGQUERY_PATH='[ODBC_INSTALLDIR]'  
   
if [ "${BIGQUERY_PATH}" != '' ]; then  
         export BIGQUERY_PATH  
   
         SIMBAINI="${BIGQUERY_PATH:?}"/Setup/simba.bigqueryodbc.ini  
         export SIMBAINI  
         mstr_append_path LD_LIBRARY_PATH "${BIGQUERY_PATH:?}"/lib/32  
         export LD_LIBRARY_PATH  
fi

1. Save and close the ODBC.sh file.
2. Open the odbcinst.ini file and add the following (this file is located in the Home Directory of the Strategy installation on Linux) :

[ODBC Drivers]  
Simba BigQuery ODBC Driver 32-bit=Installed  
   
[Simba BigQuery ODBC Driver 32-bit]  
Description=Simba BigQuery ODBC Driver (32-bit)  
Driver=[ODBC_INSTALL_PATH]/lib/32/libsimbabigqueryodbc32.so

1. Save and close the odbcinst.ini file.
2. Open the “samba.bigqueryodbc.ini” file located under: [ODBC_INSTALLDIR]/Setup and modify the following two lines: 

DriverManagerEncoding=UTF-8  
ErrorMessagesPath=[ODBC_INSTALLDIR]/ErrorMessages/