MicroStrategy ONE

Create an ODBC DSN Connection

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

Make sure that your user or service account has at least the following Google BigQuery roles assigned at the project level.

  • BigQuery Data Owner

  • BigQuery Job User

  • BigQuery User

It may be possible to assign these roles on the dataset or table level. However, MicroStrategy has not tested these other scenarios. To learn more about granting roles to an user, see Manage access to projects, folders, and organizations in the Google IAM documentation.

  • Web
  • Workstation

  1. Create an ODBC DSN on Linux or Windows.

  2. Log into MicroStrategy Web.

  3. Navigate to the Home page.

  4. Click Create > Add External Data.

  5. Find and select the Google BigQuery (ODBC) connector from the data source list.

  6. Select the Select Tables import option and click Next.

  7. Next to Data Sources, click New Data Source to add a new connection.

  8. Enter your data source information.

    • The DSN Data Sources option must be selected.

    • From the DSN drop-down, choose the ODBC DSN created in step 1.

    • From the Version drop-down, choose Google BigQuery (Certified for DSN).

    • Enter a user, password, and data source name.

  9. Click Save. The Google BigQuery (ODBC) data source is connected using DSN connection.

The following section applies to Windows only.

  1. Create an ODBC DSN on Windows.

  2. Open MicroStrategy Workstation.

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

  4. Click New Data.

  5. Find and select the Google BigQuery (Driver) connector from the data source list.

  6. Select the Select Tables import option and click Next.

  7. Next to Data Sources, click New Data Source to add a new connection.

  8. Enter your data source information.

    • The DSN Data Sources option must be selected.

    • From the DSN drop-down, choose the ODBC DSN created in step 1.

    • From the Version drop-down, choose Google BigQuery (Certified for DSN).

    • Enter a user, password, and data source name.

  9. Click Save. The Google BigQuery (ODBC) data source is created.

  10. Click on the new data source to load the list of all namespaces.