Red Hat Summit9.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.
Note
A running Teiid 8.3 or later instance is required. Ensure that the Default Server is started before you begin the import procedure.
Procedure 9.1. Import From Teiid Data Source Connection
- Choose the File > Import... action in the toolbar or go to the Model Explorer and wherever right click and select Import... .
- Select > >> and then click .
- 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.
- Click .
- Select the appropriate translator for your data source type and then click .
- Set the location where you plan to import the model, define a name for the model, specify any other options and then click .
- 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 .
- On the final page of the wizard, a difference report is presented for viewing or de-selecting individual relational entities. Press to complete.
