Salesforce ODBC - How to work with *ChangeEvent tables?
Hi there!
We've recently bought our Devart Salesforce ODBC license and set it up so we can query our Salesforce via Microsoft SQL LinkedServer.
I've now seen that nearly every Object has an additional ObjectChangeEvent table and I was wondering how we could make use of them. Is there some way to Trigger logic running in our Microsoft SQL Server on such a ChangeEvent?
Selecting from such a ChangeEvent table doesn't seem to be possible:
> [Devart][ODBC][Salesforce]Table 'AccountChangeEvent' does not support SELECT statement.