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.
I do - sounds like there is something there to interrogate, looking for changes
The team server has the capability to run reports on changed objects like who changed what and what kind of operation was done. You can create manual reports and save them to share with the team. You can also filter on object types and object names to limit the output.