Strategy ONE

Create a Google BigQuery ODBC DSN for Workstation and Web on Windows

  1. Log into your Windows machine.
  2. In the left bottom corner, click Start.
  3. Search for ODBC Data Sources (64-bit) and open it. The ODBC Data Source Administrator (64-bit) window appears.
  4. Go to the System DSN tab.
  5. Click Add.
  6. Select a platform for which you want to create the ODBC connection.

    • If creating an ODBC connection for Web on Windows, select Strategy Google BigQuery ODBC Driver and click Finish.

    • If creating an ODBC connection for Workstation, select Strategy Google BigQuery ODBC Driver Client and click Finish.

      If you do not select the Strategy Google BigQuery ODBC Driver Client option, the connection will not be visible nor usable in Strategy Workstation.

  7. In the Strategy ODBC Driver for Google BigQuery DSN Setup dialog, enter a data source name.
  8. From the OAuth Mechanism drop-down, choose User Authentication.
  9. Click Sign In.
  10. Log into your Google account.
  11. Click Allow to allow Strategy to access your Google BigQuery data.
  12. Copy the confirmation code that is displayed and close the dialog. You are returned back to the Strategy ODBC Driver for Google BigQuery DSN Setup dialog.
  13. In the Confirmation Code field, paste the confirmation code.

  14. Click the Refresh Token field. The refresh token is automatically populated with your refresh token.

  15. Select a catalog (project) and dataset.

    The selected catalog or project is also your billing project.

  16. Click Advanced Options to configure additional parameters.

    The following are additional parameters:

    • EnableHTAPI enables the high throughput API or faster data transfer. For example, EnableHTAPI=1;.

    • AdditionalProjects allows loading datasets from multiple projects. The value for this parameter is a comma separated list of additional projects. The final list of datasets contains all datasets from the default project and the additional projects listed as a value of this parameter. For example, AdditionalProjects=MicroStrategyProject1,MicroStrategyProject2,MicroStrategyProject3;.

  17. Click OK.

  18. Click Test. A dialog with a success message returns.