SUMMARY.adoc

Summary

1. Legal Notice

2. Administrator’s Guide

   1. Installation Guide

   2. Deploying VDBs

      1. Deploying VDB Dependencies

         1. Accumulo Data Sources

         2. Amazon SimpleDB Data Sources

         3. Cassandra Data Sources

         4. Couchbase Data Sources

         5. File Data Sources

         6. Ftp/Ftps Data Sources

         7. Google Spreadsheet Data Sources

         8. Infinispan HotRod Data Sources

         9. JDBC Data Sources

         10. LDAP Data Sources

         11. MongoDB Data Sources

         12. Phoenix Data Sources

         13. Salesforce Data Sources

         14. Solr Data Sources

         15. Web Service Data Sources

             1. Kerberos with REST based Services

             2. OAuth Authentication With REST Based Services

      2. VDB Versioning

   3. Logging

   4. Clustering in Teiid

   5. Monitoring

   6. Performance Tuning

      1. Memory Management

      2. Threading

      3. Cache Tuning

      4. Socket Transports

      5. LOBs

      6. Other Considerations

   7. Teiid Console

   8. AdminShell

      1. Getting Started

      2. Executing a script file

      3. Log File and Recorded Script file

      4. Default Connection Properties

      5. Handling Multiple Connections

      6. Interactive Shell Nuances

   9. Other Scripting Environments

   10. System Properties

   11. Teiid Management CLI

   12. Diagnosing Issues

   13. Migration Guide From Teiid 10.x

   14. Migration Guide From Teiid 9.x

   15. Migration Guide From Teiid 8.x

3. Caching Guide

   1. Results Caching

   2. Materialized Views

      1. External Materialization

      2. Internal Materialization

   3. Code Table Caching

   4. Translator Results Caching

   5. Hints and Options

   6. Programmatic Control

4. Client Developer’s Guide

   1. JDBC Support

      1. Connecting to a Teiid Server

         1. Driver Connection

         2. DataSource Connection

         3. Standalone Application

         4. WildFly DataSource

         5. Using Multiple Hosts

         6. SSL Client Connections

         7. Additional Socket Client Settings

      2. Prepared Statements

      3. ResultSet Limitations

      4. JDBC Extensions

         1. Statement Extensions

         2. Partial Results Mode

         3. Non-blocking Statement Execution

         4. ResultSet Extensions

         5. Connection Extensions

      5. Unsupported JDBC Methods

         1. Unsupported Classes and Methods in "java.sql"

         2. Unsupported Classes and Methods in "javax.sql"

   2. ODBC Support

      1. Installing the ODBC Driver Client

      2. Configuring the Data Source Name (DSN)

      3. DSN Less Connection

      4. ODBC Connection Properties

   3. OData Support

      1. OData Version 4.0 Support

   4. Using Teiid with Hibernate

   5. Using Teiid with EclipseLink

   6. GeoServer Integration

   7. QGIS Integration

   8. SQLAlchemy Integration

   9. Node.js Integration

   10. ADO.NET Integration

   11. Reauthentication

   12. Execution Properties

   13. SET Statement

   14. SHOW Statement

   15. Transactions

       1. Local Transactions

       2. Request Level Transactions

       3. Using Global Transactions

       4. Restrictions

5. Developer’s Guide

   1. Developing JEE Connectors

      1. Connector Environment Setup

         1. Build Environment

         2. Archetype Template Connector Project

      2. Implementing the Teiid Framework

         1. ra.xml file Template

      3. Packaging the Adapter

         1. Adding Dependent Libraries

      4. Deploying the Adapter

   2. Translator Development

      1. Environment Setup

         1. Setting up the build environment

         2. Archetype Template Translator Project

      2. Implementing the Framework

         1. Caching API

         2. Command Language

         3. Connections to Source

         4. Dependent Join Pushdown

         5. Executing Commands

         6. Extending the ExecutionFactory Class

         7. Large Objects

         8. Translator Capabilities

         9. Translator Properties

      3. Extending The JDBC Translator

      4. Delegating Translator

      5. Packaging

         1. Adding Dependent Modules

      6. Deployment

   3. User Defined Functions

      1. Source Supported Functions

      2. Support for User-Defined Functions(Non-Pushdown)

         1. Archethype Template UDF Project

   4. AdminAPI

   5. Custom Logging

   6. Runtime Updates

   7. Custom Metadata Repository

   8. PreParser

      1. Archethype Template PreParser Project

6. Embedded Guide

   1. Logging in Teiid Embedded

   2. Secure Embedded with PicketBox

