JBoss.orgCommunity Documentation

Teiid Designer

Users Guide

6.0.0

Legal Notice

1. Introduction
1.1. What is Designer?
1.2. Why Use 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. Models 101
1.4.1. What Are Models
1.4.2. How is a Model Defined?
1.4.3. Model Classes and Types
1.4.4. Models and VDBs
1.4.5. Models and Connector Bindings
1.4.6. Model Validation
1.4.7. Testing Your Models
2. Designer Perspectives
2.1. Designer Perspective
2.2. SQL Explorer Perspective
3. Designer Main Menu
3.1. File Menu
3.2. Edit Menu
3.3. Refactor Menu
3.4. Search Menu
3.5. Project Menu
3.6. Metadata Menu
3.7. Window Menu
3.8. Help Menu
4. Designer Views
4.1. Model Explorer View
4.1.1. Selection-Based Action Menus
4.2. Outline View
4.2.1. Outline Tree View
4.2.2. Outline Thumbnail View
4.3. UDFs View
4.4. Connectors View
4.5. Properties View
4.6. Description View
4.7. Editors
4.8. Problems View
4.8.1. Toolbar Items
4.8.2. Context Menu
4.9. Message Log View
4.10. Preview Results View
4.11. Search Results View
4.12. Datatype Hierarchy View
4.13. Model Classes View
4.14. System Catalog View
4.15. Database Structure View
4.16. SQL History View
4.17. Connections View
4.18. SQL Editor View
4.19. SQL Results View
5. Editors
5.1. Model Editor
5.1.1. Diagram Editor
5.1.2. Table Editor
5.1.3. Simple Datatypes Editor
5.1.4. Semantic Editor
5.1.5. Source Editor
5.1.6. Model Object Editors
5.2. VDB Editor
5.2.1. Overview
5.2.2. Problems
5.2.3. Indexes
5.2.4. User Files
5.2.5. Web Services
5.2.6. Execute
6. Importers
6.1. Import Archive File
6.2. Import From File System
6.3. Import From JDBC
6.4. Import Metadata From Text File
6.4.1. Import Relational Tables Text Importer
6.4.2. Import Relational Virtual Tables Text Importer
6.4.3. Import Relationships Text Importer
6.4.4. Import Datatypes Text Importer
6.5. Import WSDL as Relational Source
6.6. Import WSDL Into Web Service
6.6.1. Import WSDL From Workspace Location
6.6.2. Import WSDL From File System Location
6.6.3. Import WSDL From URL
6.7. XML Schema as Relational Source
6.8. XSD Schema File
6.9. Import Rational Rose Model
7. New Model Wizards
7.1. Creating New Relational Source Model
7.1.1. Copy From Existing Model
7.1.2. Generate From Existing UML Model
7.2. Creating New Relational View Model
7.2.1. Copy From Existing Model
7.2.2. Transform From Existing Model
7.2.3. Generate From Existing UML Model
7.2.4. Create From XML Schema
7.3. Creating New XML Service Source Model
7.3.1. Copy From Existing Model
7.4. Creating New XML Service View Model
7.4.1. Copy From Existing Model
7.5. Creating XML Document View Model
7.5.1. Copy From Existing Model
7.5.2. Build XML Documents From XML Schema
7.6. Creating XML Schema Model
7.6.1. Copy From Existing Model
7.7. Creating Web Service View Model
7.7.1. Copy From Existing Model
7.7.2. Build From Existing WSDL File(s) or URL
7.7.3. Build From Relational Models
7.7.4. Build From XML Document View Models
7.8. Creating New Extensions Model
7.8.1. Copy From Existing Model
7.9. Creating New Relationship Model
7.9.1. Copy From Existing Model
7.10. Creating New UML 2.0 Model
7.10.1. Copy From Existing Model
8. Creating and Editing Model Objects
8.1. Creating New Model Objects
8.1.1. New Child Action
8.1.2. New Sibling Action
8.1.3. New Association Action
8.2. Model Object Editors
8.2.1. Transformation Editor
8.2.2. Input Set Editor (XML)
8.2.3. Choice Editor (XML)
8.2.4. Recursion Editor (XML)
8.2.5. Operation Editor
9. Editing Models and Projects
9.1. Rename A Model
9.2. Move Model
9.3. Save Copy of Model
9.4. Clone Project
10. Testing Your Models
10.1. Manage Connector Bindings
10.1.1. Manage Connector Bindings
10.1.2. Create New Connector Binding
10.1.3. Binding Sources to Connectors
10.1.4. Importing Connector Bindings and Types
10.1.5. Export Connector Bindings
10.2. Previewing Data For a Model
10.2.1. Preview Relational Table or View
10.2.2. Preview Relational Table With Access Pattern
10.2.3. Preview Relational Procedure
10.2.4. Preview Web Service Operation
10.3. Testing With Your VDB
11. Searching
11.1. Finding Model Objects
11.2. Search Models Via Relationship Properties
11.3. Search Transformation SQL
11.4. Search Models Via Metadata Properties
12. Relationships
12.1. Creating Relationships
12.2. Creating your own Relationship Type
12.3. Relationship Navigator
13. User Preferences
13.1. Designer Preferences
13.1.1. Diagram Preferences
13.1.2. Diagram Printing Preferences
13.1.3. Editor Preferences
13.1.4. Validation Preferences
13.1.5. XML Schema Source Preferences
13.2. SQL Explorer Preferences
13.2.1. SQL Editor Preferences