MicroStrategy ONE

Import Data from Amazon S3

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

Follow the steps below to import data from Amazon S3.

Create a Non-OAuth Data Source (IAM) Using the Data Sources Workflow

This workflow is for IAM database role creation for Amazon S3.

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

  3. Click Amazon S3.

  4. Enter the Name of the database role being created and a Description, if necessary. In Database Version, Cloud GatewayS3 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 Data Source (User Account) Using the Enterprise Security Workflow

This workflow is for OAuth database role creation for Amazon S3.

  1. Open the Workstation window.

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

  3. Select an Identity provider of Cognito with Identity Pool and User Pool.

  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 Amazon S3.

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

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

    • Change Connection Method to OAuth.

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

    • Enter the AWS Region.

  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 Amazon S3 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.