MicroStrategy ONE

Import Data from a Salesforce Report

The Financial Force, Veeva CRM, and ServiceMax connectors connect to the content of their respective applications stored in Salesforce. Note that other content may exist. The following description solely addresses content stored in standard Force.com reports.

You can import data from a report stored on Salesforce.com into MicroStrategy Workstation. You can connect to either a default instance or the Sandbox instance.

To troubleshoot common errors when using the Salesforce connector, see KB485171.

In addition to importing data directly from Salesforce.com reports, you can import data by creating a data source connection to Salesforce.com, then using a Freeform query, such as SQL, SOQL, or XQuery, to select your data. For steps to import data using a Freeform query, see Importing data from a database by typing a query.

Configure the OAuth parameters, as described in Configuring OAuth parameters for a data source. Select between the default and Sandbox instances to define their parameters respectively. You will need to configure the Client ID and Client Secret that Salesforce provides on MicroStrategy Web or configure the Client ID and Client Secret in MicroStrategy Workstation. For more information, see Create an IAM Object with a Generic OAuth Type.

Import Data from a Salesforce Report

  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 Morenext 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 Salesforce Reports.
  2. Click Log In to select default Salesforce instance.

    or

    Click Log In to Sandbox to select Salesforce Sandbox instance.

    A Salesforce login page opens.

  3. Log into Salesforce.com by typing your Salesforce.com username and password for the previously selected instance in the  Username  and  Password  fields, then click  Log in or Log In to Sandbox, respectively.

    After successful login, your selected instance will be saved for subsequent Salesforce imports until you switch the instance or sign out of your Salesforce.com account.

  4. Your Salesforce files appear on the left pane.

  5. Drag the files you want to import to the right pane.

  1. Click Prepare Data if you are adding a new dataset and want to 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.

    or

    Click Update Dataset if you are editing an existing dataset.

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

Change a Selected Salesforce Instance

  1. In the top right corner of the Data from Salesforce dialog, click Morenext to your email.
  2. If you are currently logged into the default Salesforce instance, click Switch to Salesforce Sandbox.

    or

    If you are currently logged into the Salesforce Sandbox instance, click Switch to Salesforce.

Sign Out from a Selected Salesforce Instance

  1. In the top right corner of the Data from Salesforce dialog, click Morenext to your email.
  2. Click Sign out.