You can translate the question and the replies:

Denodo 7.0 compatibility with vertica 10 version?

Hi Team, We are using Denodo 7 version which is connectinf with vertica 9 version. Now vertica application need to be updated to latest version i.e 10. We are concern about whether denodo 7 supports vertica 10 connectivity. In the default jdbc adapter I can see only vertica 7 and vertica 9 adapters. If denodo supports vertica 10 connectivity from where we can download and where we can upload the vertica adapters. Thanks in advance.
user
17-11-2021 00:57:40 -0500
code

1 Answer

Hi, I would use the Vertica 9 adapter and Vertica 10 JDBC Driver to connect to Vertica 10 from Denodo 7. I would perform the following steps: * Download Vertica 10 JDBC driver from [Vertica website](https://www.vertica.com/download/vertica/client-drivers/). * Copy it to the new folder <DENODO_HOME>/lib-external/jdbc-drivers/vertica - 10. Sometimes a JDBC driver is a set of jars and in that case, you need to copy all of them to this folder. * Then, create a JDBC data source, right-click on a database of the Server Explorer and click *New > Data source > JDBC*. * Choose the database adapter as Vertica 9. * Make the Driver Class path pointing to the above folder. * Provide the database connection and authentication details. * Test Connection. Please note that, currently Vertica 7 and 9 are officially supported by Denodo Platform 7.0. However, as described above, you could still connect to the newer version of DBMS by using its corresponding JDBC driver and the most recent adapter in Denodo. For more information, you could refer to [Supported JDBC Data Sources ](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#supported-jdbc-data-sources) and [JDBC Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-jdbc-sources) sections of the Virtual DataPort Administration Guide. Hope this helps!!
Denodo Team
17-11-2021 07:40:56 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here