i skimmed the 15 products referenced at https://dbmstools.com/categories/data-dictionary-tools . all seem biased toward one db technology or another. But the biggest problem i see is that they focus on erds etc after the fact and most base their "capability" on tapping into extended properties. I want an agnostic/decoupled product where we can truly document the BUSINESS elements before they are designed into a relational and/or olap repository. I want to stay away from excel because i want more familiar scanning capability and result generation. feel like i need to roll my own being careful that even if it (metadata) is based in sql server, that it easily be migrated if we dont always use sql server for this kind of metadata source. I'm ok with this or an off the shelf product having some sort of lineage or impact capability but i dont need an ssis documenter. i'm focused on the business.
i'm doing a read on the differences amongst dictionary, catalog and glossary. Also , i should mention that within reason, sample data values and volumes would be very useful in my dictionary/catalog/glossary. I know these get unwieldy sometimes. maybe queries that generate these would be very useful so we arent doing double duty.