Earlier quoted context omitted.
I've only been involved with such Salesforce integrations at one company, but based on that, I can give you my take. I'd be interested to hear others'. One, the salesforce data changes all occur through APIs (ok) which various enterprise integration tools (Informatica, Mulesoft, etc) support (ok), but those tools typically dont support easy options for retrying a change to a specific row that causes an error. If you…
The regular REST api has request scoped transactions. Only the bulk api has the issues you describe. The bulk api is kind of a special thing annyway and has its quirks. The regular REST api works more like what you’d expect.
I would love to be wrong on this.