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

    • Security at Data Source level

    • Kerberos support through GSSAPI

    • Configuring SSL

  • 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

  • Connecting to Teiid Server

    • Driver Connection

    • Datasource Connection

    • Standalone Application

    • JBoss AS Data Source

    • Using Multiple Hosts

    • Reauthentication

  • Prepared Statements

  • Teiid extensions to the JDBC API

    • Statement Extensions

    • Execution Properties

    • SET Statement

    • SHOW Statement

    • Transaction Statements

    • Partial Results Mode

    • XML extensions

    • blocking Statement Execution

    • ResultSet Extensions

  • Transactions with JDBC

    • Local Transactions

    • Request Level Transactions

    • Using Global Transactions

    • Restrictions

  • SSL Client Connections

  • Using Teiid with Hibernate

  • ODBC Support

    • Installing the ODBC Driver Client

    • Configuring the Data Source Name (DSN)

    • DSN Less Connection

  • Unsupported JDBC Methods

    • ResultSet Limitations

    • Unsupported Classes and Methods in "java.sql"

    • Unsupported Classes and Methods in "javax.sql"

  • Generating Self Signed Certificate with Keytool

• 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

  • DML Support

    • Identifiers

    • Expressions

    • Criteria

    • SQL Commands

    • Set Operations

    • Subqueries

  • SQL Clauses

    • WITH Clause

    • SELECT Clause

    • FROM Clause

    • ARRAYTABLE

    • OBJECTABLE

    • WHERE Clause

    • GROUP BY Clause

    • HAVING Clause

    • ORDER BY Clause

    • LIMIT Clause

    • INTO Clause

    • OPTION Clause

  • DDL Support

    • Temp Tables

    • Alter View

    • Alter Procedure

    • Create Trigger

    • Alter Trigger

  • XML SELECT Command

    • Overview

    • Query Structure

    • Document Generation

  • Datatypes

    • Supported Types

    • Type Conversions

    • Special Conversion Cases

    • Escaped Literal Syntax

  • Scalar Functions

    • Numeric Functions

    • String Functions

    • Date_Time Functions

    • Type Conversion Functions

    • Choice Functions

    • Decode Functions

    • Lookup Function

    • System Functions

    • XML Functions

    • Security Functions

    • Miscellaneous Functions

    • Nondeterministic Function Handling

  • Updatable Views

    • preserved Table

  • Procedures

    • Procedure Language

    • Virtual Procedures

    • Update Procedures

  • 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

    • Built-in Translators

      • Delegating Translators

      • File Translator

      • Google Spreadsheet Translator

      • JDBC Translator

      • JPA Translator

      • LDAP Translator

      • Loopback Translator

      • Object 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