MicroStrategy ONE

Import Data from Google Cloud Storage

This new data import experience feature was introduced in Library in MicroStrategy ONE Update 12.

Follow the steps below to import data from Google Cloud Storage.

Create a Non-OAuth Database Role Using the Data Sources Workflow

This workflow is for service account database role creation for Google Cloud Storage

  1. Log in to MicroStrategy Library Web.
  2. Go to the Data Import home page and click next to Data Catalog.

  3. Click Google Cloud Storage.

  4. Enter the Name of the database role being created and a Description, if necessary. In Database Version, Cloud Gateway GCS is selected by default.

  5. In Default Database Connection, add a new database connection and Test it. If the test fails, hover over the Connection Failed text to get more information regarding the error.

  6. Click Save.

  7. If necessary, select the pencil icon to modify the connectivity information.

  8. Select the Projects you want to associate this database role to.

  9. Test your connection.

  10. Click Save.

Create an OAuth Database Role Using the Enterprise Security Workflow

This workflow is for user account database role creation for Google Cloud Storage

  1. Open the Workstation window.

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

  3. Select an Identity provider of Google.

  4. The Library Web, Authoring Web, and Workstation URIs are automatically populated. Whitelist these URIs to use the OAuth database role in Library, Web, and Workstation.

  5. Complete the remaining fields.

  6. Click Save.

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

  8. Click Google Cloud Storage.

  9. Enter the Name of the database role being created and a Description, if necessary. In Database Version, Cloud Gateway GCS is selected by default.

  10. In Default Database Connection, add a new database connection, making the following changes:

    • Change Authentication Mode to OAuth.

    • Select the Authentication Service created for GCS under Enterprise Security.

    • Select the Billing Project.

  11. Click Save.

  12. If necessary, select the pencil icon to modify the connectivity information.

  13. Select the Projects you want to associate this database role to.

    The Test button cannot be used for OAuth workflows.

  14. Click Save.

Import Data

Once you've successfully created the required database roles, you can start importing data.

  1. Log in to MicroStrategy Library Web.
  2. Go to the Data Import home page and click next to Data Catalog.

  3. Select the Google Cloud Storage database role. The database roles created using the data sources and enterprise security workflows are visible here.

  4. Select the database role. All available buckets appear in the adjoining panel. If the database role being selected is for OAuth, a pop-up appears for entering the username/email and password.

  5. In the drop-down, select the bucket and browse the folders or files.

  6. Double-click files or drag them into the right pane.

  7. In the Preview pane, you can view the sample data and adjust the column type.

  8. Publish the cube to MicroStrategy with your selected data.