Teiid Designer 7.6 Quick Start Guide

This article provides a quick-start example for importing JDBC Metadata into Designer to create a relational model, creating a VDB from that model as well as deploying and executing SQL queries via a JDBC connection through your Teiid VDB.

This guide assumes you have at least one JDBC data source available including type, driver jars, URL and other necessary connection information.

Install JBoss AS, Teiid & Teiid Designer

Install Jboss AS Server 5.1 (or greater)

Install Teiid 7.6 FINAL into the “../server/default” directory

Drop your JDBC driver jars into “../server/default/lib” directory. This will include the jars you used to Select while importing and creating JDBC Sources in Designer's JDBC Importer and the same jars you'll need when defining DTP Connection Profiles.

Open console window, navigate to AS install directory's “bin” directory

Start the server with ./run.sh

Install Teiid Designer 7.4 into your Eclipse 3.6 or above

Designer

If you don't have a database with schema and data defined, you can download the Parts Example and import into your workspace via "Import > General > Existing Projects into Workspace" and choose the "Select as archive file" option. This example comes with a readme.html to guide you through the database set-up steps as well as some of the steps described below.

Results are displayed in the SQL Results view provided by the Data Tools framework.

Create Data Source connection in Teiid

In order for a VDB to be executable, a Data Source (Connection Factory) needs to be deployed in the “.../server/default/deploy” directory. This will be in the form of “xxxx-ds.xml”. You can manage these items via JON/JOPR console.

The "Create Data Source" wizard displays your referenced connection profile, a default name (name of source model) and the connection properties that will be used to create the new data source.

This action should result in a new Data Source artifact showing as deployed to Teiid.

Create VDB

Select a Relational Model and choose “New > Virtual Database”

This will automatically add the Model to the VDB

You can still select project or nothing and create Empty VDB.

VDB Editor opens and contains your model (or empty)

Add model to VDB Editor if empty

You should have one row in the top table and have the “Translator” name and “JNDI” names populated.

If the Translator name is empty, enter an appropriate name from your Teiid view reflecting the DB your imported from (“oracle”, “sqlserver”, “derby”, etc..) or select table row for model and right-click select the “Change Translator” action. This will display a simple tree view of your servers containing available Translators. Select a Translator and hit OK.

Next you will need to supply a valid JNDI name for a Data Source (Connection Factory) on the server you wish to deploy your VDB to.

If you used the “Create Data Source” option above for your local Teiid and chose the default model name, the JNDI name should be set to this same default value.

If you wish, you can also look in “...server/default/deploy” folder for the generated xxxx-ds.xml file. The file name will contain the Test Project name, folder names and end with the Model Name + -ds.xml. Copy all but the -ds.xml and paste into the JNDI name field for your source model

This action should result in the VDB being deployed to your default server and a connection profile created/opened in the Eclipse Database Development perpective.

Note: This action will deploy the VDB to the “Default” server. If you have more than one server, the user is required to keep only one of the servers as the Default. You can change it by selecting a non-default Teiid server and right-click select “Set As Default” action.