Strategy ONE

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

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. Remote desktop into the MicroStrategy server.

  2. Open a text editor with administrator privileges, navigate to C:\Program Files (x86)\Common Files\MicroStrategy\Tomcat\apache-tomcat-9.0.63\webapps\MicroStrategy\WEB-INF\xml 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 and save your changes.

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

  5. Navigate to C:\Program Files (x86)\Common Files\MicroStrategy\Tomcat\apache-tomcat-9.0.63\webapps\MicroStrategyLibrary\WEB-INF\xml and edit DBProperties.xml.

  6. Find the following line:

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

  7. Change the line to the following save your changes.

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

  8. Open the Services application and locate the Apache Tomcat 9.0 Tomcat9 service.

  9. Right-click the service and choose Restart.

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