Jump To Close Expand all Collapse all Table of contents User Guide Volume 1: Teiid Designer 1. Read Me Expand section "1. Read Me" Collapse section "1. Read Me" 1.1. Back Up Your Data 1.2. Variable Name: EAP_HOME 1.3. Variable Name: MODE 1.4. Red Hat Documentation Site 2. Some Key Terms Used Throughout this Document Expand section "2. Some Key Terms Used Throughout this Document" Collapse section "2. Some Key Terms Used Throughout this Document" 2.1. What is Teiid Designer? 2.2. What is Metadata? 2.3. Metadata Models 2.4. Business and Technical Metadata 2.5. Technical Metadata 2.6. Business Metadata 2.7. Design-Time and Runtime Metadata 2.8. Design-Time Metadata 2.9. Runtime Metadata 2.10. What are Models? 2.11. Source and View Metadata 2.12. Compact Node Type Definition 2.13. Java Content Repository 2.14. ModeShape Tools 2.15. The Virtual Database I. Teiid Designer Expand section "I. Teiid Designer" Collapse section "I. Teiid Designer" 3. Introduction to Teiid Designer Expand section "3. Introduction to Teiid Designer" Collapse section "3. Introduction to Teiid Designer" 3.1. Why Use Teiid Designer? 3.2. Modeling Your Source Metadata 3.3. Modeling Your View Metadata 4. : Models Expand section "4. : Models" Collapse section "4. : Models" 4.1. Guiding through the process 4.2. Model Classes and Types 4.3. VDB Content and Structure 4.4. Model Validation 4.5. Testing Your Models 5. Model Object Extensions Expand section "5. Model Object Extensions" Collapse section "5. Model Object Extensions" 5.1. Model Object Extensions 5.2. Model Extension Definition (MED) 5.3. Model Extension Definition Registry (MED Registry) 6. Server Management Expand section "6. Server Management" Collapse section "6. Server Management" 6.1. Targeting the JBoss Data Virtualization Server Expand section "6.1. Targeting the JBoss Data Virtualization Server" Collapse section "6.1. Targeting the JBoss Data Virtualization Server" 6.1.1. Targeting the JBoss Data Virtualization Server 6.1.2. Server Version Preference 6.1.3. Defining JBoss Data Virtualization Server 6.1.4. Server Version Status Panel 6.2. Setting up a Server 6.3. Connect JBDS to a Remote Red Hat JBoss Data Virtualization Server 7. Teiid Designer Examples Expand section "7. Teiid Designer Examples" Collapse section "7. Teiid Designer Examples" 7.1. Teiid Designer Examples 7.2. Guide View 7.3. Model a JDBC Source 7.4. Cheat Sheets 7.5. Consume a SOAP Web Service 8. New Model Wizards Expand section "8. New Model Wizards" Collapse section "8. New Model Wizards" 8.1. Launch New Model Wizards 8.2. Create New Relational Source Model Expand section "8.2. Create New Relational Source Model" Collapse section "8.2. Create New Relational Source Model" 8.2.1. Create a New Relational Source Model 8.2.2. Generate File Translator Procedures 8.2.3. Generate Web Service Translator Procedures 8.2.4. Copy from an Existing Relational Source Model 8.3. Create a New Relational View Model Expand section "8.3. Create a New Relational View Model" Collapse section "8.3. Create a New Relational View Model" 8.3.1. Create a New Relational View Model 8.3.2. Copy an Existing Relational View Model 8.3.3. Transform from an Existing Relational View Model 8.4. Create a New XML Document View Model Expand section "8.4. Create a New XML Document View Model" Collapse section "8.4. Create a New XML Document View Model" 8.4.1. Create a New XML Document View Model 8.4.2. Copy an Existing XML Document View Model 8.4.3. Build an XML Document View Model 8.5. Create a New XML Schema Model Expand section "8.5. Create a New XML Schema Model" Collapse section "8.5. Create a New XML Schema Model" 8.5.1. Create a New XML Schema Model 8.5.2. Copy an Existing XML Schema Model 8.6. Create a New Web Service View Model Expand section "8.6. Create a New Web Service View Model" Collapse section "8.6. Create a New Web Service View Model" 8.6.1. Create a New Web Service View Model 8.6.2. Copy an Existing Web Service View Model 8.6.3. Create a Web Service View Model from a WSDL File or URL 8.6.4. Create a Web Service View Model from XML Document View Models 9. Importers Expand section "9. Importers" Collapse section "9. Importers" 9.1. Importers 9.2. Import DDL 9.3. Import From JDBC Database 9.4. Import From Teiid Data Source Connection 9.5. Import From Flat File Source 9.6. Import From XML Data File Source 9.7. Import From Salesforce 9.8. Import Metadata From Text File Expand section "9.8. Import Metadata From Text File" Collapse section "9.8. Import Metadata From Text File" 9.8.1. Import Metadata From Text File 9.8.2. Import Relational Model (XML Format) 9.8.3. Import Relational Tables (CSV Format) 9.8.4. Import Relational View Tables (CSV Format) 9.8.5. Import Datatypes (CSV Format) 9.9. Import WSDL into Relational Models Expand section "9.9. Import WSDL into Relational Models" Collapse section "9.9. Import WSDL into Relational Models" 9.9.1. Import WSDL into Relational Models 9.9.2. Circular References in WSDL Schemas 9.10. Import WSDL Into Web Service Expand section "9.10. Import WSDL Into Web Service" Collapse section "9.10. Import WSDL Into Web Service" 9.10.1. Import WSDL Into Web Service 9.10.2. Import WSDL from Workspace Location 9.10.3. Import WSDL from File System Location 9.10.4. Import WSDL from URL 9.11. Import Data from REST Services 9.12. Lightweight Directory Access Protocol (LDAP) 9.13. Import From an LDAP Server 9.14. LDAP Connector Update Capabilities 9.15. XSD Schema File 9.16. Red Hat JBoss Data Grid and Complex Data Types 10. Creating and Editing Model Objects Expand section "10. Creating and Editing Model Objects" Collapse section "10. Creating and Editing Model Objects" 10.1. Creating New Model Objects Expand section "10.1. Creating New Model Objects" Collapse section "10.1. Creating New Model Objects" 10.1.1. Creating New Model Objects 10.1.2. New Child Action 10.1.3. New Sibling Action 10.1.4. New Association Action 10.1.5. New Model Objects Wizard 10.2. Model Object Editors 10.3. Transformation Editor Expand section "10.3. Transformation Editor" Collapse section "10.3. Transformation Editor" 10.3.1. Transformation Editor 10.3.2. Using the Reconciler 10.3.3. Using the Datatype Resolver 10.3.4. Using the Criteria Builder 10.3.5. Using the Expression Builder 10.4. Input Set Editor (XML) 10.5. Choice Editor (XML) Expand section "10.5. Choice Editor (XML)" Collapse section "10.5. Choice Editor (XML)" 10.5.1. Choice Editor (XML) 10.5.2. Excluding Fragments 10.5.3. Editing Choice Criteria 10.5.4. Setting Choice Element Order 10.5.5. Setting a Default Choice Action 10.6. Recursion Editor (XML) Expand section "10.6. Recursion Editor (XML)" Collapse section "10.6. Recursion Editor (XML)" 10.6.1. What is Recursion? 10.6.2. Recursion Editor (XML) 10.6.3. Edit Recursion Properties 10.7. Operation Editor 10.8. Managing Model Object Extensions Expand section "10.8. Managing Model Object Extensions" Collapse section "10.8. Managing Model Object Extensions" 10.8.1. Managing Model Object Extensions 10.8.2. Create New MED 10.8.3. Edit MED 10.8.4. Extending Models With MEDs 10.8.5. Setting Extended Property Values 11. User Defined Functions Expand section "11. User Defined Functions" Collapse section "11. User Defined Functions" 11.1. User Defined Functions 11.2. Modeling your functions 11.3. Utilizing your Functions in Transformations 11.4. Including Functions in your VDB 12. Metadata-specific Modeling Expand section "12. Metadata-specific Modeling" Collapse section "12. Metadata-specific Modeling" 12.1. Relational Source Modeling Expand section "12.1. Relational Source Modeling" Collapse section "12.1. Relational Source Modeling" 12.1.1. Source Function 12.1.2. Create Relational Table Wizard 12.2. Relational View Modeling Expand section "12.2. Relational View Modeling" Collapse section "12.2. Relational View Modeling" 12.2.1. Create Materialized Views 12.2.2. JDG Materialization 12.2.3. Create Relational View Table Wizard 12.3. XML Document Modeling Expand section "12.3. XML Document Modeling" Collapse section "12.3. XML Document Modeling" 12.3.1. Create XML View Documents from Schema 12.4. Web Services Modeling Expand section "12.4. Web Services Modeling" Collapse section "12.4. Web Services Modeling" 12.4.1. Create Web Service Action 12.4.2. Web Services War Generation 13. Editing Models and Projects Expand section "13. Editing Models and Projects" Collapse section "13. Editing Models and Projects" 13.1. Editing Models and Projects 13.2. Rename A Model 13.3. Move Model 13.4. Save Copy of Model 13.5. Clone Project 14. Managing Your Virtual Databases Expand section "14. Managing Your Virtual Databases" Collapse section "14. Managing Your Virtual Databases" 14.1. Create a Virtual Database 14.2. Edit a Virtual Database 14.3. Multi-Source Binding Support 14.4. User-Defined Functions Support 14.5. Reusing Virtual Databases 14.6. Create a VDB Source Model 14.7. Security and Data Access 15. Testing Your Models Expand section "15. Testing Your Models" Collapse section "15. Testing Your Models" 15.1. Manage Connection Profiles Expand section "15.1. Manage Connection Profiles" Collapse section "15.1. Manage Connection Profiles" 15.1.1. Manage Connection Profiles 15.1.2. Set Connection Profile for Source Model 15.1.3. View Connection Profile for Source Model 15.1.4. Remove Connection Profile from Source Model 15.2. Previewing Data For a Model Expand section "15.2. Previewing Data For a Model" Collapse section "15.2. Previewing Data For a Model" 15.2.1. Previewing Data For a Model 15.2.2. Preview Relational Table or View 15.2.3. Preview Relational Table With Access Pattern 15.2.4. Preview Relational Procedure 15.2.5. Preview Web Service Operation 15.2.6. Sample SQL Results for Preview Data 15.2.7. Execution Plans 15.3. Testing With Your VDB Expand section "15.3. Testing With Your VDB" Collapse section "15.3. Testing With Your VDB" 15.3.1. Testing With Your VDB 15.3.2. Creating Data Sources 15.3.3. Execute VDB from Model Explorer 15.3.4. Deploy VDB from Model Explorer 15.3.5. Executing a Deployed VDB 16. Searching Expand section "16. Searching" Collapse section "16. Searching" 16.1. Searching 16.2. Finding Model Objects 16.3. Search Transformation SQL 16.4. Search Models Via Metadata Properties A. Supported Configurations Expand section "A. Supported Configurations" Collapse section "A. Supported Configurations" A.1. Supported Data Sources and Translators A.2. Designer Metadata Usage Requirements In JBoss Data Virtualization Runtime B. User Preferences Expand section "B. User Preferences" Collapse section "B. User Preferences" B.1. User Preferences B.2. Teiid Designer Preferences B.3. Diagram Preferences B.4. Editor Preferences Expand section "B.4. Editor Preferences" Collapse section "B.4. Editor Preferences" B.4.1. XML Document Preferences B.4.2. Table Editor Preferences B.4.3. Transformation Editor Preferences B.4.4. VDB Editor Preferences B.5. Validation Preferences C. Teiid Designer UI Reference Expand section "C. Teiid Designer UI Reference" Collapse section "C. Teiid Designer UI Reference" C.1. Teiid Designer Perspectives C.2. Teiid Designer Perspective C.3. Opening a Perspective C.4. Further Information D. Teiid Designer Views Expand section "D. Teiid Designer Views" Collapse section "D. Teiid Designer Views" D.1. Teiid Designer Views D.2. Model Explorer View D.3. Selection-Based Action Menus D.4. Outline View D.5. Outline Tree View D.6. Outline Thumbnail View D.7. Server View D.8. Properties View D.9. Description View D.10. Problems View D.11. Toolbar Menu D.12. Context Menu D.13. Search Results View D.14. Datatype Hierarchy View D.15. Teiid Model Classes View D.16. System Catalog View D.17. SQL Reserved Words View D.18. Model Extension Definition Registry View (MED Registry View) D.19. Guides View D.20. Status View D.21. Cheat Sheets View E. Editors Expand section "E. Editors" Collapse section "E. Editors" E.1. Editors E.2. Model Editor Expand section "E.2. Model Editor" Collapse section "E.2. Model Editor" E.2.1. Model Editor E.2.2. Diagram Editor E.2.3. Package Diagram E.2.4. Custom Diagram E.2.5. Transformation Diagram E.2.6. Mapping Diagram E.2.7. Mapping Transformation Diagram E.3. Table Editor Expand section "E.3. Table Editor" Collapse section "E.3. Table Editor" E.3.1. Table Editor E.3.2. Editing Properties E.3.3. Inserting Table Rows E.4. Simple Datatypes Editor E.5. Semantic Editor E.6. Source Editor E.7. Model Object Editors E.8. VDB Editor Expand section "E.8. VDB Editor" Collapse section "E.8. VDB Editor" E.8.1. VDB Editor E.8.2. Editing Data Roles E.8.3. Editing Translator Overrides E.9. Model Extension Definition Editor F. Teiid Designer Main Menu Expand section "F. Teiid Designer Main Menu" Collapse section "F. Teiid Designer Main Menu" F.1. Teiid Designer Main Menu F.2. File Menu F.3. Edit Menu F.4. Refactor Menu F.5. Navigate Menu F.6. Search Menu F.7. Project Menu F.8. Metadata Menu F.9. Run Menu F.10. Window Menu F.11. Help Menu G. Revision History Legal Notice Settings Close Language: English 日本語 Language: English 日本語 Format: Multi-page Single-page PDF Format: Multi-page Single-page PDF Language and Page Formatting Options Language: English 日本語 Language: English 日本語 Format: Multi-page Single-page PDF Format: Multi-page Single-page PDF Red Hat Training A Red Hat training course is available for Red Hat JBoss Data Virtualization E.6. Source Editor The Source Editor is a simple text editor which is aware of XML Schema formatting rules. Previous Next