Skip to main content
waffle.svg
Domo Knowledge Base

Salesforce Connector

Intro

Important: Salesforce API Change

Due to Salesforce's changing API, on September 1st, Domo will be releasing new Salesforce and Salesforce Advanced connectors. These connectors will work in conjunction with a Salesforce managed package installed via the Salesforce App Store. The new version will enable Salesforce administrators to control who can use the Domo Salesforce connectors inside Salesforce, providing ease of administration and enhanced security.

Will my current DataSets continue to work? 
Current Salesforce connector DataSets do not work in conjunction with the Salesforce managed package, and no dependencies need to be installed for the connectors to function. Existing DataSets will continue to run until October 1st.

I want to create a new Salesforce DataSet. What should I do?
Beginning September 1st, any new DataSets created will require you to download the Salesforce managed package via the Salesforce App Store to properly function.

What will happen if I don't install the Salesforce managed package before October 1st?
Any Salesforce instance bringing data into Domo via the Salesforce or Salesforce Advanced connector will stop running until the Salesforce managed package is installed.

For more information on how to download and install the Salesforce managed package, see Installing Salesforce's Domo Connector Package.

 

 

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)

4

Training Video - Connecting to Salesforce

Learn how to power up a Salesforce DataSet.

 

 

Note: The product training videos are for Domo customers and clients only.

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.

Prerequisites

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 https://appexchange.salesforce.com and search for "Domo Connector Package," then click on it. 

    sfmp_1.png

    Alternatively, you can go directly to https://appexchange.salesforce.com/a...A00000EcrsyUAB.

  3. Click Get It Now.

    sfmp_2.png

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

    sfmp_3.png

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

  6. Click Confirm and Install.  

    sfmp_4.png
     

  7. Click the Install for All Users tile.

    sfmp_5.png

For more details, see Salesforce's documentation at https://help.salesforce.com/articleV...ges.htm&type=5

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.

    sfmp_v1.png

  2. Click Get the Data.

    sfmp_v2.png

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

    sfmp_v3.png

  4. Under Details, click Next.

    sfmp_v4.png

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

    sfmp_v5.png

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

    sfmp_v6.png

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." 

sfmp_v7.png

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. 

sfmp_v8.png

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.

Menu

Description

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).

Query

Enter your Salesforce SOQL query here. For example:

SELECT Account FROM Account

For more information about writing SOQL queries, see http://www.salesforce.com/us/developer/docs/officetoolkit/Content/sforce_api_calls_soql.htm.

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.

Troubleshooting

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.

FAQ

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.