Denodo Virtual DataPort includes out-of-the-box several functions and stored procedures which can be used to implement specific operations.
At some point, you may find that you need a function or stored procedure which doesn’t exist in Denodo Platform. For these situations, Denodo Platform provides an API (in Java) which allows developers to implement them in their Java code editor (we recommend Eclipse, in order to use the Denodo4E plugin) and import them later to the Denodo Platform.
Custom components can only be installed in Denodo Platform 7.0 installations.
You cannot import them if you are using Denodo Express 7.0
At the end of this tutorial, you will learn about:
- Install Denodo4E plugin
- How to develop a Virtual DataPort Custom Function
- How to implement a Stored Procedure
Of course, using the API you can develop more components! For example, custom data sources in Virtual DataPort, custom policies, Scheduler custom exporters and handlers. You can use this tutorial as starter point as the development of the rest of componets is very similar. Check the Virtual DataPort Developer Guide and Scheduler Guide for more information on this.
Before starting with this tutorial you will require to install the following resources in your workstation:
| Application | Download links |
|---|---|
| Denodo Platform 7.0 | Go to https://support.denodo.com/ and download the installer and your license. |
| Eclipse Neon (4.6) or Oxigen (4.7) | Go to https://www.eclipse.org/downloads/ to download and install it. |