Teiid Wildfly Quickstart

The Quickstart guide for data virtualization on a wildfly server using Teiid is documented at: http://github.com/teiid/teiid-quickstarts.

This Quick Start Guide takes you through an introduction to the concepts important to Teiid, downloading the software, building and deploying a virtual database and integrating data sources. The goal is to provide you with examples that help explain how to use to Teiid in order to get you off the ground. It also introduces to some of the essential concepts of Teiid.

Teiid Quickstarts

This Quick Start Guide takes you through an introduction to the concepts important to Teiid, downloading the software, building and deploying a virtual database and integrating data sources. The goal is to provide you with examples that help explain how to use to Teiid in order to get you off the ground. It also introduces to some of the essential concepts of Teiid.

TIP: Further Reading - Please read http://teiid.github.io/teiid-documents/master/content/[Teiid Documentation] to understand different terminologies used, resources needed, and artifacts to be generated before developing a successful application. This example takes advantage of only a minimal set of features in Teiid for the sake of simplicity and time.

NOTE: Ask Us - Ask us any questions you have on this Quick Start or any other Teiid related questions on https://community.jboss.org/en/teiid?view=discussions[Teiid Forums].

Introduction

Quick starts for http://teiid.jboss.org/[Teiid].

To contribute a quick start, goto http://github.com/teiid/teiid-quickstarts.

The link:dist[dist] folder contains the Maven scripts to build the quick start zip of the quickstarts.

Be sure to read this entire document before you attempt to work with the quickstarts. It contains the following information:

Available Quickstarts

The following is a list of the currently available quickstarts. The table lists each quickstart name, the features it demonstrates, and it gives a brief description of the quickstart. For more detailed information about a quickstart, click on the quickstart name.

Some quickstarts are designed to enhance or extend other quickstarts. These are noted in the Prerequisites column. If a quickstart lists prerequisites, those must be installed or deployed before working with the quickstart.


Quickstart NameFeatures DemonstratedDescriptionPrerequisites
datafederationData Federation, TEXTTABLE, Native Query, VDB Reuse, External Materialization, Excel FileShows how to expose multiple data sources for data federation and externally materialize a view to improve performanceNone
datarolesData rolesShows how to control Read/Write data access using data roles and maskingdatafederation
consume-webservices‘ws’ Translator, XMLTABLE, XMLPARSE, VIEW DDLDemonstrates the use of the ‘ws’ translator to read a web service data sourceNone
hibernateHibernate Integration, VDB ReUse, Create VIEW, Create Trigger, TEXTTABLEDemonstrates how a Hibernate application can add data federation capabilities at the data layerdatafederation
infinispan hotrod cache‘infinispan-hotrod’ translatorDemonstrates reading reading a remote infinispan cache using hotrod clientNone
infinispan remote materialize cache‘infinispan-hotrod’ translatorDemonstrates using a remote infinispan server as a materialization cache using hot rod clientNone
simpleclientTeiid JDBC ConnectionDemonstrates how to make a jdbc connection to Teiid using the Teiid JDBC Driver and DataSourceNone
tpchPerformance, Data FederationMeasures performance using TPC-H benchmark against two running Postgresql servers2 running PostgresSQL servers, Unix machine host
ldap-as-a-datasource‘ldap’ Translator, FOREIGN TABLE DDL, OpenLDAPDemonstrates using the ldap Translator to access data in OpenLDAP ServerOpenLDAP be installed, Groups ‘HR’ and Users under it be configured
mongodb-as-a-datasource‘mongodb’ Translator, FOREIGN TABLE DDLDemonstrates using the mongodb Translator to access documents in mongodbMongoDB be installed, docuemnts be inserted under ‘Employee’ connection
hbase-as-a-datasource‘hbase’ Translator, FOREIGN TABLE DDLDemonstrates using the Hbase Translator via the Pheonix driverHbase be installed
drools-integrationDrools integration, UDF, FOREIGN Function DDLDemonstrates using a simple rules invocation via a FunctionNone
hive-as-a-datasourceHDFS/Hive integration, Teiid, VDB, View, Hive TranslatorDemonstrates using Hive translator to access data in Hadoop/HiveHadoop Services, HiveServer2

System Requirements

To run these quickstarts with the provided build scripts, you need the following:

  • Use Java 1.8+ to run {{ book.asName }} and Maven. You can choose from the following:

    • OpenJDK
    • Oracle Java SE
    • Oracle JRockit
  • Maven 3.0.0 or newer, to build and deploy the examples

----
mvn --version 
----
  • The JBoss Enterprise Application Platform (EAP) 6 distribution ZIP or the {{ book.asName }} distribution ZIP that’s compatible with Teiid.
    • For information on how to install and run {{ book.asName }}, refer to the server documentation.
  • Set JBOSS_HOME to the root directory location of your application server, the scripts use this variable to determine where to deploy to.

Run the Quick Starts

The root folder of each quickstart contains a README file with specific details on how to build and run the example.

Open a command line and navigate to the root directory of the quickstart you want to run.