JBoss.orgCommunity Documentation

Teiid Designer User Guide

7.6.0

Copyright © 2011 Red Hat, Inc.

Legal Notice
1. Introduction
1.1. What is Teiid Designer?
1.2. Why Use Teiid Designer?
1.3. Metadata Overview
1.3.1. What is Metadata
1.3.2. Editing Metadata vs. Editing Data
1.3.3. Metadata Models
1.3.4. Business and Technical Metadata
1.3.5. Design-Time and Runtime Metadata
1.3.6. Source and View Metadata
1.4. It's all in the Modeling...
1.4.1. Model Object Extensions
2. New Model Wizards
2.1. Creating New Relational Source Model
2.1.1. Generate File Translator Procedures
2.1.2. Generate Web Service Translator Procedures
2.1.3. Copy From Existing Model
2.2. Creating New Relational View Model
2.2.1. Copy From Existing Model
2.2.2. Transform From Existing Model
2.2.3. Create From XML Schema
2.3. Creating XML Document View Model
2.3.1. Copy From Existing Model
2.3.2. Build XML Documents From XML Schema
2.4. Creating XML Schema Model
2.4.1. Copy From Existing Model
2.5. Creating Web Service View Model
2.5.1. Copy From Existing Model
2.5.2. Build From Existing WSDL File(s) or URL
2.5.3. Build From Relational Models
2.5.4. Build From XML Document View Models
3. Importers
3.1. Import DDL
3.2. Import From JDBC Database
3.3. Import From Flat File Source
3.4. Import From XML Data File Source
3.5. Import From Salesforce
3.6. Import Metadata From Text File
3.6.1. Import Relational Model (XML Format)
3.6.2. Import Relational Tables (CSV Format)
3.6.3. Import Relational View Tables (CSV Format)
3.6.4. Import Datatypes (CSV Format)
3.7. Import WSDL into Relational Source Model
3.8. Import WSDL Into Web Service
3.8.1. Import WSDL From Workspace Location
3.8.2. Import WSDL From File System Location
3.8.3. Import WSDL From URL
3.9. XSD Schema File
4. Creating and Editing Model Objects
4.1. Creating New Model Objects
4.1.1. New Child Action
4.1.2. New Sibling Action
4.1.3. New Association Action
4.2. Model Object Editors
4.2.1. Transformation Editor
4.2.2. Input Set Editor (XML)
4.2.3. Choice Editor (XML)
4.2.4. Recursion Editor (XML)
4.2.5. Operation Editor
4.3. Managing Model Object Extensions
4.3.1. Create New MED
4.3.2. Edit MED
4.3.3. Extending Models With MEDs
4.3.4. Setting Extended Property Values
5. Metadata-specific Modeling
5.1. Relational Source Modeling
5.1.1. Source Function
5.1.2. Create Relational Table Wizard
5.2. Relational View Modeling
5.2.1. Create Materialized Views
5.3. XML Document Modeling
5.3.1. Create XML View Documents from schema
5.4. Web Services Modeling
5.4.1. Create Web Service Action
5.4.2. Web Services War Generation
6. Editing Models and Projects
6.1. Rename A Model
6.2. Move Model
6.3. Save Copy of Model
6.4. Clone Project
7. Testing Your Models
7.1. Manage Connection Profiles
7.1.1. Set Connection Profile for Source Model
7.1.2. View Connection Profile for Source Model
7.1.3. Remove Connection Profile from Source Model
7.2. Previewing Data For a Model
7.2.1. Preview Relational Table or View
7.2.2. Preview Relational Table With Access Pattern
7.2.3. Preview Relational Procedure
7.2.4. Preview Web Service Operation
7.2.5. Sample SQL Results for Preview Data
7.3. Testing With Your VDB
7.3.1. Creating Data Sources
7.3.2. Execute VDB from Model Explorer
7.3.3. Deploy VDB from Model Explorer
7.3.4. Executing a Deployed VDB
8. Searching
8.1. Finding Model Objects
8.2. Search Models Via Relationship Properties
8.3. Search Transformation SQL
8.4. Search Models Via Metadata Properties
9. User Preferences
9.1. Teiid Designer Preferences
9.1.1. Diagram Preferences
9.1.2. Diagram Printing Preferences
9.1.3. Editor Preferences
9.1.4. Validation Preferences
10. Teiid Designer Ui Reference
10.1. Teiid Designer Perspectives
10.1.1. Teiid Designer Perspective
10.1.2. Opening a Perspective
10.1.3. Further information
10.2. Teiid Designer Views
10.2.1. Model Explorer View
10.2.2. Outline View
10.2.3. Teiid View
10.2.4. Properties View
10.2.5. Description View
10.2.6. Editors
10.2.7. Problems View
10.2.8. Search Results View
10.2.9. Datatype Hierarchy View
10.2.10. Teiid Model Classes View
10.2.11. System Catalog View
10.2.12. SQL Reserved Words View
10.2.13. Model Extension Definition Registry View (MED Registry View)
10.3. Editors
10.3.1. Model Editor
10.3.2. VDB Editor
10.3.3. Model Extension Definition Editor
10.4. Teiid Designer Main Menu
10.4.1. File Menu
10.4.2. Edit Menu
10.4.3. Refactor Menu
10.4.4. Navigate Menu
10.4.5. Search Menu
10.4.6. Project Menu
10.4.7. Metadata Menu
10.4.8. Run Menu
10.4.9. Window Menu
10.4.10. Help Menu