You can translate the question and the replies:

DENODO connection from IBM Infosphere Datastage

We are trying to establish connectivity from within IBM infosphere datastage (V using JDBC stage. Datastage is running on AIX machine version 7.2 I have downloaded the required jar file "denodo_vdp_jdbcdriver.jar" and placed it inside directory "/opt/IBM/Infosphere/ASBNode/lib/java" Additionally updated the config file: [/opt/IBM/Infosphere/Server/DSEngine]**cat isjdbc.config.default** CLASSPATH=$APT_ORCHHOME/../../ASBNode/lib/java/ISredshift.jar;$APT_ORCHHOME/../../ASBNode/lib/java/denodo_vdp_jdbcdriver.jar CLASS_NAMES=com.denodo.vdp.jdbcDriver The connection is failing. Does anyone have any experience with successfully establishing such a connection? Please note - I am **NOT** looking to set it from websphere detailed "" since it had administrative restrictions in our setup.
26-04-2022 12:24:11 -0400

1 Answer

Hi, In such scenarios, I would ensure that the classname 'com.denodo.vdp.jdbc.Driver' has been provided and the driver 'denodo-vdp-jdbcdriver.jar' has been used to establish the connection. You could refer to [**Access Through JDBC**]( section of Virtual DataPort Developer Guide for more information about leveraging the JDBC driver for Northbound connections. For your scenario, you could check that the client application uses Java version 8 or higher to connect to the Denodo Platform 8.0. You could take a look at the Knowledge Base article **[Java versions supported by the Denodo Platform](** for more information. Further, you could take a look at the logs of IBM Infoshpere in case of debugging any errors during the connection. Hope this helps!
Denodo Team
28-04-2022 01:17:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here