Red Hat Training

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

9.8. Import Metadata From Text File

9.8.1. Import Metadata From Text File

The Teiid Designer provides various import options for parsing comma delimited text file metadata into models. This is accomplished via the Import > Teiid Designer > Designer Text File >> Source or View Models option.
  1. In Teiid Designer, Click File > Import action and then click Import...
  2. Select the import option Teiid Designer > Designer Text File >> Source or View Models and click Next>.
  3. Select an import type from the drop-down menu shown below.
    Import Wizard

    Figure 9.29. Import Wizard

These steps are required for each type are defined below:
  • Relation Model Text Import
  • Relational Table Text Import
  • Virtual Table Text Import
  • Datatype Table Text Import

9.8.2. Import Relational Model (XML Format)

To create relational tables from imported XML text file metadata, perform steps 1 to 3 from the Import Metadata from Text File section and then perform following steps:
  1. Select the Relational Model (XML Format) import type, then click Next >.
    Select Import Type - Relational Model (XML Format)

    Figure 9.30. Select Import Type - Relational Model (XML Format)

  2. On the next page, select the XML file on your local file system via the Browse... button. Select a target model to which the imported relational objects will be added via the second Browse... button. The dialog allows selecting an existing relational model or creating a new model. Note the contents of your selected XML file will be display in the File Contents viewer. Click Finish.
    Select Source Text File and Target Relational Model Page

    Figure 9.31. Select Source Text File and Target Relational Model Page

  3. If the target model contains named children (tables, views, procedures) that conflict with the objects being imported, a dialog will be displayed giving you options on how to proceed including: replacing specific existing objects, creating new same named objects or cancel import entirely.
    Duplicate Objects Dialog

    Figure 9.32. Duplicate Objects Dialog

9.8.3. Import Relational Tables (CSV Format)

To create relational tables from imported text file metadata, perform steps 1 to 3 from the Import Metadata from Text File section and then perform following steps:
  1. Select the Relational Tables (CSV Format) import type, then click Next >.
    Select Import Type - Relational Tables (CSV Format)

    Figure 9.33. Select Import Type - Relational Tables (CSV Format)

  2. In the next page, you'll need to provide a source text file containing the metadata formatted to the specifications on the previous page.
    Select Source Text File and Target Relational Model

    Figure 9.34. Select Source Text File and Target Relational Model

  3. Select an existing relational model as the target location for your new relational components using the Browse... button to open the Relational Model Selector dialog. Select a relational model from your workspace or specify a unique name to create a new model.
  4. Select any additional options and click Finish.

9.8.4. Import Relational View Tables (CSV Format)

To create relational virtual tables from imported text file metadata, perform steps 1 to 3 from the Import Metadata from Text File section and then perform following steps:
  1. Select the Relational Virtual Tables (CSV Format) import type, then click Next >.
    Select Import Type - Relational Virtual Tables (CSV Format)

    Figure 9.35. Select Import Type - Relational Virtual Tables (CSV Format)

  2. In the next page, you'll need to provide a source text file containing the metadata formatted to the specifications on the previous page.
    Select Source Text File and Target Virtual Relational Model

    Figure 9.36. Select Source Text File and Target Virtual Relational Model

  3. Select an existing relational virtual model as the target location for your new model components using the Browse... button to open the Virtual Model Selector dialog. Select a virtual relational model from your workspace or specify a unique name to create a new model.
  4. Click Finish.

9.8.5. Import Datatypes (CSV Format)

To create datatypes from imported text file metadata, perform steps 1 to 3 from the Import Metadata from Text File section and then perform following steps:
  1. Select the Datatypes (CSV Format) import type, then click Next >.
    Select Import Type - Datatypes (CSV Format)

    Figure 9.37. Select Import Type - Datatypes (CSV Format)

  2. In the next page, you'll need to provide a source text file containing the metadata formatted to the specifications on the previous page.
    Select Source Text File and Datatypes Model

    Figure 9.38. Select Source Text File and Datatypes Model

  3. Select an existing datatype model as the target location for your new model components using the Browse... button to open the Datatypes Model Selector dialog. Select a datatypes model from your workspace or specify a unique name to create a new model.
  4. Select any additional options and click Finish.