KB483527: How to Configure Google API Data Import Connectors in MicroStrategy Desktop or Workstation

Configure the Google App

• Log into Google Developers using your Google account.
• Click Create Project. If you already have a project, choose it and go to step four.
  

• Name the project and click Create.
  

• On the Credentials pop-up, click Create credentials and choose OAuth client ID.
  

• If you don't have the OAuth consent screen settings enabled, a warning page appears as shown below.
  

• If you receive this warning page, make sure to set the OAuth consent screen settings before using the OAuth client ID credential.
  

• Go back to the Credentials pop-up.
• Click Create credentials and choose OAuth client ID.
• Strategy supports two kinds of application types for Workstation and Desktop: Web application and Other. If you select Web application, go to step 12 to configure different Authorized redirect URIs when you use different Google sources. If you select Other, go there is no need to configure Authorized redirect URIs.
• In Application type, choose Other (recommended) and click Create.
  

• Copy the client ID and client secret, so you can use it later and click OK. Go to step 16.
  

• In Application type, choose Web application.
• In Authorized redirect URIs enter one of the following and click Create:
  
• For Google Drive: http://127.0.0.1/oauth2redirect/google-drive
• For Google Analytics: http://127.0.0.1/oauth2redirect/google-analytics
• For Google Big Query: http://127.0.0.1/oauth2redirect/google-bigquery

• Copy the client ID and client secret, so you can use it later and click OK.
  

• If a redirect_ui_mismatch error occurs, the URI you entered in Authorized redirect URIs is not correct. Go back and enter the correct URI. Otherwise, go to the next step.
  

• Select APIs & Services and click ENABLE APIS AND SERVICES. Next, choose the API for importing data.
  

• Follow the prompts to enable Google Drive API, Google Analytics Reporting API, and/or API Library as necessary.
  If you do not enable the correct APIs, the error No external session was found for the given external source occurs. Go back and enable the correct API.
  

Set Google OAuth Parameters for Desktop or Workstation

• On the Data Import dialog, click Customize Shortcuts.
  

• Hover over Google Drive, Google Analytics, or Google BigQuery (Native API), and click Set Oauth.
  

• Enter the Client ID and Client ID that you saved earlier.
  

• Click OK.
• Click Save.

Use Google API Sources in Desktop or Workstation

Starting with Strategy version 2020, there is a browser pop-up when Google OAuth sources sign in and out. You must allow access your Google data so it can be imported into Desktop or Workstation. The procedure below details this process with Google Drive.

• On the Data Import window, click on the Google Drive icon and enter your Google credentials in the browser pop-up.
  

• Within five minutes, you must allow the app to access your Google Drive files.
  

• Go back to Desktop or Workstation to import your data.