Configure the Proxy Driver Connection in Denodo
To allow Denodo to communicate with the platform’s data proxy, install the platform's driver into Denodo.
The Denodo driver and the platform JDBC driver may have clashing instances of the SL4J library. To mitigate this, follow the steps below.
Unzip the dynamic driver using these commands to unzip the JDBC JAR, remove Privitar's instance of the SL4J libraries, and reconstitute the JAR file:
mkdir jdbc-modifications
unzip data_proxy_driver-[version].jar -d jdbc-modifications
rm -r jdbc-modifications/org/slf4j
cd jdbc-modifications
jar cf ../data_proxy_driver-[version]-modified.jar *
Copy the modified JAR file into Denodo's installation directory to register the DSP Platform as a data source:
mkdir [denodo platform installation directory]/lib/extensions/jdbc-drivers-other/privitar
cp data_proxy_driver-[version]-modified.jar [denodo platform installation directory]/lib/extensions/jdbc-drivers-other/privitar/
You may need to reboot the VirtualData Port server/daemon.