Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

Exchanging Metadata Overview

Exchanging Metadata Overview

Use the Repository Manager to share source and target metadata with other business intelligence (BI) and data modeling tools, such as Business Objects Designer. PowerCenter uses the Meta Integration® Model Bridge (MIMB) from Meta Integration Technology, Inc. to exchange metadata with other BI and data modeling tools. MIMB uses the specifications in powrmart.dtd to exchange metadata with PowerCenter.
Use metadata exchange to synchronize definitions between PowerCenter and third-party tools. For example, you might export some fact and dimension targets to Business Objects Designer and then add a column to each target using Business Objects Designer. You can then import those targets into a repository to update the target definitions with the changes you made in Business Objects Designer.
The Repository Manager uses a wizard to guide you through the export or import process. The wizard prompts you for different options, depending on the BI or data modeling tool. Use the Conflict Resolution Wizard to resolve conflicts between objects when you import metadata. The Conflict Resolution Wizard is similar to the Copy Wizard.
To exchange metadata, you export the metadata from the source tool and import the metadata into the target tool. PowerCenter can be the source or target tool. To exchange metadata between PowerCenter and another tool, use one of the follow methods:
  • Use PowerCenter as the source tool.
    In PowerCenter, export metadata to a file recognized by the target tool, and then use the target BI or data modeling tool to import metadata from the file.
  • Use the BI or data modeling tool as the source tool.
    In the source BI or data modeling tool, export metadata to a file recognized by the source tool, and then use PowerCenter to import metadata from the file.
To export metadata, select an object and click Repository > Export Metadata. To import metadata, select a folder and click Repository > Import Metadata.
You can export to and import from the following BI and data modeling tools:
  • Adaptive Repository Foundation
  • Business Objects Data Integrator
  • Business Objects Designer
  • CA ERwin Data Modeler 4.x and CA ERwin Data Modeler 7.x
  • CA ERwin 3.0 (export only), CA ERwin 3.x (ERX), and CA ERwin 3.5x (export only)
  • CA Gen
  • Cognos Impromptu (import only)
  • Cognos ReportNet Framework Manager
  • Embarcadero ER/Studio
  • Hyperion Application Builder
  • Hyperion Essbase Integration Services
  • IBM DB2 Cube Views
  • IBM DB2 Warehouse Manager
  • IBM Rational Rose
  • Microsoft Visio Database
  • MicroStrategy
  • OMG CWM
  • Oracle Designer
  • Oracle Warehouse Builder
  • Popkin System Architect
  • SAS ETL Studio
  • Select SE
  • Silverrun-RDM
  • Sybase PowerDesigner
You can also exchange metadata with BI and data modeling tools by using the Export Objects and Import Objects menu commands. You do not need a PowerCenter Metadata Exchange option license key, but you must be able to export or import XML files that conform to powrmart.dtd.

0 COMMENTS

We’d like to hear from you!