...
Each time data is changed outside the API is now refreshed enabling a user to trust data received by the API. Every time there is a change in the database a trigger/s will insert a row in a new table. The table will have three columns:
- Object Name (the corresponding DLP object name of the table that has been changed)-
- Primary Key Value (the key of the row that has been changed).
- Creation Time Stamp (the time stamp of the row creation).
- Primary Key Value (the key of the row that has been changed).
- Creation Time Stamp (the time stamp of the row creation).
The initial two columns will be the primary key of the table. A job that runs inside DLP will constantly monitor if there are rows in the table - and if yes - will refresh the corresponding cayenne object and delete the row from the table.
...