MicroStrategy ONE

Configure the OneDrive Connector

Starting on November 9th, 2020, Microsoft announced that end users are no long able to grant consent to newly registered multi-tenant apps without verified publishers.

For official Microsoft documentation, click here.

To use the OneDrive connector, you must register an app to support OAuth authentication to Microsoft Azure.

You are required to complete the following 3 steps for a successful configuration:

  1. Register an OAuth app with single-tenant and grant permissions

  2. Deploy the connector

  3. Update the configuration file in all cluster nodes to avoid conflicts

Register the App

If you are using a MicroStrategy version prior to MicroStrategy 2021 Update 1, see KB485033.

  1. Log into Azure.

  2. Navigate to App Registration.

  3. Go to New registrations > Single tenant account type.

  4. In the Redirect URI field, enter the redirect URL in the following format:

    https://your-host-name:port/CommunityConnectors/redirect

  5. Click on the newly registered app and go to API permissions.

  6. Add the following permission in Microsoft Graph:

    Copy 
    Files.Read.All
    Sites.Read.All
    User.Read

  7. Ensure you Azure Admin grants consent for the above permissions.

  8. Go to Certificates & secrets.

  9. Click New client secret. (Copy and save the value because they will not be displayed once you leave the page.)

  10. Go to Overview.

  11. Copy and save the Application (client) ID and Directory (tenant) ID for later use.

Deploy the Connector

  1. Log into MicroStrategy with an administrator user.
  2. Open the Connect to Your Data dialog.
  3. Hover your mouse over the OneDrive connector.
  4. Click Edit Connector.
  5. Enter the app parameters and click Save.

Update the Configuration File in All Cluster Nodes

To configure cluster environments for Community Connectors, see KB484387.