Permalink
Switch branches/tags
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
68 lines (44 sloc) 6.37 KB

Reference Guide

Teiid is relational data integration engine that can combine the data from multiple heterogeneous sources.

This is a Reference guide for Teiid Spring Boot, for general Teiid Reference Guide consult link:http://teiid.github.io/teiid-documents/master/content/

Please Read User Guide to understand the problem this library is solving, this guide is more about description of the annotations in play.

Teiid Annotations

Most of the Teiid specific functionality is hidden in the set of Annotations provided by this framework. Annotations are used on a Entity class. If you are familiar with regular Teiid, consider that creating an Entity is equivalent creating a View. Using the annotations, this system gathers metadata about the View, similar to what you may have done using Teiid Designer or using DDL. Most of these annotations still require the user to define the DDL underneath as is in previous tools. But at the same time this library makes use of JPA annotations to define Entity structure. So, consider the below are extensions to JPA annotations that bring virtualization capabilities to a JPA based application without all the jargon of Teiid or a separate independent virtualization server.

The below are list of annotations that are part of the library, please refer to the JavaDoc of the annotation for detailed explanation and possibly code examples.

@SelectQuery

This probably is MOST important and MUST have annotation on any Entity classes that is being defined to read data or join data from two different sources. This defines the transformation query of the view. Take look at Javadoc for usage.

@InsertQuery

If your entity is joining the data from multiple sources, this annotation will provide a hook for a procedure where you can define the "insert" behavior. You can completely control which sources you want to update internally when a "insert" on Entity comes in from user. Take look at Javadoc for usage.

@UpdateQuery

If your entity is joining the data from multiple sources, this annotation will provide a hook for a procedure where you can define the "update" behavior. You can completely control which sources you want to update internally when a "update" on Entity comes in from user. Take look at Javadoc for usage.

@DeleteQuery

If your entity is joining the data from multiple sources, this annotation will provide a hook for a procedure where you can define the "delete" behavior. You can completely control which sources you want to update internally when a "delete" on Entity comes in from user. Take look at Javadoc for usage.

@TextTable

Unlike other annotations this annotation is used to read a CSV or fixed format text file. The Entity on which it is defined will behave exactly as if data were defined in a Database in like JPA to the user. Take look at Javadoc for usage.

@JsonTable

This annotation is similar to @TextTable, but provides a way to read a JSON payload into an Entity class. You can read the payload from a web resource or read from file location. Take look at Javadoc for usage. Also find find more complex example in samples.

@ExcelTable

This annotation is to read a Excel file into an Entity from a file location. See Excel translator in Teiid for more information Microsoft Excel Translator

@SourceFunction

If you want to use a source specific function (like SOUNDX in Oracle) that is not already defined by Teiid, then you can define this annotation on a Java Method that mimics the signature of the function in the source database. Then you can use this function in any of your queries. This Java method needs to be defined on a class that is annotated with @UserDefinedFunctions. The evalution of this functions will be pushed to source. Take look at Javadoc for usage. For more information see in Teiid documentation Source Supported Functions

@JavaFunction

If you want to define a user defined function (UDF) based on java code, that you can use in your Teiid queries, then you can define this annotation on a Java Method and supply the implementation of the method in Java. This Java method needs to be defined on a class that is annotated with @UserDefinedFunctions. Take look at Javadoc for usage. For more information see in Teiid documentation Support for User-Defined Functions (Non-Pushdown)

@RestConfiguration

When working with REST based sources with entities like @JsonTable or @TextTable, to configure http verbs or headers use this annotation to configure those properties. If used on any non REST based sources it will not have any effect.

Teiid Properties

General Properties

Property Description Default Value

spring.teiid.model.package

This property defines the package name, where the @Entity classes are defined in the application. This will be used to scan the classes and generate necessary metadata. In absense of this property whole classpath will be scanned which can lead very slow start up

* (all classpath)

logging.level.org.teiid.{context}

Defines the logging lvel for Teiid specific code. "spring" is context where spring boot specific log messages are defined. example: logging.level.org.teiid.spring=DEBUG

n/a

spring.teiid.file.parent-directory

When using the "file"based resources such as @TextTable, @ExcelTable this property defines a parent directory where files exist.

${user.dir} system property.

JDBC Data Source Properties

For configuring the JDBC data sources please see Data Access

Property Description Default Value

spring.datasource.{dsname}.platfrom

Name of the platform, where when init SQL queries for the database are provided this will be used ad postfix. See rdbms-file-example for example.

n/a

spring.datasource.{dsname}.importer.{property-name}

Translator importer properties to control the type and amount of metadata to import. See for more information about importer properties