Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

11.2. Modeling your functions

Teiid Designer provides an object wizard to assist you in modeling your User Defined Functions. Right-click the existing Relational View Model and click New Child - Procedure and then click on the radio button for "User Defined Function". In the wizard, you can see an option to specify the function's jar location on your file system, as well as the Java class and the Java method.
If you create a function using alternative methods, you must select the procedure and edit the different properties for the procedure in the Properties view.
VDB UDF Jar Files

Figure 11.1. VDB UDF Jar Files

A User Defined Function represents a defined method in a java class. In order for the Teiid runtime to register the function and allow its use in the transformations, you must specify the following as properties:
  • Function Category - unique name for a grouping of user defined functions. This category is displayed in the Expression Builder wizard so you can locate and select your function.
  • Java Class - fully qualified name of the java class containing your function method.
  • Java Method - the name of the function method in your java class.
  • UDF Jar Path - the relative path in your project for the jar containing your UDF which will be in a lib folder in your project. If you are defining your jar for the first time and there is no jars in your lib folder, the property editor will allow you to select a jar from your file system. If one or more jars already exist in a lib folder, the editor will allow you to choose between selecting from your workspace or your file system.