Strategy One

Create a Google Drive Data Source

Create an OAuth Application in Google

  1. Sign in to https://console.cloud.google.com/apis/credentials.

  2. In the left navigation, click Credentials under APIs & Services.

  3. Click Create credentials and choose OAuth client ID.

  4. Expand the Application type drop-down list and choose Web application.

  5. Type an application Name and click Create.

  6. Copy the Client ID and Client secret values or click Download JSON. You will need Client ID and Client secret for future steps.

  7. Click OK.

  8. Click the application you just created.

  9. Click Add URI and add a Callback URL for Web, Library, or Workstation using the following formats:

    • Web redirect URI: https://<servername>/MicroStrategy/servlet/mstrWeb?evt=3172

    • Library redirect URI: https://<servername>/MicroStrategyLibrary/auth/DIOAuthRedirect.jsp

    • Workstation redirect URI: http://127.0.0.1

  10. Repeat step 9 for each Strategy product you want to connect to the Google Drive data source.

  11. Click Save.

Create a Google Drive Data Source

Prerequisites

You must have the Configure security settings and Create and edit database instances and connections privileges.

Create a New Authentication Service in Workstation

For more information on creating identity and access management (IAM) objects, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

  1. Open the Workstation window.

  2. In the Navigation pane, click , next to Enterprise Security.

  3. Choose Gateway Authorization and click Next.

  4. Type a Display Name.

  5. In the Select an identity provider drop-down list, choose Google.

  6. In Strategy Configuration, enter the Client ID and Client Secret you copied in Create an OAuth Application in Google.\

  7. Click Save.

Create a Google Drive Data Source

  1. If you are using Workstation:

    1. Open the Workstation window.

    2. In the Navigation pane, click , next to Data Sources.

  2. If you are using Library:

    1. Open Library.

    2. Click Create New and choose Dashboard.

    3. Click New Data and click Create a new data source.

  3. Search and choose Google Drive.

  4. Type a Name and an optional Description.

  5. Expand the Default Database Connection drop-down list and choose an existing database connection or click Add New Database Connection.

  6. To create a new database connection:

    1. Type a Name.

    2. Choose the authentication service you created in Create a New Authentication Service in Workstation.

    3. Click Save.

  7. Expand the Projects drop-down list and choose the projects to associate this database role with.

  8. Click Save.