Google Cloud Storage User OAuth Connectivity

Learn to configure Google Cloud Storage OAuth connectivity.

• Google Cloud administrator configuration
• Collect connection information for database role creation

Google Cloud Administrator Configuration

The following section refers to the configuration steps on Google Cloud Storage for the User OAuth workflow.

Create and Configure the OAuth Client

1. Go to Google Cloud Platform and authenticate.
2. Select your billing project.

3. From the left navigation menu, click APIs & Services > Credentials.

   

4. Click + Create Credentials.

5. From the drop-down list, select Oauth client ID.

   

6. Complete the required fields.

   • Application Type: Select the Web Application option.
   • Name: Provide a name for your application.
   • Authorized Redirect URI: Provide the URI for MicroStrategy Web. For example, https://host:8443/MicroStrategy/servlet/mstrWeb?evt=3172, where the host is the IP for your MicroStrategy Web host.

Create a Role to Access Google Cloud Storage

A proper role is necessary to assign a user enough permission to access Google Cloud Storage.

1. From the left navigation menu, click IAM & Admin > Roles.

   

2. Create a custom role and assign the following permissions.

   • storage.buckets.get
   • storage.buckets.list
   • storage.objects.get
   • storage.objects.list

Add Users

1. From the left navigation menu, click IAM & Admin > IAM.
2. At the top of the page, click Add.
3. In the New members field, enter the user's Google account.

4. From the Select a role drop-down, choose the newly create role.

   

Collect Connection Information to Create a Database Role

The following parameters are required to access Google Cloud Storage via User OAuth authentication.

Parameter Name	Description	How to Find it
Billing Project	The Project ID where the Google Cloud Storage was built.	The project selection in Google Console
Client ID	The ID of the OAuth 2.0 client created in Create and Configure the OAuth Client.	Google Console > API & Services > Credentials > OAuth 2.0 Client IDs > your Client ID
Client Secret	The secret of the OAuth 2.0 client created in Create and Configure the OAuth Client.	Google Console > APIs & Services > Credentials > your Client ID
Callback URL	The URL that is invoked after user login. For MicroStrategy Web, it is https://host:8443/MicroStrategy/servlet/mstrWeb?evt=3172, where the host is your web’s IP or hostname.