Virtual DataPort provides an API to develop custom stored procedures written in Java.
This section explains how to import them into the Server.
The section Developing Stored Procedures of the Developer Guide explains how to develop them.
<DENODO_HOME>/samples/vdp/storedProcedures path contains several
examples of 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:
- Execute the script
- Load the following Jar file using the Extension Management option:
DENODO_HOME/samples/vdp/storedProcedures/target/jars/denodo-demo-storedprocedures.jarThis option is located in the File > Extension Management menu. See section Importing Extensions for more information.