Table of contents

Managing metadata

You can use IBM® InfoSphere® Metadata Asset Manager to import metadata from design tools, business intelligence tools, databases, and files into the metadata repository of InfoSphere Information Server. You can also export metadata.

You can use bridges and connectors to import metadata from third-party tools and from databases and files. You can then use this metadata to construct jobs in InfoSphere DataStage® and QualityStage® Designer or to create reports in InfoSphere Information Governance Catalog.

For example, you can use a bridge to import a physical data model from the CA ERwin design tool, and use the table and column metadata in that model to create a job that moves data from one database to another. Then you can use a bridge to import BI (business intelligence) reports from SAP BusinessObjects, and use InfoSphere Information Governance Catalog to analyze the flow of data from the job design to the report.

Importing and managing assets by using IBM InfoSphere Metadata Asset Manager
You can use bridges and connectors to import metadata into a staging area, where you can analyze and preview the contents of the import before you share it to the metadata repository. You can browse, search, and manage assets that are in the metadata repository. You can export database assets.

Exchanging metadata by using IBM InfoSphere Metadata Interchange Bridges
By using bridges you can import metadata from a wide range of sources, including IBM Cognos, SAP BusinessObjects, CA ERwin, and other tools. The prerequisites and import parameters for bridges are documented in detail in this section.

Common metadata assets
Common metadata assets are stored in the metadata repository and shared between tools in the InfoSphere™ Information Server suite. Common metadata assets include logical and physical data model assets, implemented data resources, and business intelligence (BI) assets.

Managing assets by using the command line
You can use the command line to move assets between different metadata repositories for environments such as development, test, and production. You can also query and delete common metadata assets and generate glossary assets from BI assets and logical data models.