DB Connection to Denodo virtual database not working in Knime 4.7.0 version

KNIME Analytics Platform
1

Hi.
We are currently using Knime AP 4.3.0 version. We have a Denodo virtual database (Denodo 7.0 version) where we get lots of data for our needs. Now we have also a Knime AP 4.7.0 installation we are doing tests in order to upgrade all our PCs to 4.7.0 version. Unfortunately, DB connection to Denodo in Knime 4.7.0 seems not working.
We did all the usual steps to enable Denodo access:

  • Upload SSL certificate
  • Set the Denodo driver in Knime preferences as usual.
    This is the error we get:
    “connection error: Cannot trust the server to establish a SSL connection”

Is there anything else we must do / set?
Is there any compatibility issue between the two versions (Knime AP 4.7.0 and Denodo 7.0)?

Thank you very much for you help.
Best regards

2

Hi all.
The issue was related with the certificate. After uploading the correct one, we were able to connect to Denodo.

1 Like
3

Thanks for updating the thread, and including details on the solution.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.