Salesforce Connector

Extract data from Salesforce CRM and load it into your warehouse, or activate warehouse data back into Salesforce with reverse ETL.

SourceDestinationGold

Start Free View Documentation

Setup a Salesforce Source in Supaflow

Why Supaflow

All connectors included

No per-connector fees. Every connector is available on every plan.

Pay for compute, not rows

Credit-based pricing. No per-row charges, no MAR surprises.

One platform

Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.

Capabilities

OAuth and Basic Authentication

Connect via OAuth 2.0 browser-based flow (recommended) or username/password with security token. Supports production orgs, sandboxes, and custom domains.

Bulk API Support

Uses the Salesforce Bulk API for high-volume data extraction with configurable batch sizes up to 50,000 records per batch.

Incremental Sync

Tracks cursor positions per object so subsequent runs fetch only changed records. Configurable lookback window for late-arriving data (Salesforce recommends 600 seconds for production).

Automatic Schema Discovery

Discovers all standard and custom objects in your Salesforce org, including field-level metadata. Schema refresh interval is configurable per pipeline.

Supported Objects

Sales

Account

Companies and organizations you do business with.

Contact

Individuals associated with accounts.

Opportunity

Pending deals and their stages.

Lead

Prospective customers not yet qualified.

OpportunityLineItem

Products or services tied to an opportunity.

Pricebook2

Price books that define product pricing.

Service

Case

Customer issues and support requests.

CaseComment

Comments on support cases.

Activity

Task

To-do items and call logs.

Event

Calendar events and meetings.

Custom Objects

Any custom object (__c)

All API-accessible custom objects in your org are discovered automatically.

How It Works

Configure your Salesforce account

Ensure your Salesforce edition has API access enabled. For OAuth, grant the "Approve Uninstalled Connected Apps" permission to the connecting user. For Basic Auth, reset your security token under Personal Settings.

Choose authentication and connect

Select OAuth (recommended) or Basic Auth. Enter your Salesforce domain (login.salesforce.com for production, test.salesforce.com for sandbox). If using OAuth, authorize through the browser flow. If your org has IP restrictions, whitelist 18.214.240.61.

Test and save

Click Test & Save to verify the connection. Supaflow will discover available objects and fields. Select the objects you want to replicate and configure your pipeline schedule.

Use Cases

Sales analytics in your warehouse

Replicate Accounts, Contacts, Opportunities, and Leads into Snowflake or another warehouse for reporting and forecasting alongside data from other systems.

Reverse ETL to Salesforce

Push enriched or scored data from your warehouse back into Salesforce -- for example, writing lead scores, account health metrics, or segment tags onto Contact and Account records.

Operational reporting across CRM and support

Combine Cases, Tasks, and Events with sales pipeline data to build cross-functional dashboards that track the full customer lifecycle.

Frequently Asked Questions

Which Salesforce editions are supported?

Any Salesforce edition with API access enabled. This includes Enterprise, Unlimited, and Developer editions. Professional edition requires the API add-on.

Does Supaflow count against my Salesforce API limits?

Yes. Each sync consumes Salesforce API calls. Using the Bulk API (enabled by default) is more efficient for large volumes. You can monitor usage under Setup > System Overview > API Usage.

Can I replicate custom objects and custom fields?

Yes. Supaflow discovers all API-accessible objects, including custom objects (ending in __c) and custom fields. The connecting user must have read permission on the objects and fields.

What happens if my OAuth token expires?

Supaflow stores a refresh token during the initial OAuth flow and automatically requests new access tokens. You only need to re-authorize if the refresh token is revoked.

How do I handle Salesforce sandbox environments?

Set the Salesforce Domain to test.salesforce.com when configuring the connection. Sandbox credentials are separate from production.