Introduction
Legal Notice
Administrator’s Guide
Installation Guide
Deploying VDBs
Deploying VDB Dependencies
Accumulo Data Sources
Amazon SimpleDB Data Sources
Cassandra Data Sources
Couchbase Data Sources
File Data Sources
Ftp/Ftps Data Sources
Google Spreadsheet Data Sources
Infinispan HotRod Data Sources
JDBC Data Sources
LDAP Data Sources
MongoDB Data Sources
Phoenix Data Sources
Salesforce Data Sources
Solr Data Sources
Web Service Data Sources
Kerberos with REST based Services
OAuth Authentication With REST Based Services
VDB Versioning
Logging
Clustering in Teiid
Monitoring
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
Teiid Management CLI
Diagnosing Issues
Migration Guide From Teiid 9.x
Migration Guide From Teiid 8.x
Caching Guide
Results Caching
Materialized Views
External Materialization
Internal Materialization
Code Table Caching
Translator Results Caching
Hints and Options
Programmatic Control
Client Developer’s Guide
JDBC Support
Connecting to a Teiid Server
Driver Connection
DataSource Connection
Standalone Application
WildFly DataSource
Using Multiple Hosts
SSL Client Connections
Additional Socket Client Settings
Prepared Statements
ResultSet Limitations
JDBC Extensions
Statement Extensions
Partial Results Mode
Non-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
ODBC Connection Properties
OData Support
OData Version 4.0 Support
Using Teiid with Hibernate
Using Teiid with EclipseLink
GeoServer Integration
QGIS Integration
SQLAlchemy Integration
Node.js Integration
Reauthentication
Execution Properties
SET Statement
SHOW Statement
Transactions
Local Transactions
Request Level Transactions
Using Global Transactions
Restrictions
Developer’s Guide
Developing JEE Connectors
Connector Environment Setup
Build Environment
Archetype Template Connector Project
Implementing the Teiid Framework
ra.xml file Template
Packaging the Adapter
Adding Dependent Libraries
Deploying the Adapter
Translator Development
Environment Setup
Setting up the build environment
Archetype Template Translator Project
Implementing the Framework
Caching API
Command Language
Connections to Source
Dependent Join Pushdown
Executing Commands
Extending the ExecutionFactory Class
Large Objects
Translator Capabilities
Translator Properties
Extending The JDBC Translator
Delegating Translator
Packaging
Adding Dependent Modules
Deployment
User Defined Functions
Source Supported Functions
Support for User-Defined Functions(Non-Pushdown)
Archethype Template UDF Project
AdminAPI
Custom Logging
Runtime Updates
Custom Metadata Repository
PreParser
Archethype Template PreParser Project
Embedded Guide
Logging in Teiid Embedded
Secure Embedded with PicketBox
Reference Guide
Data Sources
Virtual Databases
Developing a Virtual Database
DDL VDB
Using XML & DDL
VDB Properties
Schema Object DDL
Domain DDL
MultiSource Models
Metadata Repositories
REST Service Through VDB
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
Spatial Functions
Miscellaneous Functions
Nondeterministic Function Handling
DML Commands
Set Operations
Subqueries
WITH Clause
SELECT Clause
FROM Clause
XMLTABLE
ARRAYTABLE
OBJECTTABLE
TEXTTABLE
WHERE Clause
GROUP BY Clause
HAVING Clause
ORDER BY Clause
LIMIT Clause
INTO Clause
OPTION Clause
DDL Commands
Temp Tables
Alter View
Alter Procedure
Alter Trigger
Procedures
Procedure Language
Virtual Procedures
Update Procedures
Comments
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
SYS
SYSADMIN
Translators
Amazon S3 Translator
Amazon SimpleDB Translator
Apache Accumulo Translator
Apache SOLR Translator
Cassandra Translator
Couchbase Translator
Delegating Translators
File Translator
Google Spreadsheet Translator
Infinispan Translator
JDBC Translators
Actian Vector Translator
Apache Phoenix Translator
Cloudera Impala Translator
DB2 Translator
Derby Translator
Greenplum Translator
H2 Translator
Hive Translator
HSQL Translator
Informix Translator
Ingres Translators
Intersystems Cache Translator
JDBC ANSI Translator
JDBC Simple Translator
MetaMatrix Translator
Microsoft Access Translators
Microsoft SQL Server Translator
ModeShape Translator
MySQL Translators
Netezza Translator
Oracle Translator
OSISoft PI Translator
PostgreSQL Translator
PrestoDB Translator
Redshift Translator
SAP Hana Translator
SybaseIQ Translator
Sybase Translator
Teiid Translator
Teradata Translator
Vertica Translator
JPA Translator
LDAP Translator
Loopback Translator
Microsoft Excel Translator
MongoDB Translator
Object Translator
OData Translator
OData V4 Translator
Swagger Translator
OLAP Translator
Salesforce Translators
SAP Gateway Translator
Web Services Translator
Federated Planning
Planning Overview
Query Planner
Query Plans
Federated Optimizations
Subquery Optimization
XQuery Optimization
Federated Failure Modes
Conformed Tables
Architecture
Terminology
Data Management
Query Termination
Processing
BNF for SQL Grammar
Security Guide
LoginModules
Teiid Server Transport Security
JDBC/ODBC SSL connection using self-signed SSL certificates
Data Source Security
Kerberos support through GSSAPI
Custom Authorization Validator
SAML Based Security For OData
OAuth2 Based Security For OData Using KeyCloak
SAML Based Security For OData Using KeyCloak
Published with GitBook
JDBC Extensions
JDBC Extensions
These are custom extensions to JDBC API from Teiid to support various features.
results matching "
"
No results matching "
"