MicroStrategy ONE

Import Data from a Dropbox File

You can import data from a file stored on Dropbox directly into MicroStrategy Workstation.

The following file types can be used to import data:

  • .xlsx
  • .xls
  • .txt
  • .csv
  • .json
  • .sas7bdat

  • .geojson

  • .kml

If you are importing sas7bat files, the amount of memory available for the reader is controlled by the JVM Heap Size setting on the corresponding Intelligence Server or MicroStrategy Workstation machine.

Configure the OAuth parameters. You will need the Client ID and Client Secret that Dropbox provides when MicroStrategy Workstation is configured as a remote access application.

To Import Data from a Dropbox File

  1. Create a blank dashboard or open an existing one.

  2. Choose Add Data > New Data to import data into a new dataset.

    or

    In the Datasets panel, click More next to the dataset name and choose Edit Dataset to add data to the dataset. The Preview Dialog opens. Click Add a new table.

    The Data Sources dialog opens.

  1. Click Dropbox.
  2. At the prompts, sign into your Dropbox account and allow MicroStrategy to access your Dropbox data.
  3. Your Dropbox files and folders appear in the left pane.
  4. If necessary, expand folders to view the files in them.
  5. Press and hold the Ctrl key to select multiple files. Drag the files to right pane.
  6. If necessary, click Refresh to refresh the contents of your Dropbox account and retrieve up-to-date files.
  7. If you need to access files in another Dropbox account, click Sign Out and sign into the other Dropbox account.

  1. Click Prepare Data if you are adding a new dataset and want to preview, modify, and specify import options.. preview, modify, and specify import options.

    or

    Click Add if you are editing an existing dataset.

  2. Click Finish if you are adding a new dataset and go to the next step.

    or

    Click Update Dataset if you are editing an existing dataset and skip the next step.

    3. If you are using MicroStrategy ONE Update 12 or later, the following three steps do not apply.

  3. The Data Access Mode dialog opens.

    Click Connect Live to connect to a live database when retrieving data. Connecting live is useful if you are working with a large amount of data, when importing into the dossier may not be feasible. Go to the last step.

    or

    Click Import as an In-memory Dataset to import the data directly into your dossier. Importing the data leads to faster interaction with the data, but uses more RAM memory. Go to the last step.

  4. The Publishing Status dialog opens.

    If you are editing a connect live dataset, the existing dataset is refreshed and updated.

    or

    If you are editing an in-memory dataset, you are prompted to refresh the existing dataset first.

  5. View the new or updated datasets on the Datasets panel.