Using the External Schema Wizard

The External Schema Wizard automates the process of transforming a relational database model into a Jade object model.

Use the External Schema Wizard to access the catalog information from selected external data sources and generate classes. For details, see Chapter 3, "Transforming an External Relational Database".

Some data sources (ODBC drivers) may not support all catalog functions and some schemas may not contain all of the information required to derive or suggest possible relationships.

The External Schema Wizard enables you to:

Select data sources configured on the development workstation
Import information from a relational catalog, including tables, columns, primary and foreign keys, and indexes
Select tables for transformation
Map base tables or views, as well as join derived tables to classes
Select columns, and column to attribute mapping
Override default names suggested for all entities
Automatically map SQL types to Jade primitive types
Override the default Jade primitive types and length mappings
Define external collection types, based on suggested potential dictionaries using primary key and index information obtained from the catalog
Define relationships between derived classes, based on suggested potential relationships using foreign key information