How to always force delta refresh a specific external OT

As I said: the first-party connectors (OLEDB/Salesforce/CRM) use the same interfaces as you do; the server doesn't differentiate.  If the settings in the vault are correct then the behaviour should be consistent.

Understood, but this specific setting (SELECT statement) looks to me like it is from the legacy connections, so it might not work with new application connections where we no longer thave these SELECT/UPDATE/DELETE statements

I've not forgotten about this.  I have just taken a quick look (I've had quite a few calls today!) and I can see why you're questioning this.

I might have time to create a quick ExtOTDS tomorrow to check this out.  Of course if you have one that I can use for testing then that would save me some time.

I am using our REST OT Connector for this, if that will be of any help, I can send you vault backup, or whatever other format might be helpful (configs, endpoints, whatever?)

I probably need the source to be able to check what's happening.  I'll try to create something later if I get some time.

I can send you that as well, since we did send this for validation anyhow