Establish Connectivity to Salesforce SOQL

This article describes how to connect to Salesforce using Salesforce SOQL plugin in order to get data and create Elements in Metric Insights.

PREREQUISITES:

Set up Salesforce OAuth

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+ New Data Source]
  2. Select "Salesforce SOQL" option from the Plugin dropdown menu.
  3. [Next]
  4. Data Source Name: Give the data Source a descriptive name.
  5. [Create]

2. Provide Required Parameters

  1. Client ID: Insert Consumer Key from Salesforce account.
  2. Client secret: Insert Consumer Secret from Salesforce account.
  3. Username: Insert the Username from Salesforce account credentials.
  4. Plugin Password: Insert the Password from Salesforce account credentials.
  5. Optionally, toggle on Enable On-Demand Element Creation.
Expand or collapse content 2.1. Finding Consumer Key and Consumer Secret in Salesforce (Classic UI)
  1. Go to Build > Create > Apps.
  2. Under Connected Apps, open the App link.
  3. In the API section, copy Consumer Key.
  4. Click the link to reveal and copy Consumer Secret.

3. Configure Optional Parameters

NameDescription
Server

Specify the name of your custom Salesforce Server that you want to use instead of the default one

4. Proceed with Advanced Configuration

Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.

[Test Connection] in the upper right corner to check if everything work correctly.