9.3. Import From JDBC Database

In Model Explorer, Click File > Import action in the toolbar or select a project, folder or model in the tree and click Import...

Select the import option Metadata Modeling > JDBC Database >> Source Model and click Next>.

Select existing or previous connection profile from the drop-down selector or click New... button to launch the New Connection Profile dialog or Edit... to modify/change an existing connection profile prior to selection.

Because JDBC databases are different, special processing of your metadata to be required in order to convert datatypes or to interpret your metadata. The JDBC Metadata Processor drop-down selector will be selected automatically based on your selected connection profile. Special processors are available for DB2, ModeShape, ODBC, Oracle, PostgeSQL, SQL Server and Sybase. For all other DBs a default JDBC processor is available.

After selecting a Connection Profile, enter the password (if not provided). Click Next> (or Finish if enabled).

On the Select Database Metadata page, select the types of objects in the database to import. Click Next> (or Finish if enabled).

On the Select Database Objects page, view the contents of the schema, or change selections. Select which database schema objects will be used to construct relational objects. Click Next> (or Finish if enabled).

On the Specify Import Options page, specify desired Model Name as well as any other options used to customize the naming of your relational objects. Click Finish to complete.

During the Finish processing, a monitor will be displayed providing feedback on the import progress.