Data Dictionary Import (Metadata Extraction)

This wizard is displayed when you click File, then Import, then Data Dictionary. It enables you to connect to an existing database (Oracle or supported third-party) and to create one or more relational models based on the metadata in that database.

The specific steps and fields depend on the type of database that you connect to. This topic describes information for an Oracle Database connection.

Connect to Database

Displays a list of database connections, from which you must select one. If no connections exist or if the one you want is not displayed, click Add to display the Database Connection Editor dialog box, or click Import to display the Import Database Connections dialog box.

Select Schema/Database

Select the schemas from which to import. Note: Metadata will be extracted only for schemas that the user associated with the connection is authorized to access. A separate subview will be created within the relational model for each Oracle Database schema from which metadata is extracted. (To see a subview, expand the Subviews node, right-click the subview name, and select Show Diagram.)

Select All and Deselect All (this page and next page): Enable you to conveniently select or deselect all displayed items, and then deselect or select individual items.

All Selected: Controls whether all items are initially selected or deselected when you move to the next page (Select Objects to Import).

Secondary Tables: Includes secondary tables in the metadata extraction.

Spatial Properties: Includes Oracle Spatial properties in the metadata extraction.

Select Objects to Import

Select the objects for the metadata extraction. For each type of object to be imported, click its associated tab (Tables, Views, Users, and so on), and select the desired objects. For each tab, you can select or deselect all, or you can select and deselect individual objects of that type.

Generate Design

Displays a summary page with the number of objects of specified types to be imported. (If no objects or any type are to be imported, go back to the Select Objects to Import page and select at least one object.)

To perform the import operation, click Finish.

Related Topics

Saving, Opening, Exporting, and Importing Designs