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.