Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository.

Easily view and analyze the integrated metadata to get information on data usage, end-to-end change impact analysis, and report-to-source data lineage. Deliver trusted data for compliance requirements, internal controls and improved decision-making.

Do you have too many disparate metadata-generating systems? Has it become difficult to manage metadata coming from your various data sources, ETL technologies, business intelligence (BI) tools, and modeling utilities? BusinessObjects™ Metadata Manager can bring it all together—to simplify your workload, lower your project total cost of ownership (TCO), and provide your users with trusted data and analysis capabilities.

• Integrate and consolidate metadata
• Track use via metadata auditing
• Impact analysis and data lineage
• Export to BusinessObjects universe

Integrate and Consolidate Metadata

So you want to lower costs? Metadata Manager can reduce project TCO by consolidating and integrating your disparate metadata into an open, relational repository. Metadata Manager integrates metadata from your various databases and enterprise resource planning (ERP) catalogs, modeling tools (such as ERWin), ETL products, and BI components (such as BusinessObjects universes). Other sources can
be supported by using SQL, Java, and web services. Metadata Manager is quick and simple to implement—and gives you comprehensive management capabilities like metadata versioning, browsing, and searching along with multi-language metadata support.

Track Use via Metadata Auditing

What are the most used and unused reports in my system? Which data in my warehouse is seldom used for analysis? Which data source has the most validation failures? How does data warehouse growth impact report performance? With consolidated metadata, you can answer these questions to optimize your BI environment. Prebuilt reports answer expected audit questions while predefined universes let you write your own custom reports.

Impact Analysis and Data Lineage

Have you ever wondered how a data source change impacts your data warehouse and BI deployment? With impact analysis, you can find the relationships between sources (tables or columns), targets, universes, and documents. This capability helps to significantly reduce maintenance costs by knowing the impact of changes to source and target systems. Knowing which sources provide data for which reports also increases end-user trust, and allows you to gain a better understanding of the overall data architecture. This means you can track the lineage of data from an end-user report right back to its original data source, making more accurate and confident decisions because you’ll better understand your data.

SO038