The investor's portfolio example information is stored in a HSQL database and "current" stock prices are stored in a delimited text file. When the VDB is completed, a single query will cause Teiid to access the relational and non-relational sources, calculate the portfolio values, and return the results.
Note
HSQL database is used here since it is Open Source and comes with JBoss AS and is light-weight. You can substitute any other relational database, as long as you have a suitable JDBC driver. The schema file provided, and described below, is specific to HSQL, but can be easily converted for use with other databases.