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?
I did not see any automated queries to capture the EDD data changes. But there are some queries under the following directories.Client side: <ERDA install directory\SQL Code\repo queries\ Server side: <repo install directory>\utilities\SQLscripts. You can modify those scripts and run against the database. The domain binding information.sql and the attachment data for entities.sqlare good examples to see where the objects reside. Hope this helps.
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.