Teiid Examples

Teiid Embedded Examples show how to integrate multiple, heterogeneous data stores and enterprise services in a light-weight way.

Build

• install JDK 1.7 or higher
• install maven 3 - http://maven.apache.org/download.html
• Optionally create a github account and fork Teiid Examples

Enter the following:

$ git clone https://github.com/teiid/teiid-embedded-examples.git
$ cd teiid-embedded-examples
$ mvn clean install -s -Dversion.teiid=<teiid.version> settings.xml

NOTE: if you forked the project, then use https://github.com//teiid-embedded-examples.git instead

NOTE: The examples default to using a version of Teiid close to the latest. If you want to run against a specific version, then either modify the root pom.xml version.teiid property or use -Dversion.teiid= as an argument to any mvn install or exec:java command.

Run

Run from Source code

Import teiid-embedded-examples source code to a IDE(Eclipse), then run each example with the corresponding Main method. For example, import embedded-portfolio to Eclipse, run org.teiid.example.TeiidEmbeddedPortfolio as java application.

Run from mvn

After the above Build section steps, the examples should have built successfully. Navigate to an example, then execute mvn exec commands. For example, using the following commands t0 run embedded-portfolio against teiid 9.0.0.Final:

$ cd teiid-embedded-examples/embedded-portfolio
$ mvn compile -Dversion.teiid=9.0.0.Final exec:java -s ../settings.xml

Available Examples

Quickstart Name	Features Demonstrated	Description	Prerequisites
embedded-portfolio	Teiid, Dynamic VDB, Native Queries, Data Federation, JDBC Translator, File Translator, TEXTTABLE	Demonstrates how to expose multiple data sources for data federation	None
embedded-portfolio-logging	Teiid, Dynamic VDB, Native Queries, Data Federation, JDBC Translator, File Translator, TEXTTABLE, JBoss LogManager, JBoss Logging	Demonstrates how to use JBoss LogManager with Teiid Embedded	None
embedded-portfolio-security	Teiid, Dynamic VDB, Native Queries, Data Federation, JDBC Translator, File Translator, TEXTTABLE, Jaas/Security	Demonstrates security authentication in Teiid Embedded	None
embedded-caching	Dynamic VDB, Native Queries, JDBC Translator, Results Caching, Materialized Views, Translator Results Caching	Demonstrates how Results Caching, Materialized Views works in Teiid	None
hbase-as-a-datasource	Teiid, Dynamic VDB, Foreign Table, HBase Translator	Demonstrates using the HBase Translator with Phoenix Data Source to access data in HBase	HBase Server, Phoenix Server
hadoop-integration-hive	Teiid, Dynamic VDB, View, Hive Translator	Demonstrates using the Hive Translator with HiveServer2 JDBC Driver to access data in Hadoop HDFS	Hadoop Services, HiveServer2
spark-integration-hive	Teiid, Dynamic VDB, View, Hive Translator	Demonstrates using the Hive Translator with HiveServer2 JDBC Driver to access Spark data	Spark Thrift JDBC/ODBC server, HiveServer2
vertica-as-a-datasource	Teiid, Dynamic VDB, View, Vertica Translator	Demonstrates using the Vertica Translator to access data in Vertica Server	HP Vertica(7.x) Analytic Database Server, Vertica JDBC Driver
drools-integration	Teiid, Dynamic VDB, User Defined Function, VIRTUAL FUNCTION, Drools API	Demonstrates using Teiid User Defined Function trigger and fire business rules	None
cassandra-as-a-datasourse	Teiid, Dynamic VDB, Cassandra Translator	Demonstrates using the Cassandra Translator to access table in Cassandra.	Cassandra Server installed, keyspace and table created
excel-as-a-datasource	Teiid, Dynamic VDB, Foreign Table, Excel Translator	Demonstrates using Excel Translator query Excel file with JDBC	None
ldap-as-a-datasource	Teiid, Dynamic VDB, Ldap Translator	Demonstrates using the ldap Translator to access data in OpenLDAP Server	OpenLDAP Server installed, Group 'HR' be created
mongodb-as-a-datasource	Teiid, Dynamic VDB, MongoDB Translator	Demonstrates using the MongoDB Translator to access data in mongodb	MongoDB Server installed, 'mydb' be created
twitter-as-a-datasource	Teiid, Dynamic VDB, View, WS Translator, OAuth 1, JAAS	Demonstrates using the WS Translator to interact with Twitter API	Create App in Twitter
odataservice-as-a-datasource	Teiid, Dynamic VDB, FOREIGN TABLE, OData Translator	Demonstrates using the WebService Connector connecting to an OData source and OData Translator to transform OData source to Teiid Foreign Table	None
odata4service-as-a-datasource	Teiid, Dynamic VDB, FOREIGN TABLE, OData4 Translator	Demonstrates using the WebService Connector connecting to an OData4 source and OData4 Translator to transform OData source to Teiid Foreign Table	None
restservice-as-a-datasource	Teiid, Dynamic VDB, XMLTABLE, XMLPARSE, WS Translator	Demonstrates using the WS Translator to call a REST web services and transform the web service results into relational results	customer service
soapservice-as-a-datasource	Teiid, Dynamic VDB, VIRTUAL PROCEDURE, XMLTABLE, SOAP Service, WS Translator	Demonstrates using the WS Translator to call a generic soap service	StateService service

Usage Notes

Some of the Teiid transitive dependencies have known vulnerabilities. WildFly/Teiid addresses this by introducing managed dependency overrides. It is recommended that you include these overrides in your usage of Teiid Embedded by importing the Teiid parent pom in your depedency management section:

<dependencyManagement>
  <dependencies>
    <dependency>
      <groupId>org.jboss.teiid</groupId>
      <artifactId>teiid-parent</artifactId>
      <version>${version.teiid}</version>
      <type>pom</type>
      <scope>import</scope>
    </dependency>

Links

• Teiid Website
• Teiid Documentation
• Teiid Examples Documentation
• Teiid JIRA
• Teiid User Forum