There are multiple ways to manage Microsoft BI metadata, impact analysis, dependency analysis and lineage.  In SQL Server 2012,   these features will be available in the “Project Barcelona”   SQL Server Feature Pack installs.  A live preview can be tooled  with at http://projectbarcelona.cloudapp.net.

A current option fan favorite is the low cost BI Documenter by  Pragmatic Works: http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Overview.aspx.  BI Documenter works with the full BI stack – database, SSIS, SSAS,   SSRS – with versions 2005 and up.  It has many nice features     such as a metadata editor, object change compare viewer, dependency graphing, workflow and totally automated solution documentation.   Another current option is the Microsoft Metadata 2008 Toolkit at http://sqlmetadata.codeplex.com.    The metadata toolkit tracks data lineage, technical metadata, and impact analysis for SSIS, SSAS, SSRS, and SQL.  Features   include:

  • -Database Repository to store the metadata
  • -Stand-alone Dependency Analyzer program to view dependencies
  • -Report model for ad hoc reporting on technical metadata.
  • -Reports on impact analysis, dependency analysis, lineage

 

Additional Metadata Management Resources

SQL Server Metadata Toolkit  http://archive.msdn.microsoft.com/SqlServerMetadata/Release/ProjectReleases.aspx?ReleaseId=1174

Managing Metadata in SQL Server   http://msdn.microsoft.com/en-us/library/cc966384.aspx http://channel9.msdn.com/Events/TechEd/Europe/2010/BIN308 http://ecn.channel9.msdn.com/o9/te/Europe/2010/pptx/bin308.pptx

Microsoft Master Data Management http://msdn.microsoft.com/en-us/library/ff487016.aspx