I was able to successfully download the latest version of Denodo Xtrafuncs for VDP (version: 20210830) from the [support site](https://support.denodo.com/resources/denodo-connect/list/Denodo%208.0#) and it contains all the required jars (Date, Encryption, Pivot, String, Spatial). **Please make sure to download the latest version of xtrafuncs.**
To import the JAR files for pivot and unpivot functions, follow the below steps in the Virtual DataPort Administration Tool:
* Navigate to "File -> Extension Management".
* Click on **Import** and select the required jar files from the **dist** folder of Denodo Xtrafuncs for VDP.
The "**denodo-xtrafuncs-vdp-pivot-<version>-jar-with-dependencies.jar**" needs to be imported into the Virtual DataPort server, to use the desired pivot and unpivot Xtrafuncs in the Virtual DataPort Administration Tool.
* Click on **Ok** and refresh the tool by navigating to "File -> Refresh" for reflecting the changes.
After importing the jar files, you will be able to use the desired pivot functions.
For detailed information , you can refer to the [Denodo XtraFuncs - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual) section of the DenodoConnect Components.
Hope this helps!