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