7. Reference Guide

   1. Data Sources

   2. Virtual Databases

      1. Developing a Virtual Database

      2. DDL VDB

      3. Using XML & DDL

      4. VDB Properties

      5. Schema Object DDL

      6. Domain DDL

      7. MultiSource Models

      8. Metadata Repositories

      9. REST Service Through VDB

   3. SQL Support

      1. Identifiers

      2. Expressions

      3. Criteria

      4. Scalar Functions

         1. Numeric Functions

         2. String Functions

         3. Date_Time Functions

         4. Type Conversion Functions

         5. Choice Functions

         6. Decode Functions

         7. Lookup Function

         8. System Functions

         9. XML Functions

         10. JSON Functions

         11. Security Functions

         12. Spatial Functions

         13. Miscellaneous Functions

         14. Nondeterministic Function Handling

      5. DML Commands

         1. Set Operations

         2. Subqueries

         3. WITH Clause

         4. SELECT Clause

         5. FROM Clause

            1. XMLTABLE

            2. ARRAYTABLE

            3. OBJECTTABLE

            4. TEXTTABLE

         6. WHERE Clause

         7. GROUP BY Clause

         8. HAVING Clause

         9. ORDER BY Clause

         10. LIMIT Clause

         11. INTO Clause

         12. OPTION Clause

      6. DDL Commands

         1. Temp Tables

         2. Alter View

         3. Alter Procedure

         4. Alter Trigger

      7. Procedures

         1. Procedure Language

         2. Virtual Procedures

         3. Update Procedures

      8. Comments

   4. Datatypes

      1. Supported Types

      2. Type Conversions

      3. Special Conversion Cases

      4. Escaped Literal Syntax

   5. Updatable Views

      1. preserved Table

   6. Transaction Support

      1. AutoCommitTxn Execution Property

      2. Updating Model Count

      3. JDBC and Transactions

      4. Transactional Behavior with JBoss Data Source Types

      5. Limitations and Workarounds

   7. Data Roles

      1. Permissions

      2. Role Mapping

      3. XML Definition

      4. Customizing

   8. System Schema

      1. SYS

      2. SYSADMIN

   9. Translators

      1. Amazon S3 Translator

      2. Amazon SimpleDB Translator

      3. Apache Accumulo Translator

      4. Apache SOLR Translator

      5. Cassandra Translator

      6. Couchbase Translator

      7. Delegating Translators

      8. File Translator

      9. Google Spreadsheet Translator

      10. Infinispan Translator

      11. JDBC Translators

          1. Actian Vector Translator

          2. Apache Phoenix Translator

          3. Cloudera Impala Translator

          4. DB2 Translator

          5. Derby Translator

          6. Exasol Translator

          7. Greenplum Translator

          8. H2 Translator

          9. Hive Translator

          10. HSQL Translator

          11. Informix Translator

          12. Ingres Translators

          13. Intersystems Cache Translator

          14. JDBC ANSI Translator

          15. JDBC Simple Translator

          16. MetaMatrix Translator

          17. Microsoft Access Translators

          18. Microsoft SQL Server Translator

          19. ModeShape Translator

          20. MySQL Translators

          21. Netezza Translator

          22. Oracle Translator

          23. OSISoft PI Translator

          24. PostgreSQL Translator

          25. PrestoDB Translator

          26. Redshift Translator

          27. SAP Hana Translator

          28. SAP IQ Translator

          29. Sybase Translator

          30. Teiid Translator

          31. Teradata Translator

          32. Vertica Translator

      12. JPA Translator

      13. LDAP Translator

      14. Loopback Translator

      15. Microsoft Excel Translator

      16. MongoDB Translator

      17. Object Translator

      18. OData Translator

      19. OData V4 Translator

      20. Swagger Translator

      21. OLAP Translator

      22. Salesforce Translators

      23. SAP Gateway Translator

      24. Web Services Translator

   10. Federated Planning

       1. Planning Overview

       2. Query Planner

       3. Query Plans

       4. Federated Optimizations

       5. Subquery Optimization

       6. XQuery Optimization

       7. Federated Failure Modes

       8. Conformed Tables

   11. Architecture

       1. Terminology

       2. Data Management

       3. Query Termination

       4. Processing

   12. BNF for SQL Grammar

8. Security Guide

   1. LoginModules

   2. Teiid Server Transport Security

   3. JDBC/ODBC SSL connection using self-signed SSL certificates

   4. Data Source Security

   5. Kerberos support through GSSAPI

   6. Custom Authorization Validator

   7. SAML Based Security For OData

   8. OAuth2 Based Security For OData Using KeyCloak

   9. SAML Based Security For OData Using KeyCloak