Skip to main content
Domo Knowledge Base

Salesforce Connector

Version 39



The Domo Salesforce connector integrates Domo with Salesforce to extract data from API-enabled editions of Salesforce (currently Enterprise and Unlimited). To establish the connection between Domo and Salesforce, an API-enabled user must first authenticate to Salesforce and then grant Domo permission to access to their data. You can then compile reports based on Salesforce data. To learn more about the Salesforce API, visit any of the following:

The Salesforce connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.

Note: This connector imports tabular reports only.

You connect to your Salesforce account in the Data Center. This topic discusses the fields and menus that are specific to the Salesforce connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases

This connector is appropriate for pulling data from any API-enabled editions of Salesforce, such as leads, pipeline activity, and so on.

Primary Metrics

  • Number of Leads

  • Pipeline Amount

  • Bookings

  • Cases

  • Meetings

  • Portfolio Activity

Primary Company Roles

Salesforce has broad functionality and applies to many functions (e.g. Sales, Marketing, HR, Operations, Finance, IT, etc...) and also roles (analyst, sales rep, manager, VP, etc...). It all depends on how Salesforce was implemented, and the objects/modules created.

Average Implementation Time

Depends on the object/report/data size, but Salesforce is very quick to implement. It would take minutes to pull data through once you identify what you need. A very large data pull (millions of rows) would take about an hour.

Ease of Use (on a 1-to-10 scale with 1 being easiest)


What's New

Some recent enhancements to this connector are...

  • A setting that, if selected, allows the connector to automatically add columns to the output as they are created

  • A Date Field setting that pulls all of the data based on your Last Updated date.

Best Practices

When using the Object Browser mode, Salesforce includes related objects (e.g. Opportunity and Account), so fields from each related object can be brought into the same DataSet. This prevents you from having to always pull in the objects independently (i.e. a separate Opportunity object and Account object) and join them in a DataFlow.


To connect to your Salesforce account and create a DataSet, you must have the following:

  • The username for your Salesforce account

  • The password for your Salesforce account

  • An installed Domo Connector Package from the Salesforce AppExchange (required as of August 1, 2018; see next section for installation instructions)

Installing the Domo Connector Package

The "Domo Connector Package" found in Salesforce AppExchange allows Salesforce users to import their data into Domo. Follow these instructions to download and install the Connector Package from the AppExchange.

To install Domo's Salesforce Managed Package,

  1. Log into Salesforce.

  2. Navigate to the Salesforce AppExchange at and search for "Domo Connector Package," then click on it. 


    Alternatively, you can go directly to

  3. Click Get It Now.


  4. Choose whether you want to install in a production environment or sandbox.


  5. Check the box reading "I have read and agree to the terms and conditions."

  6. Click Confirm and Install.  


  7. Click the Install for All Users tile.


For more details, see Salesforce's documentation at

Verifying your Installation

Use Domo's Salesforce Managed Package Validator to verify that your Salesforce Managed Package has been installed correctly.

To verify your installation,

  1. In the Connectors page in either the Data Center or Appstore in Domo, search for "Salesforce Managed Package" and double-click on on the icon.


  2. Click Get the Data.


  3. Under Credentials, select your Salesforce account name, then click Next.


  4. Under Details, click Next.


  5. In the Update menu, select Manually, then click Next.


  6. Give your DataSet a name, then click Save.


The DataSet now runs. If everything has been set up correctly, the run will be successful, and a message will appear reading, "Validation Success: You have set up your Salesforce Managed Package correctly." 


If everything has not been set up correctly, the DataSet fails, and a message appears reading, "You have not installed Salesforce's Domo Connector Package," with a help link to this article. 


Connecting to Your Salesforce Account

This section enumerates the options in the Credentials and Data Selection panes in the Salesforce Connector page. The components of the other panes in this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

The Domo Salesforce connector uses OAuth to connect, so there is no need to enter credentials within Domo. Choose an environment in the Salesforce Environment menu then click Connect to open the Salesforce login screen. Here you can enter your Salesforce username and password. Once you have entered valid Salesforce credentials, you can use the same account any time you go to create a new Salesforce DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Data Selection Pane

This pane contains a primary How Do You Want to Select Your Salesforce Data menu, along with various other menus which may or may not appear depending on the report type you select.



How Do You Want to Select Your Salesforce Data?

Select the method you want to use to pull data from Salesforce. Methods are as follows:

  • Browse Objects and Fields - Lets you select Salesforce objects with associated fields and relationships.

  • Browse Picklists - Lets you browse available dropdown lists in Salesforce.

  • Deleted Objects - Lets you select deleted Salesforce objects. You can only select objects deleted earlier than 15 days ago.

  • Query - Lets you enter SOQL queries to retrieve data.

  • Reports - Lets you retrieve your tabular reports in Salesforce.

Type of Records to Retrieve Select whether you want to retrieve only active records or include deleted records in the search as well.
Unique Field to Retrieve More Than 2000 Rows Select the field that contains a unique value for each row of the report. It will be used to retrieve more than 2000 rows of data.

Query Option

Select a predefined query (Sales Performance or User Images) or create your own query (Custom).


Enter your Salesforce SOQL query here. For example:

SELECT Account FROM Account

For more information about writing SOQL queries, see

Reset Schema

Choose an option for resetting the columns in your data. In general, you will want to choose the second option when changing the selected fields or custom query. You will then run the DataSet, then switch to the first option to maintain the schema for subsequent runs to avoid data type issues.


Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.


Salesforce is generally a very stable connector so there are just a few common issues that arise with it. Most of the issues are due to insufficient permissions (on both the object and the field). Your Salesforce admin should be able to upgrade permissions on specific objects and fields.

Another common error is the “Query Locator Error.” Salesforce only keeps 10 query locators at a time for a single user and for a maximum of 15 minutes. If too many DataSets are running at the same time, some of these will fail. The best way to avoid this issue is to spread out the times when the DataSets are running.


Question: How many rows and columns of data can a pre-built report pull at one time?

Answer: Standard and pre-built reports only pull a maximum of 2,000 rows and 100 columns at a time. This is a limitation of the Salesforce API. You can bring in more than 2,000 rows by using the Unique Field option in the Data Selection Pane. The unique field column you choose must not contain any duplicate values otherwise the report will not match what Salesforce shows.


Question: Why do I not see my reports in the report drop down menu?

Answer: Reports must be in table format and made public in order to appear in the connector and before the data can be pulled in.


Question: Why am I unable to select all the columns wanted using the browse picklists option?

Answer: If you’re testing tables across multiple objects, using the browse picklists, you can only nest down two levels. If you need to pull from more than 2 objects at a time and the objects are not relatable, it is best to pull each object individually and dataflow them together. A map of the relatable objects is found here.


Question: What do I do if I receive the “Query Locator Error”?

Answer: Salesforce only keeps 10 query locators at a time for a single user and for a maximum of 15 minutes. If too many datasets are running at the same time, some of these will fail. The best way to avoid this issue is to spread out the times when the datasets are running.