Stored Procedures

There are two ways of creating VQL procedures:

  1. In Java: Virtual DataPort has a Java API to do this. See Developing Stored Procedures - Developer Guide.

  2. In a procedural language. See Developing VQL Stored Procedures

This section explains how to import into Virtual DataPort stored procedure developed in Java.

The <DENODO_HOME>/samples/vdp/storedProcedures path contains several examples of Java stored procedures. The README file in this path describes what they do and contains instructions to compile and install them. The stored procedure CalculateAvgRevenue, included in these examples, will be used in this section.

To follow this example, you must:

  1. Execute the script <DENODO_HOME>/samples/vdp/storedProcedures/scripts/compile_storedprocedures

  2. Load the following Jar file using the Extension Management option: <DENODO_HOME>/samples/vdp/storedProcedures/target/jars/denodo-demo-storedprocedures.jar. This option is located in the menu File > Extension Management. See section Importing Extensions for more information.