Data synchronization jobs are by far the most common type of integration job,1 during which we take data from one or more systems and move it into another (keeping the data in sync)—in our case, Salesforce. Data can flow from one system to another, and back. Sometimes this causes data conflicts that must be dealt with. Getting synchronizations working right can be tricky, particularly when there are heavy transformations and/or summarizations involved.
In this chapter, we study various data synchronization patterns and the pros and cons of each. Keep ...