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”
| 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
|