9.3. Import From JDBC Database
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 > . Select existing or 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 > (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 > (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 > (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