Jump to content

Need help with Denodo connector


Recommended Posts

I'm getting the below error when trying to connect to Denodo data source from Spotfire

I have also installed the Denodo jdbc driver into Spotfire modules.

Cannot connect to data source 'Avid Stage', due to invalid configuration or that the data source is not running. Database reported: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version.Cannot establish a SSL connection because of problems in the handshake

This is the data source template used

<jdbc-type-settings><type-name>Denodo</type-name><display-name>Denodo</display-name><driver>com.denodo.vdp.jdbc.Driver</driver>   <connection-url-pattern>jdbc:vdb://server:1989/databasename?autoCommit=true</connection-url-pattern> <supports-catalogs>false</supports-catalogs>   <supports-schemas>false</supports-schemas>   <column-alias-pattern>`$$name$$`</column-alias-pattern><column-name-pattern>`$$name$$`</column-name-pattern><table-name-pattern>`$$name$$`</table-name-pattern> <use-ansii-style-outer-join>true</use-ansii-style-outer-join>   <metadata-provider>com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider</metadata-provider> <supports-procedures>true</supports-procedures> <ping-command>Select 1</ping-command>   </jdbc-type-settings>
Link to comment
Share on other sites

Based on the information available, it looks like there are issues with SSL communication to the port that you used in the JDBC connection string (or the port is incorrect), or SSL has not been configured on the Denodo side (Denodo is not SSL enabled yet).

You will need to ensure SSL communication happens without any issues on a given port. You can also verify the connection outside Spotfire from external tools like DBVisualizer installed on the Spotfire server machine using the same JDBC driver.


Setting up DBVisualizer using SSL connection to Denodo:


That will help to know the problematic area.

Link to comment
Share on other sites

I found the issue, Could you please let me know how to modify or add a config into data template as SSLTrustServerCertificate to TRUE?

<jdbc-type-settings><type-name>Denodo</type-name><display-name>Denodo</display-name><driver>com.denodo.vdp.jdbc.Driver</driver> <connection-url-pattern>jdbc:vdb://server:1989/databasename?autoCommit=true</connection-url-pattern> <supports-catalogs>false</supports-catalogs> <supports-schemas>false</supports-schemas> <column-alias-pattern>`$$name$$`</column-alias-pattern><column-name-pattern>`$$name$$`</column-name-pattern><table-name-pattern>`$$name$$`</table-name-pattern> <use-ansii-style-outer-join>true</use-ansii-style-outer-join> <metadata-provider>com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider</metadata-provider> <supports-procedures>true</supports-procedures> <ping-command>Select 1</ping-command> </jdbc-type-settings>
Link to comment
Share on other sites

You can directly add the parameter in the connection string used in the Information Designer while saving the data source.

Please make sure you test it's working outside Spotfire as it's a custom data source.

Ideally, for SQL Server it is added like this in the JDBC connection string:


Article for your reference, https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-with-ssl-encryption?view=sql-server-ver16

For Denodo, I was able to find an article but unsure about its validity. So, would advise you to check with the Denodo DBA about this.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...