Runway offers two ways to integrate with Salesforce:
  • Quick-start connection via Workato (Recommended) – A simpler setup that leverages existing Salesforce reports you’ve built.
  • SQL-powered integration via Fivetran – Ideal if you need advanced data customization and want to pull in a wide range of Salesforce objects (like Opportunities, Accounts, Users, and more).
This integration method relies on you having existing Salesforce reports configured. Please be aware of the following:
  1. Any filters applied to that report will automatically apply to the data imported into Runway.
  2. Salesforce Reports must be configured in a simple row based format, no charts, no pivots.
  1. Open your Runway instance.
  2. In the left sidebar, hover over Integrations and click the + button to open the Integrations Directory.
  3. Search for Salesforce and click + Set up on the option listed in the CRM section. Salesforce Workato Pn
  4. You’ll be redirected to Salesforce to authorize the connection and complete authentication.
  5. Once authorized, you’ll return to Runway. Click + next to the integration name in the sidebar to create a new query. Create Query Pn
  6. You can then change the default query name, New query, to something more descriptive. To do this, click the three-dots button next to the query name in the sidebar and select Rename query. Rename Query Pn
  7. Copy the Salesforce Report ID from your report’s URL and paste it into the highlighted field below. Salesforce Workato Report Id Pn
  8. Click Run query and validate the data looks correct.
  9. You’re done integrating! Go ahead and configure a new database.

​
SQL-powered integration via Fivetran

  1. Click Setup on the Salesforce (Fivetran) integration in the Integrations directory and follow the on-screen authentication process. Salesforce Fivetran Pn
  2. Keep the default settings during Fivetran setup. Salesforce Fivetran Config Pn
  3. After being redirected back to Runway, we recommend using our Salesforce Opportunities integration template.
    • In the left sidebar, navigate to Templates.
    • Search for Salesforce Opportunities Quickstart.
    • Click + Add to Runway to apply the template.
    Salesforce Fivetran Template Pn
  4. This template automatically creates a database for you to begin building your model.
  5. Alternatively, you can follow our SQL guide to customize the existing template or pull additional objects and properties. Note that when referencing Salesforce properties in your query, you must use their internal names, which may differ from the display names shown in the Salesforce interface.

​
Salesforce FAQs