Log of user activities in DB repository shared model

[Michal Rehak]

Hi,

I have EA model (datawarehouse model - tables, columns, tagged values, etc.) stored in DB repository (currently ORA, but we could switch to MSSQL). I would like to share the model with more users (making physical changes to the model). The issue is, I need to monitore who changes the model, which object and how (e.g. user A added new column to a table, user B modified that column, etc.). So I mean to obtain some log of user activities.

My idea is to audit the repository DB for changes caused by user, over whome connects EA to the repository (probably this is possible only in MSSQL). But I don't think, this is the best way to solve this issue.

Any other idea?

Thanks,
Michal

[Geert Bellekens]

EA has a built in auditing feature that you can use.

Another alternative is to connect to version control (maybe only for the critical parts of the model)

Geert