Use the OneDrive Connector

Starting in MicroStrategy ONE Update 12, you you can use the OneDrive connector as part of the new data import experience.

Follow the steps below to import data from OneDrive:

• Configure OAuth Parameters for OneDrive in Old Data Import

• Import Data from OneDrive

Configure OAuth Parameters for OneDrive in Old Data Import

1. Log in to MicroStrategy Library Web.
2. Go to the Data Import home page.
3. Find and edit the OneDrive connector.

   

4. Enter the Connector URL, Client ID, and Client Secret.

   

5. Click Save.

Import Data from OneDrive

Once you’ve successfully configured the required OAuth parameters, you can start importing data. The feature is only available when the new data import experience is enabled.

1. Log in to MicroStrategy Library Web.
2. Go to the New Data Import home page.

3. Click OneDrive.

   

4. Sign into OneDrive with your username/email and password. All available files appear.

5. Add files to the drop zone and click Submit.

6. If necessary, click Prepare Data to view the sample data and adjust column types.

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