KB272383: How to configure and use the Dropbox Data Import connector in MicroStrategy Web, Workstation, and Desktop

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
Strategy Web, Workstation, and Desktop all have the ability to add external data from Dropbox. In Strategy Workstation and Desktop, there is a pre-defined Dropbox application that has Full Dropbox privileges, which provide full access to all files and folders in a user's Dropbox account.
However, Strategy Web does not contain a pre-defined Dropbox application, so users must create a new application before using the connector on Web. Additionally, if you are using Workstation or Desktop and do not want to use the default Dropbox application, you can also create a new application for those products.

How to Configure the Dropbox Application

• Log in to Dropbox using your Dropbox username and password.
• At the bottom of the page, click the More button and select Developers.
  

• Click Create Apps.
  

• Under Choose an API, select DropBox API App.
• Under Choose the type of access you need, Strategy recommends selecting Full Dropbox.
  Selecting App folder only allows you access to a single folder created specifically for the application.If your log in account does not have this folder, it will create an empty folder.
  
• Click Create app.
  

• To allow other users to access the app, select Enable additional users.
  If you want to link more than 500 users to the app, select Apply for production.
  

• If you are creating the app for Strategy Web, you need to enter information in the Redirect URIs section. According to your web type, enter the following URLs and click Add.
  ASP: https://YourWebServerHost:port/MicroStrategy/asp/Main.aspx?evt=3172
  JSP: https://YourWebServerHost:port/MicroStrategy/servlet/mstrWeb?evt=3172
  Strategy Workstation and Desktop do not require Redirect URIs.
  
• Record the App key, App secret, and Redirect URIs from this page.
  

How to set Dropbox oAuth Parameters

Strategy Web

• Open Strategy Web and click Add External Data.
• On the Connect to Your Data dialog, hover over Dropbox and click Set OAuth Parameters.
• Enter the Callback URL, Client ID, and Client Secret.
  Callback URL is https://YourWebServerHost:port/MicroStrategy/servlet/mstrWeb?evt=3172
  Client ID is the App key you recorded from the Dropbox app.
  Client Secret is your App secret you recorded from the Dropbox app.
  

• Click OK.

Strategy Workstation and Desktop

• In Strategy Workstation or Desktop, create a new dossier.
• Click New Data. The Data Sources dialog appears.
• Click Customize Shortcuts.
  

• Hover over Dropbox and click Set OAuth.
  

• Enter your Client ID and Client Secret.
  Client ID is the App key you recorded from the Dropbox app.
  Client Secret is your App secret you recorded from the Dropbox app.
  
• Click OK.

How to Use the Dropbox Data Connector

Strategy Web

1. Click the Dropbox icon and enter your credentials. 
2. Allow the app to access your documents and text files. You can now import data from Dropbox.

Strategy Workstation and Desktop

• Click the Dropbox icon and enter your credentials.
• Allow the app to access your documents and text files.
• Copy the Grant Code and paste it into the Authorization Processing dialog.
  Note: This code expires after five minutes.
  

• Click Proceed. You can now import data from Dropbox. 

Third Party Software Installation Warning:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.