MicroStrategy ONE

Create a Native API Connection

You can create a native API connection for Google BigQuery. However, MicroStrategy recommends using JDBC connection. To set up JDBC-less connection, see Create a JDBC DSN-less Connection .

  1. Log into MicroStrategy Web on Linux or Windows.

  2. Navigate to the Home page.

  3. Click Create > Add External Data.

  4. Find and hover over the Google BigQuery (Native API) connector from the data source list.

  5. Click Set OAuth Parameters.

  6. Complete the required parameters.

    • The callback URL must be in the following format, where <FULLY_QUALIFIED_HOSTNAME[:OPTIONAL_PORT]> is your environment's URL and optional port:

      https://<FULLY_QUALIFIED_HOSTNAME[:OPTIONAL_PORT]>/MicroStrategy/servlet/mstrWeb?evt=3172&src=mstrWeb.3172

    • If you do not have your client ID or secret, or need to authorize your callback URL, see the Google documentation.

  7. Click OK.

  8. Select the Google BigQuery (Native API) data source.

  9. Select the Select Tables import option and click Next. The Google sign-in page appears.

  10. Log into your Google account.
  11. If your SSL certificate is not signed by a trusted certification authority (CA), you must click Advanced.

  12. If your SSL certificate is not signed by a trusted certification authority (CA), you must click Go to <HOSTNAME> (unsafe). For example, Go to microstrategy.com (unsafe).

  13. Click Allow.

  1. Retrieve your client ID and secret. For more information, see the Google documentation.

  2. Open MicroStrategy Workstation.

  3. In the Navigation pane, click , next to Dashboards.

  4. Click New Data.

  5. Find and hover over the Google BigQuery (Native API) connector from the data source list.

  6. Click Set OAuth Parameters.

  7. Enter your client ID and secret retrieved from step 1 and click OK.
  8. Select the Google BigQuery (Native API) data source.

  9. Select the Select Tables import option and click Next. The Google sign-in page appears.

  10. Log into your Google account.
  11. If your SSL certificate is not signed by a trusted certification authority (CA), click Advanced.

  12. If your SSL certificate is not signed by a trusted certification authority (CA), click Go to <HOSTNAME> (unsafe). For example, Go to microstrategy.com (unsafe).

  13. Click Allow.

    The Google BigQuery Native API data source is connected.