Version 15
Created by blafond on Apr 10, 2013 10:38 AM. Last modified by blafond on Jan 9, 2014 9:04 AM.

    The Teiid Designer project provides a number of document formats for learning how to fully utilize all of it's VDB and data modeling features.  This document server as a starting point for finding the help you are looking for.

     

     

    How To....

     

     

     

     

    Example Model Projects


    You can download and import these example model project set zip files which represent fully modelled metadata for various simplified use-cases.

     

    Federate a remote URL file source and a remove XML file source.

    1) Download and import: download.jboss.org/teiid/designer/examples/user-defined-function-example.zip

      • The project contains a EMPLOYEE_DATA_SOURCE.xmi model, a EMPLOYEE_DATA_VIEWS.xmi model, a name_builder.jar containing the user defined function class NameBuilder

    2) Insure your server containing Teiid subsystem is started

    3) Open EMPLOYEE_VIEWS model and select Modelling > Preview Data for both EMPLOYEE_DATA and EmployeeInfo table

      • Previewing EMPLOYEE_DATA will return the raw data from the remote file source at:  http://download.jboss.org/teiid/designer/data/employees/file/EMPLOYEEDATA.txt
      • Previewing EmployeeInfo will return the concatenated full name for all employees as performed by the buildName() function in it's transformation :
        • SELECT BUILDFULLNAME(FirstName, MiddleName, LastName) AS FullName FROM EMPLOYEE_DATA

    4) Execute VDB and perform SELECT * FROM EMPLOYEE_DATA and SELECT * FROM EmployeeInfo

     

     

    Example Data

     

    We've compiled some test data for your convenience and made it available through the links below or you can download the files and use them as you see fit.

     

    Teiid Designer Flat File and XML File importers provide both local file system and remote URL based input.