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 11.7.1.1) 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 "https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20Virtual%20DataPort%20from%20IBM%20Websphere?category=Northbound%20Connections" since it had administrative restrictions in our setup.
DENODO DATASTAGE Denodo vdp jdbc driver
user
26-04-2022 12:24:11 -0400
code

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**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/access_through_jdbc/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](https://community.denodo.com/kb/en/view/document/Java%20versions%20supported%20by%20the%20Denodo%20Platform)** 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
code
You must sign in to add an answer. If you do not have an account, you can register here