Table of content

• Administrator's Guide

  • Installation Guide

  • Deploying VDBs

    • Deploying VDB Dependencies

      • File Data Sources

      • Google Spreadsheet Data Sources

      • Infinispan Data Sources

      • JDBC Data Sources

      • LDAP Data Sources

      • Salesforce Data Sources

      • Web Service Data Sources

    • VDB Versioning

    • Migrating VDBs from 6.x

  • Teiid Security

    • LoginModules

    • Configuring SSL

    • Security at Data Source level

    • Kerberos support through GSSAPI

    • Generating Self Signed Certificate with Keytool

  • Logging

  • Clustering in Teiid

  • Performance Tuning

    • Memory Management

    • Threading

    • Cache Tuning

    • Socket Transports

    • LOBs

    • Other Considerations

  • Teiid Console

  • AdminShell

    • Getting Started

    • Executing a script file

    • Log File and Recorded Script file

    • Default Connection Properties

    • Handling Multiple Connections

    • Interactive Shell Nuances

  • Other Scripting Environments

  • System Properties

• Caching Guide

  • Results Caching

  • Materialized Views

    • External Materialization

    • Internal Materialization

  • Code Table Caching

  • Translator Results Caching

  • Hints and Options

• Client Developer's Guide

  • JDBC Support

    • Connecting to a Teiid Server

      • Driver Connection

      • Datasource Connection

      • Standalone Application

      • JBoss AS Data Source

      • Using Multiple Hosts

      • SSL Client Connections

    • Prepared Statements

    • ResultSet Limitations

    • JDBC Extensions

      • Statement Extensions

      • Partial Results Mode

      • blocking Statement Execution

      • ResultSet Extensions

      • Connection Extensions

    • Unsupported JDBC Methods

      • Unsupported Classes and Methods in "java.sql"

      • Unsupported Classes and Methods in "javax.sql"

  • ODBC Support

    • Installing the ODBC Driver Client

    • Configuring the Data Source Name (DSN)

    • DSN Less Connection

  • OData Support

  • Transactions

    • Local Transactions

    • Request Level Transactions

    • Using Global Transactions

    • Restrictions

  • Execution Properties

    • XML extensions

  • SET Statement

  • SHOW Statement

  • Reauthentication

  • Using Teiid with Hibernate

• Developer's Guide

  • Developing JEE Connectors

    • Using the Teiid Framework

    • Build and Package the Adapter

    • Adding Dependent Libraries

    • Deploying the Adapter

  • Translator Development

    • Setting up the build environment

    • Extending the ExecutionFactory Class

    • Connections to Source

    • Executing Commands

    • Command Language

    • Translator Capabilities

    • Large Objects

    • Caching API

    • Dependent Join Pushdown

    • Delegating Translator

    • Adding Dependent Modules

    • Packaging

    • Deployment

  • Extending The JDBC Translator

  • User Defined Functions

    • Source Supported Functions

    • Support for User-Defined Functions (Non-Pushdown)

  • AdminAPI

  • Custom Logging

  • Login Modules

  • Custom Authorization Validator

  • Runtime Updates

  • ra.xml file Template

  • Advanced Topics

  • Custom Metadata Repository

• Embedded Guide

• Legal Notice

• Quick Start Guide

  • What is Teiid

  • Downloading and Installing

  • Data Federation Example

    • Data Sources

    • Portfolio VDB

  • Data Roles Example

  • Web Services as a Data Source Example

  • Infinispan Local Cache as a Data Source Example

  • Connecting to Teiid - SimpleClient Example

• Reference Guide

  • SQL Support

    • Identifiers

    • Expressions

    • Criteria

    • Scalar Functions

      • Numeric Functions

      • String Functions

      • Date_Time Functions

      • Type Conversion Functions

      • Choice Functions

      • Decode Functions

      • Lookup Function

      • System Functions

      • XML Functions

      • JSON Functions

      • Security Functions

      • Miscellaneous Functions

      • Nondeterministic Function Handling

    • DML Commands

      • Set Operations

      • Subqueries

      • WITH Clause

      • SELECT Clause

      • FROM Clause

      • ARRAYTABLE

      • OBJECTTABLE

      • WHERE Clause

      • GROUP BY Clause

      • HAVING Clause

      • ORDER BY Clause

      • LIMIT Clause

      • INTO Clause

      • OPTION Clause

    • DDL Commands

      • Temp Tables

      • Alter View

      • Alter Procedure

      • Create Trigger

      • Alter Trigger

    • XML SELECT Command

      • Query Structure

      • Document Generation

    • Procedures

      • Procedure Language

      • Virtual Procedures

      • Update Procedures

  • Datatypes

    • Supported Types

    • Type Conversions

    • Special Conversion Cases

    • Escaped Literal Syntax

  • Updatable Views

    • preserved Table

  • Transaction Support

    • AutoCommitTxn Execution Property

    • Updating Model Count

    • JDBC and Transactions

    • Transactional Behavior with JBoss Data Source Types

    • Limitations and Workarounds

  • Data Roles

    • Permissions

    • Role Mapping

    • XML Definition

    • Customizing

  • System Schema

    • System Tables

    • System Procedures

  • VDBs

    • VDB Definition

    • Dynamic VDBs

    • Multi-Source Models

    • DDL Metadata

    • VDB Reuse

    • REST Service Through VDB

  • Translators

    • Delegating Translators

    • File Translator

    • Google Spreadsheet Translator

    • JDBC Translator

    • JPA Translator

    • LDAP Translator

    • Loopback Translator

    • Object Translator

    • OData Translator

    • OLAP Translator

    • Salesforce Translator

    • Web Services Translator

  • Federated Planning

    • Planning Overview

    • Federated Optimizations

    • Subquery Optimization

    • XQuery Optimization

    • Federated Failure Modes

    • Query Plans

    • Query Planner

  • Architecture

    • Terminology

    • Data Management

    • Query Termination

    • Processing

  • BNF for SQL Grammar