MicroStrategy ONE

Configure OAuth Parameters for a Data Source

The following data sources require you to configure an OAuth connection between your third-party data source and MicroStrategy Workstation:

  • Dropbox
  • Google Analytics
  • Google Drive
  • Google BigQuery (Native API)
  • Salesforce Reports
  • Twitter

You must create an OAuth connection between your third-party data source and Workstation to make these data sources available for import, as described in Connect to a Data Source. Next, you must define the OAuth parameters for the connection, as described in the steps below.

  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. Hover over the applicable data source and click Set OAuth Parameters. The Set OAuth Parameters dialog opens.

  2. In Callback URL, enter the MicroStrategy Web URL and Library URL that you used to configure MicroStrategy Web and Library as a remote access application in your data source. Possible URLs are:

    • MicroStrategy Web ASP.NET deployments:
      https://WebServer/WebApplicationName/asp/Main.aspx?evt=3172
    • MicroStrategy Web JSP deployments:
      https://WebServer:PortNumber/WebApplicationName/servlet/mstrWeb?evt=3172
    • MicroStrategy Library deployments:
      https://WebServer:PortNumber/LibraryApplicationName/auth/DIOAuthRedirect.jsp

    WebServer is the full domain name of your web server that is hosting MicroStrategy Web. Ensure that you use the full domain name rather than using an IP address, as using an IP address can require re-authentication when making the connection.

    PortNumber is the port number of your web server.

    WebApplicationName is the name of the MicroStrategy Web application. The default name for the MicroStrategy Web application is MicroStrategy.

  3. In Client ID, enter the client ID acquired when configuring MicroStrategy Workstation as a remote access application in your data source.
  4. In Client Secret, enter the client secret acquired when configuring MicroStrategy Workstation as a remote access application in your data source.
  5. If necessary, click Reset to Default to revert to the default client ID and client secret provided by MicroStrategy.
  6. Click OK.
  7. Continue importing data.

Related Topics

Import Data