In terms of metadata management, there are several approaches that do work.
Additionally there are a range of tools available, some very expensive and some available in a more turn-key fashion
especially for the Microsoft shop. Search for Metadata Management Software on Google.
Here are some good tips when approaching your metadata integration effort.
Very difficult to develop in house – most efforts fail as it gets unwieldy quick. Lots of coding involved.
Try to identify the the key sources of your metadata and find a tool to capture that automatically within a repository.
Some repositories support Dublin and other standards inherently.
Understand the problem you are trying to solve. Make a list.
Get help from the experts, your chances for success are excellent. Training , Blogs, Webinars, Consulting.
Use a phased approach.
Don’t try to boil the ocean, you’ll get burned.
Break activities down by technical vs business.
Always directly address business requirements solution.
Manually maintaining metadata is not desirable.
Some example goals could be as follows:
Automatically capture all metadata from SQL objects, SSIS, SSAS and SSRS.
Deliver Impact analysis and search capabilities.
Collaboration features via a web portal can provide an easy way to fill in the blanks over time.
Initial roll-out should target 100% automated solution.
Good body of knowledge for metadata management can be found here.