Exporting assets with InfoSphere Metadata Asset Manager

You can use the OMG CWM 1 XMI 1 bridge to export implemented data resources from the metadata repository.

Before you begin

  • You must have the role of Common Metadata Administrator.
  • Ensure that you meet all prerequisites for using bridges: Installing InfoSphere Metadata Asset Manager and bridges.

  • There are multiple versions of the CWM metamodel and XMI format. Ensure that you specify values for the export parameters that generate the appropriate OMG CWM XMI version for your target tool. Contact the vendor to obtain the exact version of the supported CWM metamodel and XMI format. More details on the valid combinations of metamodels and XMI formats are available at http://www.omg.org.

About this task

You export assets from the Repository Management tab. You can choose to export databases or database schemas.

When you export a database, its database schemas, database tables and other contained assets are exported. When you export a database schema, its database tables and other contained assets are exported.

The assets are exported to a file that is compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format.

Procedure

  1. Log in to InfoSphere® Metadata Asset Manager by clicking the desktop icon or entering the URL for the services tier computer in your browser.
    The URL is http_or_https://host:port/ibm/iis/imam/console.
  2. On the Repository Management tab, browse or search to find the database or database schema that you want to export.
    Option Description
    To browse for the database or database schema
    1. In the Navigation pane, click Browse Assets.
    2. Click Implemented Data Resources.
    3. In the Implemented Data Resources pane, expand the tree under the host computer that contains the database to display the database (database icon).
    4. If you are exporting a specific database schema, expand the tree further to display the schema (database schema icon).
    To search for the database or database schema
    1. In the Navigation pane, click Search.
    2. Enter the asset type and the name of the asset and click Search. The search is case-sensitive.
  3. Right-click the asset that you want to export and choose Export.
  4. Choose Export by using bridge as the type of export.
  5. Choose a metadata interchange server where the bridges are installed and select the OMG CWM 1 XMI 1 bridge.
  6. Click Next and enter parameter values for the bridge. Help for each parameter appears in the Parameter Help pane when you hover over the parameter name.

Results

The file and the export log are exported to a compressed file which is saved to the default temporary folder on your local computer.