I couldn't figure this out in the documentation - how are you keeping the data up to date? Is there some kind of scheduled refresh that pulls all the data from the database periodically, or how are you detecting which rows changed?
In particular, how are you implementing this in, say, the MSSQL importer?
> Adaptors may be able to track changes as they happen in source data. This "tail" capability allows a ABC to stay running and keep the sinks in sync.
> I’m assuming they’re adding a trigger to the source table.
Their video demo for SQL Server simply points the command line at a connection string, and it then says 2 item(s) indexed. There wasn't a way to pick specific tables.
That means if the trigger method is true, they're adding a trigger by default to every single table in the database. That would be a remarkably bad idea.
In particular, how are you implementing this in, say, the MSSQL importer?
> Adaptors may be able to track changes as they happen in source data. This "tail" capability allows a ABC to stay running and keep the sinks in sync.