We use Dataedo for documenting the database of our main software. It's a central reference for the developers and the analysts and we share Data Dictionary with third parties who develop BI system. What I like about it is that it's easy to find out what's not documented and a well-done Data-Dictionary in PDF. I would definitely recommend it to others.
Dataedo made it easy to find information about our databases and evaluate the percentage of documentation of the DB. It is a very intuitive tool and we use it regularly. I would recommend it to anyone. I evaluated other tools like ApexSQL and Data Dictionary Creator and Dataedo is just the most complete tool.
Dataedo is an easy to use facility for managing basic metadata centrally and producing enhanced data dictionaries. Initially we wanted to use it for a single set of system documentation, but we will now employ it for scheduled metadata updates along with multi-user maintenance. The well-structured database repository has also facilitated a Data Lineage project. I would recommend Dataedo to anyone with similar requirements, and in fact already have.
We use Dataedo to document a SSAS implementation for a power business user, to understand the intent of each field and measure so they can build their reports more effectively. It helps us document the 'why' we built it the way we did. The tool is very intuitive to work with, and we use it continuously. We also want to use more licenses in the near future.