Stream data from Salesforce to ClickHouse
Move data from Salesforce to ClickHouse in minutes using Estuary. Stream, batch, or continuously sync data with control over latency from sub-second to batch.
- No credit card required
- 30-day free trial


- 200+Of connectors
- 5500+Active users
- <100msEnd-to-end latency
- 7+GB/secSingle dataflow
How to integrate Salesforce with ClickHouse in 3 simple steps
Connect Salesforce as your data source
Set up a source connector for Salesforce in minutes. Estuary supports streaming (including CDC where available) and batch data capture through events, incremental syncs, or snapshots — without custom pipelines, agents, or manual configuration.
Configure ClickHouse as your destination connector
Estuary supports intelligent schema handling, with schema inference and evolution tools that help align source and destination structures over time. It supports both batch and streaming data movement, reliably delivering data to ClickHouse.
Deploy and Monitor Your End-to-End Data Pipeline
Launch your pipeline and monitor it from a single UI. Estuary guarantees exactly-once delivery, handles backfills and replays, and scales with your data — without engineering overhead.

Salesforce connector details
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.

See how Envoy uses Salesforce

ClickHouse connector details
Estuary’s ClickHouse materialization connector loads data directly into your ClickHouse instance for seamless table creation, schema evolution, and delivery. Combine real-time CDC sources with a ClickHouse destination for true real-time analytics.
- Streams Estuary collections directly into ClickHouse via ClickHouse’s native protocol
- Creates tables and manages schemas automatically
- Choose between standard merge behavior or delta updates for streaming
- Exactly-once delivery
- Supports soft or hard deletes
Estuary in action
See how to build end-to-end pipelines using no-code connectors in minutes. Estuary does the rest.
Spend 2-5x less
Estuary customers not only do 4x more. They also spend 2-5x less on ETL and ELT. Estuary's unique ability to mix and match streaming and batch loading has also helped customers save as much as 40% on data warehouse compute costs.

Salesforce to ClickHouse pricing estimate
Estimated monthly cost to move 800 GB from Salesforce to ClickHouse is approximately $1,000.
Data moved
Choose how much data you want to move from Salesforce to ClickHouse each month.
GB
Choose number of sources and destinations.
Why pay more?
Move the same data for a fraction of the cost.



What customers are saying
Getting started with Estuary
Free account
Getting started with Estuary is simple. Sign up for a free account.
Sign upDocs
Make sure you read through the documentation, especially the get started section.
Learn moreCommunity
Join the Slack community for the easiest way to get support while getting started.
Join Slack CommunityEstuary 101
Watch the Estuary 101 webinar for a guided introduction to using Estuary.
Watch

Frequently Asked Questions
Is this integration suitable for production workloads?
Yes. Estuary pipelines are designed for production use, with exactly-once delivery semantics, automated backfills, and continuous operation at scale.
Can I control where my data runs and is processed?
Yes. Estuary offers multiple deployment options, including fully managed SaaS, private deployments, and bring-your-own-cloud (BYOC). This allows teams to control where their data plane runs and meet security, compliance, and networking requirements. Learn more about Estuary's security and deployment options.
Can I build this Salesforce to ClickHouse integration manually?
Yes, it's possible to build a manual pipeline using custom scripts, scheduled jobs, or open-source tools. However, manual approaches typically require ongoing maintenance, custom error handling, schema management, and operational overhead. Estuary simplifies this by providing a managed pipeline with built-in reliability, scaling, and monitoring.
Related articles
salesforceHow to Integrate Salesforce with ClickHouse in Real Time (No Code, No Kafka)

ClickHouseHow to Stream MongoDB Data to ClickHouse in Real Time

ClickHouseHow to Move Data from Snowflake to ClickHouse: Real-Time, No-Code Guide

ClickHouseHow to Replicate MySQL to ClickHouse in Real Time Using CDC (In Minutes)

ClickHouseHow to Move Data from SQL Server to ClickHouse (No Code Needed)

ClickHousePostgreSQL to ClickHouse: Real-Time Streaming with CDC

Related integrations with Salesforce
DataOps made simple
Add advanced capabilities like schema inference and evolution with a few clicks. Or automate your data pipeline and integrate into your existing DataOps using Estuary's rich CLI.





































