Move your data from Salesforce with your free account

The Salesforce connector captures standard and custom Salesforce objects into Estuary Flow collections using a hybrid approach that combines the Bulk API 2.0 for backfills and the REST API for incremental updates. It’s designed to efficiently sync large Salesforce datasets while maintaining high performance and accuracy for both standard and custom fields.

• High-performance data ingestion: Uses Bulk API 2.0 for initial and backfill loads, achieving faster throughput while preserving REST API call limits.
• Automatic formula field refresh: Keeps formula fields up to date by automatically re-querying their values on a customizable schedule, even though Salesforce doesn’t track these changes natively.
• Custom object and field support: Accurately captures custom Salesforce objects and fields, including complex data types and relationships.
• Granular configuration options: Supports OAuth or Username, Password, and Security Token authentication, with optional sandbox mode and adjustable query window sizes.
• Optimized for large orgs: Allows selective capture of specific objects or fields to minimize load, and supports creating dedicated read-only users for scoped access.
• Incremental and backfill sync: Captures historical data during initial setup, then transitions seamlessly to incremental updates for continuous synchronization.

💡 Tip: Schedule periodic formula field refreshes (via the schedule property) to ensure calculated values remain accurate across your downstream systems, especially for reports or analytics dependent on derived fields.