Stream data from Salesforce to Google Cloud SQL for SQL Server

The Salesforce connector captures standard and custom Salesforce objects into Estuary 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.

Connecting Google Cloud SQL for SQL Server with Estuary lets you automatically sync data from Estuary collections into SQL Server tables hosted on Google Cloud. This integration enables teams to materialize real-time data for analytics, reporting, and application backends without maintaining complex pipelines.

• Fully managed setup: Works with any SQL Server instance hosted on Google Cloud SQL (2017 or later)
• Automated table creation: Estuary generates and updates tables automatically based on your collection schema
• Flexible connectivity: Supports both direct public IP access and secure SSH tunneling through a Google Cloud VM
• Easy user setup: Create a dedicated database user (flow_materialize) with control privileges using standard SQL commands
• Delta update support: Choose between standard merge operations or delta updates for more efficient synchronization
• Secure configuration: Password-based or SSH key–based authentication ensures safe communication between Estuary and your SQL Server environment

💡 Tip: Use SSH tunneling if your instance does not allow public IP access. Set the address to _127.0.0.1:5432_ and provide your VM credentials under the _networkTunnel_ configuration.