이 콘텐츠는 선택한 언어로 제공되지 않습니다.

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.

In Model Explorer, right-click and then click Import... or click the File > Import... action in the toolbar or select a project, folder or model in the tree and click Import...
Select the import option Teiid Designer > 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.
Note
The Connection Profile selection list will be populated with only JDBC Database connections.

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

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

Figure 9.6. Select Database Metadata Dialog
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).

Figure 9.7. Select Database Options Dialog
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.

Figure 9.8. Specify Import Options Dialog
During the Finish processing, a monitor will be displayed providing feedback on the import progress.

Figure 9.9. JDBC Import Progress Dialog