How Spotfire knows data change in DB
I met in interesting question – Below is the use case. Would like to hear your opinion:
we need to trigger ETL from Spotfire, when we do that, we write back to DB ETL trigger table and update the ETL status flag as something like ‘Running’. Then the Informatica ETL job will be triggered and data will be processed. Once ETL is complete, we will mark the flag as ‘Complete’ and we expect Spotfire will reload the data.
The question is – how Spotfire will be able to know when the ETL is complete?