Teiid embedded samples Cassandra

Teiid Embedded is a light-weight version of Teiid, it contain an easy-to-use JDBC Driver that can embed the Query Engine in any Java application. The Embedded mode supply almost all Teiid features without JEE Container involved, it supply a convenient way for Users who want integrate Teiid with their Application.

This document show how Teiid Embedded use Cassandra as data source, the architecture as below:



Cassandra be used in this example, as in Cassandra Quick Start, Cassandra Contact Point host on, table users exist in keyspace demo, we have the following data inserted:

INSERT INTO users (firstname, lastname, age, email, city) VALUES ('John', 'Smith', 46, 'johnsmith@email.com', 'Sacramento');
INSERT INTO users (firstname, lastname, age, email, city) VALUES ('Jane', 'Doe', 36, 'janedoe@email.com', 'Beverly Hills');
INSERT INTO users (firstname, lastname, age, email, city) VALUES ('Rob', 'Byrne', 24, 'robbyrne@email.com', 'San Diego');

users VDB

A Virtual Database (VDB) is an artifact that defines the logical schema model combining one or more physical data sources to provide easy data integration. In this example, users VDB has Model UsersView point to Cassandra table users.

The completed content of users VDB


Java Application run on JVM, load the users VDB and query via JDBC. The mainly Code Snippets:

init("translator-cassandra", new CassandraExecutionFactory());
CassandraManagedConnectionFactory managedconnectionFactory = new CassandraManagedConnectionFactory();
server.addConnectionFactory("java:/demoCassandra", managedconnectionFactory.createConnectionFactory());
server.deployVDB(new FileInputStream(new File("vdb/cassandra-vdb.xml")));
conn = server.getDriver().connect("jdbc:teiid:users", null);

Completed Source code