products

PowerCenter Metadata Exchange Options

Driving Consistency Throughout the Data Integration Process

The Metadata Exchange Options allow organizations to access and interchange metadata between data modeling and business intelligence (BI) tools, and the PowerCenter metadata repository. This family of options makes it easy to import metadata from diverse applications into PowerCenter. They also automate the process of exporting metadata from PowerCenter back to a third-party application.

Key Features

Metadata Import and Export

  • Delivers wizard-driven user interface for easy selection of applications with which to exchange metadata
  • Imports source definitions into PowerCenter to aid development
  • Exports definitions out of PowerCenter to provide visibility into data transformation to other applications
  • Expands metadata descriptions in PowerCenter Designer with descriptive metadata documented in other applications
  • Supplies data modeling and business intelligence tools with metadata descriptions documented in PowerCenter

Standards Compliance

  • Adheres to the Common Warehouse Model (CWM) standard

Multi-Byte Metadata Support

  • Handles internationalization scenarios “out of the box”

Data Modeling Tools Business Intelligence Tools Data Standards
CA ERwin BusinessObjects Designer ODBC Database Catalog Access
CA Cool Gen Cognos Series 7 Impromptu Common Warehouse Model (CWM)
ERwin Fusion Model Manager Cognos ReportNet  
Embarcadero ERStudio Hyperion EIS  
Grandite Silverrun-RDM IBM DB2 Data Warehouse Edition/OLAP acceleration (Cube Views)  
IBM Rational Data Architect (EII) MicroStrategy  
IBM Rational Rose    
Microsoft Office Visio Database    
Oracle Designer    
Oracle Warehouse Builder    
Select SE    
Sybase PowerDesigner    
Telelogic (Popkin) System Architect    

Benefits

Speeds and Simplifies Data Delivery
With the Metadata Exchange Options, developers follow a wizard-based, step-by-step process to import and/or export the appropriate metadata into/from the PowerCenter metadata repository, making the development of data integration solutions faster and easier.

Enhance Data’s Relevance to the Business
These options allow IT organizations to readily align technical and business metadata within their critical reporting processes. The Metadata Exchange Options quickly propagate metadata between data modeling tools, PowerCenter, and business intelligence tools. Developers can ensure that users see the latest and most relevant view of their business data. Organizations across functional boundaries benefit from this timely, targeted reporting from the up-to-date data drawn from relevant systems.

Improve Data Accuracy
The Metadata Exchange Options ensure accurate data processing across the enterprise by verifying that metadata structures are consistent between PowerCenter and other applications. The options speed and simplify the metadata update process between systems to ensure ongoing consistency.

Product Literature

Metadata Exchange Options Datasheet
PowerCenter Brochure