Skip to main content

Salesforce

Overview​

The Estuary Salesforce Connector facilitates seamless integration between Salesforce and Estuary's data processing framework. With this connector, users can effortlessly sync data from Salesforce objects into Estuary Flow collections. There are two primary types of connectors available: the Realtime Connector and the Historical Connector.

Salesforce Historical Data​

The Historical Data Connector is designed to capture data from Salesforce objects into Flow collections using batch processing methods. This connector is particularly suited for synchronizing historical Salesforce data. By leveraging batch processing capabilities, it efficiently retrieves and syncs large volumes of historical data, ensuring comprehensive integration with Estuary's data processing workflows.

Salesforce Real Time Data​

The Real-time Connector provides a mechanism to capture data from Salesforce objects into Flow collections in real time. It utilizes the Salesforce PushTopic API, which enables the streaming of data changes from Salesforce to Estuary. Leveraging the real-time capabilities of the PushTopic API, this connector ensures that updates and modifications in Salesforce objects are promptly reflected in the corresponding Estuary Flow collections.

Running Both Connectors in Parallel​

To combine the capabilities of both connectors, users can create two separate captures: one using the Historical Connector to capture historical data, and the other using the Realtime Connector to capture real-time updates. Both captures can be configured to point to the same Flow collection, effectively merging historical and real-time data within the same destination.

This approach provides a comprehensive solution, allowing users to maintain an up-to-date representation of their Salesforce data while also preserving historical context. By seamlessly integrating historical and real-time data updates, users can leverage the combined power of batch processing and real-time streaming for enhanced data analysis and insights.

For help using both connectors in parallel, contact Estuary's support team.