Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerCenter 10.5
  • All Products

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

Back Next

Exporting Metadata to Business Objects Designer

Exporting Metadata to Business Objects Designer

Export metadata from PowerCenter to Business Objects Designer using the Repository Manager. You must have Business Objects installed and the Metadata Exchange option license key to export metadata to Business Objects Designer. When you export metadata from PowerCenter, PowerCenter uses MIMB to export the metadata to a Business Objects universe, and then opens Business Objects Designer with the exported universe.
Before you export metadata from PowerCenter, you must create a connection in Business Objects Designer to the database you want to export metadata from. For more information about creating a connection, see the documentation for Business Objects Designer.
The following table lists the export options in the Metadata Export Wizard for Business Objects Designer:
Option
Description
Connection Name
Connection to the database from which you want to export metadata. You must define this connection name in Business Objects Designer before you export metadata.
Login User
Login name for a repository installation of Business Objects Designer.
Business Objects Designer prompts for a user and password when you export metadata to repository installation of Business Objects Designer. Leave this field blank if you use a standalone version of Business Objects Designer or you want to manually enter the user name and password.
Login Password
Password for a repository installation of Business Objects Designer.
Login Offline
Login offline to a local universe. You can store a Business Objects universe locally or in a repository. You can select the following options:
  • True. The repository is stored locally.
  • False. The universe is stored locally or in a repository.
Login Repository Name
Name of the repository that contains the universe.
Close Designer
Closes Business Objects Designer after importing the universe from PowerCenter. Use this option to stop Business Objects Designer when it runs on a remote location.
Schema Export Algorithm
Updates the tables and joins in the exported universe.
Allow Outer Joins
Type of joins performed by PowerCenter when exporting metadata with tables that have foreign key columns. You can select the following options:
  • True. Use the foreign key relationship defined for the column.
  • False. Only allow inner joins when exporting tables referenced by a foreign key.
Fact Table
Name of the table to be treated as a fact table by Business Object Designer. Use this option to identify a source or target definition as a fact table when exporting metadata.
Assume Tables are Dimensions
Exports metadata as a dimension. You can select the following options:
  • True. Exports metadata as a dimension.
  • False. Does not export metadata as a dimension.
Dimensions Export Algorithm
Exports and updates dimensions in an existing Business Objects Designer universe. You can select the following options:
  • Don’t export dimensions
  • Replace dimensions
  • Create new dimensions
  • Update dimension’s description
Export Hierarchies
Exports the OLAP hierarchies in the exported source or targets definitions.
Naming Conventions
Exports the class and object names in the universe. You can leave the names as defined in PowerCenter or change them to all uppercase or all lowercase.
0 COMMENTS
We’d like to hear from you!