Question
James Hipp · Apr 21, 2021

Tracking DAT / Database Changes Over Time, Similar to SQL ChangeLog

Hello,

We have a need to track Database changes over time - down to the SQL level of granularity if possible. Such as: User xyz runs routine ^abc and we get something similar to a changelog that tells us: table A had this value updated, insert, update etc....

Is that possible using IRIS level tools (Audit Log, Journal File, etc...) , is there a way to convert the global sets and kills from the journals into SQL level changes?

 

I also found a third-party java-based tool named Liquibase , but it seems more oriented to tracking schema and table based changes or pre-defined definitions.

 

 

Thanks,

James

Product version: IRIS 2020.1
10
3 1 2 93
Log in or sign up to continue

Replies

If you control the DB schema, you can use triggers for this.