Universal Containers is evaluating the connection mode for the objects in their local Salesforce connector.

The best connection mode for Universal Containers, given their need to sync updated and new records from the Order object weekly, including updates to formula fields, is Periodic Full Sync. This mode will:

Periodically sync all records from the source object (in this case, weekly).

Ensure that all fields, including formula fields that may calculate values based on other periodically updated fields, are current in the destination system.

This mode is especially suitable when data completeness and accuracy are crucial, and where changes inthe dataset need to reflect consistently, including computed or derived fields.