JBoss.orgCommunity Documentation
If you would like to skip building your own VDB, you can safely go to next page and continue with the exercise as there is a pre-built VDB available for your convenience in the examples/portfolio/PortfolioModel directory of the download.
The Teiid Designer project provides a Eclipse based designer tool for this purpose of building a VDB. You can download Teiid Designer here Once downloaded, please follow the installation instructions. Start the Teiid Designer and return here to continue building the VDB.
Once you start the Designer, there are several steps you must perform to create a VDB. These steps are summarized in the following table. There is a video at the end of the list that will take you though all the steps involved.
Switch to the Designer Perspective, by opening the "Window->Open Perspective.."
Create new "Model Project", using "File->New->ModelProject"
Import the Derby database's "account" schema into a source model.
Manually create the source model for the "Text File". Create a Table called "Price" with "stock" and "price" as column names
Create a view model called "AccountView"
In the "AccountView" model, create a virtual table (called as Base Table in the menu), and build the transformation query combining the "Accounts" tables with "Price" table
In the "AccountView" model, create a virtual procedure called "buyStock", to learn about procedure language.
Create a VDB based on the models created
Test the created VDB with some ad-hoc queries inside Designer.
Export or copy the VDB for use in your application.