


erwin has allowed me to explicitly document that and create ERDs. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships.

However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems." "What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. You still had to go in and make some minor modifications to make it deployable to the database system. "It has centralized storage so that a data model can be shared by different teams." "The generation of DDL saved us having to write the steps by hand.
