Red Hat SummitQuesto contenuto non è disponibile nella lingua selezionata.
9.8. Import Metadata From Text File
9.8.1. Import Metadata From Text File
Copia collegamentoCollegamento copiato negli appunti!
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.
- In Teiid Designer, Click File > Import action and then click Import...
- Select the import option Teiid Designer > Designer Text File >> Source or View Models and click Next>.
- Select an import type from the drop-down menu shown below.
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)
Copia collegamentoCollegamento copiato negli appunti!
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:
- Select the Relational Model (XML Format) import type, then click Next >.
Figure 9.30. Select Import Type - Relational Model (XML Format)
- On the next page, select the XML file on your local file system via the button. Select a target model to which the imported relational objects will be added via the second 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.
Figure 9.31. Select Source Text File and Target Relational Model Page
- 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.
Figure 9.32. Duplicate Objects Dialog
9.8.3. Import Relational Tables (CSV Format)
Copia collegamentoCollegamento copiato negli appunti!
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:
- Select the Relational Tables (CSV Format) import type, then click Next >.
Figure 9.33. Select Import Type - Relational Tables (CSV Format)
- In the next page, you'll need to provide a source text file containing the metadata formatted to the specifications on the previous page.
Figure 9.34. Select Source Text File and Target Relational Model
- 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.
- Select any additional options and click Finish.
9.8.4. Import Relational View Tables (CSV Format)
Copia collegamentoCollegamento copiato negli appunti!
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:
- Select the Relational Virtual Tables (CSV Format) import type, then click Next >.
Figure 9.35. Select Import Type - Relational Virtual Tables (CSV Format)
- In the next page, you'll need to provide a source text file containing the metadata formatted to the specifications on the previous page.
Figure 9.36. Select Source Text File and Target Virtual Relational Model
- 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.
- Click Finish.
9.8.5. Import Datatypes (CSV Format)
Copia collegamentoCollegamento copiato negli appunti!
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:
- Select the Datatypes (CSV Format) import type, then click Next >.
Figure 9.37. Select Import Type - Datatypes (CSV Format)
- In the next page, you'll need to provide a source text file containing the metadata formatted to the specifications on the previous page.
Figure 9.38. Select Source Text File and Datatypes Model
- Select an existing datatype model as the target location for your new model components using the 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.
- Select any additional options and click Finish.
'%20d='M201.5%20305.5c-13.8%200-24.9-11.1-24.9-24.6%200-13.8%2011.1-24.9%2024.9-24.9%2013.6%200%2024.6%2011.1%2024.6%2024.9%200%2013.6-11.1%2024.6-24.6%2024.6zM504%20256c0%20137-111%20248-248%20248S8%20393%208%20256%20119%208%20256%208s248%20111%20248%20248zm-132.3-41.2c-9.4%200-17.7%203.9-23.8%2010-22.4-15.5-52.6-25.5-86.1-26.6l17.4-78.3%2055.4%2012.5c0%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.3%2024.9-24.9s-11.1-24.9-24.9-24.9c-9.7%200-18%205.8-22.1%2013.8l-61.2-13.6c-3-.8-6.1%201.4-6.9%204.4l-19.1%2086.4c-33.2%201.4-63.1%2011.3-85.5%2026.8-6.1-6.4-14.7-10.2-24.1-10.2-34.9%200-46.3%2046.9-14.4%2062.8-1.1%205-1.7%2010.2-1.7%2015.5%200%2052.6%2059.2%2095.2%20132%2095.2%2073.1%200%20132.3-42.6%20132.3-95.2%200-5.3-.6-10.8-1.9-15.8%2031.3-16%2019.8-62.5-14.9-62.5zM302.8%20331c-18.2%2018.2-76.1%2017.9-93.6%200-2.2-2.2-6.1-2.2-8.3%200-2.5%202.5-2.5%206.4%200%208.6%2022.8%2022.8%2087.3%2022.8%20110.2%200%202.5-2.2%202.5-6.1%200-8.6-2.2-2.2-6.1-2.2-8.3%200zm7.7-75c-13.6%200-24.6%2011.1-24.6%2024.9%200%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.1%2024.9-24.6%200-13.8-11-24.9-24.9-24.9z'/%3e%3c/svg%3e){kind=small}