Metadata Manager
Increasing Insight Into Complex Data Relationships
Metadata Manager is an integral part of PowerCenter Advanced Edition (AE). This tool automatically delivers an audit trail that documents changes to data as it flows through various enterprise systems.
Metadata Manager aggregates and links metadata from a wide variety of data sources—including databases, applications, and mainframe systems—in an integration metadata catalog that provides a common taxonomy for business and IT collaboration. Metadata Manager also delivers personalized data lineage and comprehensive impact analysis, which gives organizations additional insight into their data and increases trust in the data that drives business decisions.
Key Features
Integration Metadata Catalog
- Collect and link metadata from a wide variety of sources, including relational databases, modeling tools, integration processes, enterprise applications, and mainframe systems, into a central catalog
- Use a common taxonomy of metadata definitions, along with their business contexts, to facilitate collaboration between IT and the business
Personalized, End-to-End Data Lineage
- Use an intuitive, dynamic visual map of data flows and dependencies across all systems and processes
- Focus on only the data you need, and interactively trace, navigate, and drill down from the system to the field level
- Quickly see where data comes from, how it has been transformed, and how it is consumed
Comprehensive Impact Analysis
- Analyze detailed dependencies between data assets and determine where they are used throughout an overall data integration solution
- Quickly move between data lineage and impact analysis to isolate and accurately estimate the cost impact of changes to an existing data integration solution
- Use intelligent audit trails to assess the organizational impact of change and validate data accuracy
Complete Data Asset Inventory Reports
- Take advantage of a wealth of metadata and meta-model asset inventory reports to quickly locate data and integration process assets to aid data discovery and audit reporting for regulatory compliance and data governance
Broad Connectivity to Metadata Sources
- Use pre-built connectivity to a wide variety of data sources to accelerate the extraction and linkage of metadata
- Connect to flat files, databases, mainframe systems, enterprise applications, modeling tools, the PowerCenter data integration platform, and business intelligence products
- Leverage a comprehensive SDK to develop custom metadata adapters for integrating unique metadata sources
New and Enhanced Features in PowerCenter 8.5
Integrated Web-Based User Interface
- Access a single UI for all Metadata Manager functionality, including metadata browse and search, data lineage, impact analysis, loading, modeling, and administration
- Simplify deployment and provide access from any location
Personalized Metadata Exploration
- Customize your view by defining preferences and favorites so that functions within the application, such as search, browse, lineage, and impact analysis, only yield the information you’re interested in
- Reduce clutter in a large asset catalog
Enhanced Search Capabilities
- Quickly find what you’re looking for
- Use Simple Search to find relevant items across the entire catalog in one click
- Use Advanced Search to support any combination of complex search conditions involving detailed attributes
- Return search results based on relevance, increasing your productivity when working with a large catalog
Integrated Data Profiling Results
- Access data profiling results to get additional insight into data
- Improve your understanding of underlying data and quickly assess data quality at different points in the data lineage
Annotations, Linked Documents, and Favorites Sharing
- Augment technical artifacts with rich business context
- Facilitate cross-functional team collaboration
Metadata and Meta-Model Extensibility
- Take advantage of a simplified meta-model editor to quickly create custom meta-models and extend existing metadata with custom attributes
- Address new enterprise requirements with more flexibility
Enhanced Load Performance and Scalability
- Speed deployment and deliver the most up-to-date information faster with parallelized, high-performance metadata loading
 |
In the 8.5 release of PowerCenter Advanced Edition, Metadata Manager has made major advances in usability. Its personalization and collaboration capabilities make it a lot easier for our teams to get their work done. Also, the redesigned interface makes key tasks such as visualizing data lineage much more personalized, interactive and intuitive, allowing developers to quickly understand data relationships and conduct impact analysis. This really increases our productivity, as well as ensures consistency and visibility across the enterprise.
- Furio Lanzoni
Global BI - Informatica Shared Services
HP
 read the full story
| |
Benefits
- Increases confidence in data through enterprise-wide visibility into data definitions, lineage, and relationships
- Reduces compliance exposure by supporting monitoring and audit activities for data governance and stewardship
- Shortens time to delivery by ensuring the most comprehensive visibility into the potential impact of data changes and enhancements
- Reduces IT development and deployment costs by promoting reuse and enabling teams to collaborate more effectively
- Increases business agility by strengthening the alignment between business and IT and by providing additional business context to IT artifacts
Product Literature
Metadata Manager Datasheet
Metadata-Driven Data Integration White Paper
PowerCenter AE Datasheet
PowerCenter Brochure
|
 |
|
