Using Salesforce (Streaming CDC) as a source

This section describes how to set up and use the Salesforce (Streaming CDC) source endpoint in a replication task. The Salesforce (Streaming CDC) source endpoint is similar to the Salesforce (Incremental Load) source endpoint, although the method each uses to capture changes is different.

Salesforce (Streaming CDC) uses the Salesforce Streaming API which is subject to several limitations, although it does provide better performance. Salesforce (Incremental Load), however, is based on change polling which, although slower than Salesforce (Streaming CDC), has the advantage of supporting almost all tables.

Basically, if you need to capture changes from tables that are not supported with Salesforce (Streaming CDC) then choose Salesforce (Incremental Load). Otherwise, choose Salesforce (Streaming CDC) for its better performance during change capture.