Limitations and considerations

The following limitations apply when using Salesforce as a source in a Replicate task:

• The following object types are not supported:
  • External objects
  • Big objects
  • Non-replicable objects (i.e. tables not created by the customer such as Salesforce system tables)

• Replicate performs CDC using the Salesforce CDC API and is therefore subjects to its limitations.

  For example:

  • Salesforce CDC does not support all of the Salesforce standard objects. However, objects that are not supported using Salesforce CDC can still be replicated in a Full Load task.

    For a list of supported Salesforce CDC objects, visit:

    https://developer.salesforce.com/docs/atlas.en-us.change_data_capture.meta/change_data_capture/cdc_object_support.htm

  • UPDATEs performed by the Salesforce Bulk API will not generate a Salesforce notification and will therefore not be captured.
  • The resume processing from "Source change position" Run option is uses the Salesforce retention time.

  • As Salesforce does not generate a FULL after-image, the following limitation applies:

    The INSERT the missing target record option and the Batch optimized apply mode of Apply Changes using SQL MERGE option are not supported. If either of these options is selected, NULL will be inserted into the target for all corresponding source columns that were not changed in the UPDATE operation. If one of these columns is NOT NULL, the operation will result in an error. If a table contains a LOB column, and the column was not changed, the task stops with a fatal error.

• DDLs are not supported.
• The "Estimated Count" in the Full Load monitoring statistics will be N/A.
• Only the user + password + security token authentication method is supported
• Shield Platform Encryption is not supported.
• The source_lookup Data Enrichment function is not supported. For more information on this function, see Data Enrichment functions
• The "Start from timestamp" Run option is not supported.
• The AR_H_USER header column is not supported. For information on using header columns, see Headers.
• Using the Filter option may impact processing time as Replicate first retrieves all of the data and then performs the filtering.
• Capturing DELETE and UPDATE operations is not supported when using filters.
• Transformations that affect multiple columns are not supported.
• When storing changes in Change Tables, the before-image will not be stored. Only the changed columns of the after-image will be stored. All other columns will have NULL values.
• Formula fields are not supported and will not be shown as part of the table's metadata.
• Capture of Gap Events and Overflow Events is not supported. On encountering such events, Replicate will suspend the affected tables and require them to be reloaded. For more information on these event types, see the Salesforce online help.
• During Full Load, tables that need to be queried using Replicate filters are not supported and will be suspended. The "Vote" object, for example, is not supported as it requires the data to be filtered using Parent or ID clauses.
• Replication of IsDeleted and LastViewedDate columns is not supported.
• Replication of CDP (Customer Data Platform) objects is not supported.

• Replicating data with 4-byte emoji characters is not supported.