Examples for Teiid(http://teiid.org)
Java
Latest commit 32801b7 Jan 20, 2017 @kylinsoong kylinsoong committed on GitHub Merge pull request #46 from kylinsoong/master
TEIID-4701: add a example to demonstrate presto datasource
Permalink
Failed to load latest commit information.
bigdata-integration merge conflicts Nov 29, 2016
cassandra-as-a-datasourse TEIID-4502 removing useconnectormetadata Oct 10, 2016
drools-integration TEIID-3871: convert readme to gitbooks doc Dec 26, 2015
embedded-caching TEIID-4502 removing useconnectormetadata Oct 10, 2016
embedded-portfolio-jdbc-extensions TEIID-3940: Add an embedded example around continuous queries Jul 11, 2016
embedded-portfolio-logging TEIID-4502 removing useconnectormetadata Oct 10, 2016
embedded-portfolio-security TEIID-4502 removing useconnectormetadata Oct 10, 2016
embedded-portfolio-sockets TEIID-4322 adding example that demonstrates teiid embedded being acce… Jul 7, 2016
embedded-portfolio TEIID-4502 removing useconnectormetadata Oct 10, 2016
excel-as-a-datasource TEIID-4502 removing useconnectormetadata Oct 10, 2016
ldap-as-a-datasource TEIID-3871: convert readme to gitbooks doc Dec 26, 2015
loopback-example add a example for loopback trnasltor Sep 19, 2016
mongodb-as-a-datasource update twitter example May 10, 2016
odata4service-as-a-datasource TEIID-3871: convert readme to gitbooks doc Dec 26, 2015
odataservice-as-a-datasource TEIID-3871: convert readme to gitbooks doc Dec 26, 2015
prestodb-as-a-datasource TEIID-4701: add a example to demonstrate presto datasource Jan 20, 2017
restservice-as-a-datasource TEIID-4502 removing useconnectormetadata Oct 10, 2016
soapservice-as-a-datasource TEIID-4502 removing useconnectormetadata Oct 10, 2016
socialmedia-integration add doc for weibo as data source Nov 29, 2016
swagger-as-a-datasource TEIID-4502 removing useconnectormetadata Oct 10, 2016
vertica-as-a-datasource TEIID-4502 removing useconnectormetadata Oct 10, 2016
.gitignore TEIID-3871: convert readme to gitbooks doc Dec 26, 2015
LICENSE-lgpl-2.1.txt TEIID-3510: initial commit Jun 3, 2015
README.md TEIID-4514 updating to use managed dependencies Oct 24, 2016
SUMMARY.md TEIID-3871: convert readme to gitbooks doc Dec 26, 2015
book.json TEIID-4138: update book config Apr 14, 2016
pom.xml TEIID-4701: add a example to demonstrate presto datasource Jan 20, 2017
settings.xml 37: update document to pass a version number as a system properties t… Jun 6, 2016
teiid-logo.png TEIID-3871: convert readme to gitbooks doc Dec 26, 2015

README.md

Teiid Examples

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

Build

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