Strategy ONE

Enable Google BigQuery Catalog Retrieval for Strategy Web or Library on Linux

Strategy can retrieve catalog information using JDBC/ODBC or SQL catalog retrieval mode. However, SQL catalog retrieval is disabled by default for Google BigQuery.

This topic covers enabling catalog retrieval in MicroStrategy 2021 Update 7 and older. Starting in MicroStrategy 2021 Update 8, this setting is enabled by default.

  1. Connect to the MicroStrategy server using SSH.

  2. Navigate to /opt/apache/tomcat/latest/webapps/MicroStrategy/WEB-INF/xml and edit DBProperties.xml.

  3. Find the following line.

    Copy 
    <dbType n="GoogleBigQuery" v="4700" disp="1" catSQL="0"/>

  4. Change the line to the following.

    Copy 
    <dbType n="GoogleBigQuery" v="4700" disp="1" catSQL="1"/>

  5. Save your changes and exit the editor.

  6. Navigate to /opt/apache/tomcat/latest/webapps/MicroStrategyLibrary/WEB-INF/xml and edit DBProperties.xml.

  7. Find the following line.

    Copy 
    <dbType n="GoogleBigQuery" v="4700" disp="1" catSQL="0"/>

  8. Change the line to the following.

    Copy 
    <dbType n="GoogleBigQuery" v="4700" disp="1" catSQL="1"/>

  9. Save your changes and exit the editor.

  10. Stop the Apache Tomcat web server by executing the following command:

    Copy 
    /opt/apache/tomcat/latest/bin/shutdown.sh

  11. Start the Apache Tomcat web server by executing the following command:

    Copy 
     /opt/apache/tomcat/latest/bin/startup.sh

    To switch catalog retrieval from JDBC/ODBC to SQL mode, see Switch Catalog Retrieval from JDBC/ODBC to SQL Query Mode