Apply change data capture against Enterprise Data Dictionary

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?

Parents
No Data
Reply
  • 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.sql
    are good examples to see where the objects reside. Hope this helps.

Children
No Data