/teiid-embedded-examples

Examples for Teiid(http://teiid.org)

Primary LanguageJava

Teiid 10.x Embedded 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 -Dversion.teiid=<teiid.version> -s 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 to run embedded-portfolio against teiid 12.0.0:

$ cd teiid-embedded-examples/embedded-portfolio
$ mvn compile -Dversion.teiid=12.0.0 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.teiid</groupId>
      <artifactId>teiid-parent</artifactId>
      <version>${version.teiid}</version>
      <type>pom</type>
      <scope>import</scope>
    </dependency>

Links