Red Hat Training

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

9.4. Import From Teiid Data Source Connection

The Teiid Connection Source Model import option provides a means to create relational source models from JDBC and other deployed data sources that are not supported by other Teiid Designer importers.

Procedure 9.1. Import From Teiid Data Source Connection

  1. Go to the Model Explorer.
  2. Choose the File - Import action in the toolbar.
    Select a project, folder or model in the tree and then select Import...
  3. Select Teiid Designer - Teiid Connection - Source Model and then click Next.
  4. Select the datasource to use for the import.
    You can create a new source if the one you want does not already exist. You can also undertake other source management functions here.
  5. Click Next.
  6. Select the appropriate translator for your data source type as well as defined the target relational model that you wish to create or update and then click Next.
  7. When you move to next page of the wizard, a temporary dynamic vdb is actually deployed to your server and the schema for your data source is retrieved in DDL form. This DDL is displayed (and you can also be exported if you so desire). Click Next.
  8. On the final page of the wizard, a difference report is presented for viewing or de-selecting individual relational entities. Press Finish to complete.