I want to use a change data capture approach to extract new or revised element in the Enterprise Data Dictionary. We could then upload this information to our enterprise metadata solution. Has anyone written queries to extract this type of information directly from the DB? If so, do you have an example?
Does the repository have a transaction log?
ER/Studio maintains internally object change history using object and object history tables in the metadata. I presume you mean this and not that of the transaction log coming from MS SQL database or other DBMS systems.