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.