Importing a Metadata Model

You can import several kinds of data model (schema) files into WorkSpace Data Federation.

The following are supported import formats:
Format Sources Notes
ERwin XML ERWin 7.0.1  
JDBC An existing database connector to an external database You can import one table, multiple tables, or all tables from the database.
Physical data model (.pdm) Sybase PowerDesigner 12.0  

You will import the metadata model into a project folder. If you do not want to use an existing project folder, create a new project first.

  1. Select File > Import . The Select window appears.
  2. Select Metadata as Virtual Schema Model and click Next. The first screen of the Metadata Import wizard appears.
  3. Click Browse to list the project folders into which you can import the model; select a project folder from the list and click OK.
  4. (Optional) Change the name of the metadata model (.amm file) in the File name field.
  5. Click Next. The Import Type window appears.
  6. Click the data model type to import and click Next. Depending on which import type you choose, the dialogs display PDM, ERWIN, or DBconn if you chose JDBC. This procedure uses PowerDesigner.
  7. Click Browse to navigate to the location of your metadata model, select the file to import and click Next. The Catalog Chooser window appears.
  8. Select the catalog to import from the Catalog Chooser and click Next. The Schema Chooser window appears.
    Note: If your external schema contains no catalogs, “No catalogs” appears in the Catalog Chooser window.
  9. Select the schema to import from the list and click Next. The Table Chooser window appears.
    Note: If the external schema contains no schema, the message “No schemas” appears in the Schema Chooser window. In this instance, schema refers to a database user who owns a set of tables.
  10. Select any table or tables you want to import from the displayed list and click Finish. The metadata model editor displays the tables from the metadata model you imported.

    If the imported tables are sitting on top of one another, you can unstack them by right-clicking in the editor pane and selecting Tidy Tables from the context menu.

Related concepts
Metadata Models
Related tasks
Creating a Metadata Model
Editing a Metadata Model
Deriving a View Model from a Metadata Model
Mapping a Metadata Model to a Grid Object
Deleting a Metadata Model

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.