Table of content

• Administrator's Guide

  • Installation Guide

  • Deploying VDBs in Teiid 8

    • Deploying VDB Dependencies

    • VDB Versioning

    • Migrating VDBs from 6.x

  • Teiid Security

    • LoginModules

    • Configuring SSL

  • Logging

  • Clustering in Teiid

  • Performance Tuning

    • Memory Management

    • Threading

    • Cache Tuning

    • Socket Transports

    • LOBs

    • Other Considerations

  • Teiid Admin Console

    • What can be monitored and_or configured?

  • 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

  • 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

  • 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

    • Dependent Join Pushdown

    • Delegating Translator

    • Adding Dependent Libraries

    • Packaging

    • Deployment

  • Extending The JDBC Translator

  • User Defined Functions

    • Source Supported Functions

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

  • AdminAPI

  • Custom Logging

  • Security

  • Runtime Updates

  • ra.xml file Template

  • Advanced Topics

  • Custom Metadata Repository

• Legal Notice

• Quick Start Example

  • What is Teiid

  • Portfolio Example Explained

  • Setup Data Sources

  • Building a VDB

  • VDB Deployment

  • Connecting to a VDB through JDBC

• Reference Guide

  • DML Support

    • Identifiers

    • Expressions

    • Criteria

    • SQL Commands

    • Set Operations

    • Subqueries

  • SQL Clauses

    • WITH Clause

    • SELECT Clause

    • FROM Clause

    • ARRAYTABLE

    • 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

    • System Functions

    • Customizing

  • System Schema

    • System Tables

    • System Procedures

  • VDBs

    • VDB Definition

    • Dynamic VDBs

    • Multi-Source Models

    • DDL Metadata

  • Translators

    • Introduction to the Teiid Connector Architecture

    • Built-in Translators

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