Strategy One

Connect to Dropbox

Create an OAuth App in Dropbox

  1. Sign in to https://www.dropbox.com/developers/apps and create an OAuth 2.0 integration app.

  2. Choose an API and choose the type of access you need.

  3. Name your app.

  4. Click the Permissions tab and add the following scopes:

    • Account Info: account_info.read

    • Files and folders:

      • files.metadata.read

      • files.content.read

  5. In Settings > Development users, click Enable additional users.

  6. In Settings > OAuth 2, add Callback URL for Web, Library, or Workstation.

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

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

    3. Workstation redirect URI: http://127.0.01

  7. In Settings, note the App key and App secret values to later create your data source.

Create a Dropbox Data Source

Prerequisites

To create and edit authentication services, you must have the Configure security settings privilege.

To create and edit data sources, you must have the Create and edit database instances and connections privilege.

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. Expand the Type drop-down list and choose Gateway Authorization.

  4. Click Next.

  5. Type a Display Name.

  6. Expand the Select an identity provider drop-down list and choose Dropbox.

  7. In Dropbox Configuration in Client ID, enter the App key you noted above.

  8. In Client Secret, enter the App secret you noted above.

  9. Click Save.

Create a Dropbox Data Source in Mosaic Studio

  1. In Library, click Create New and choose Mosaic Model.

  2. Click Add File Storage and choose Dropbox.

  3. Type a Name.

  4. Expand the Authentication Service drop-down list and choose the authentication service you created above.

  5. Click Save.

Import Data

  1. In Add Tables, choose the Dropbox database.

  2. Login to dropbox, if needed.

  3. Select the files you want to import.

  4. Click a file name to view the sample data.

  5. Click Add to import the data.

  6. Click Proceed.

  7. View and choose suggestions, view object logical relationships, or automatically create attributes and metrics.

  8. Click Save, Save as, or Publish.

  9. If you Saveor Save as your Mosaic model:

    1. Type a Name and Description.

    2. Choose a Save in folder location.

    3. Optionally, select the check box next to Certify Mosaic Model.