Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

9.3. Import From JDBC Database

You can create relational source models from your JDBC source schema data using the steps below.

Note

Depending the detail provided in the database connection URL information and schema, Steps 5 through 7 may not be required.
  1. In Model Explorer, Click File > Import action in the toolbar or select a project, folder or model in the tree and click Import...
  2. Select the import option Metadata Modeling > JDBC Database >> Source Model and click Next>.
  3. 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.

    Note

    The Connection Profile selection list will be populated with only JDBC Database connections.
    Select JDBC Source Configuration Dialog

    Figure 9.4. Select JDBC Source Configuration Dialog

    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.
  4. After selecting a Connection Profile, enter the password (if not provided). Click Next> (or Finish if enabled).
    Select JDBC Source Configuration Dialog

    Figure 9.5. Select JDBC Source Configuration Dialog

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

    Figure 9.6. Select Database Metadata Dialog

  6. 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).
    Select Database Options Dialog

    Figure 9.7. Select Database Options Dialog

  7. 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.
    Specify Import Options Dialog

    Figure 9.8. Specify Import Options Dialog

  8. During the Finish processing, a monitor will be displayed providing feedback on the import progress.
    JDBC Import Progress Dialog

    Figure 9.9. JDBC Import Progress Dialog