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.

Select File > Import . The Select window appears.
Select Metadata as Virtual Schema Model and click Next. The first screen of the Metadata Import wizard appears.
Click Browse to list the project folders into which you can import the model; select a project folder from the list and click OK.
(Optional) Change the name of the metadata model (.amm file) in the File name field.
Click Next. The Import Type window appears.
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.
Click Browse to navigate to the location of your metadata model, select the file to import and click Next. The Catalog Chooser window appears.
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.
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.
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.