You can translate the question and the replies:

Unable to access Denodo from mulesoft using JDBC driver

I'm trying to establish a connection with denodo using JDBC driver to mulesoft which is a maven based application. Mule runtime: 3.8.6 Denodo version: Denodo 7.0 update-20181011 JDBC Jar used: denodo-vdp-jdbcdriver-7.0-update-20181011.jar Maven dependency: <dependency> <groupId>com.denodo</groupId> <artifactId>denodo-vdp-jdbcdriver</artifactId> <version>7.0</version> </dependency> I'm using generic database configuration to establish connection. I'm able to maven install the jar file and add mvn dependency to pom file but when I try to lead driver classes available for denodo, I'm uable to find the right driver class. The classes I see are com.denodo.util.logging But I'm looking for thios class. com.denodo.vdp.jdbc.Driver Please help.
03-03-2020 22:03:50 -0500

3 Answers

Hi, In order to connect to Denodo from Mulesoft using JDBC, you could try to import the JAR file, denodo-vdp-jdbcdriver.jar to the project build path and change the dependency in the pom.xml to **system** scoped dependency or using **file** repository in the pom.xml and refer to the location of the JAR file and then check for the list of classNames imported. Alternatively, you could also follow the below steps for connectiong to Denodo from Mulesoft * Import the denodo-vdp-jdbcdriver.jar to the project build path. * Create a bean object with VDP connection settings and use the Bean as the Data source. * You could then configure JDBC connector by referencing the bean which was previously created. Hope this helps!
Denodo Team
04-03-2020 07:36:35 -0500
Hello I did everything you said but for some reason I was not able to get proper driver class listed when I search for driver class in generic database configuration. It got resolved with anypoint studio restart and reimport of jar file. For others who might stumble on this question I'm listing the steps I followed to connect denodo to mulesoft via JDBC driver. 1) Downloaded Jar file from denodo site. denodo-vdp-jdbcdriver-7.0-update-20181011.jar 2) My mule project is mavenized, So, I had to install drivers using maven install command as follows. Install while you are on the project path on terminal. Make sure the path to denodo jar dile is correct. mvn install:install-file -Dfile=/Documents/denodo-vdp-jdbcdriver-7.0-update-20181011.jar -DgroupId=com.denodo -DartifactId=denodo-vdp-jdbcdriver -Dversion=7.0 -Dpackaging=jar 3) Right click on the project in any point studio and manually add maven dependency to the project. This should add denodo dependency to pom.xml. At this point you should be able to see 'com.denodo.vdp.jdbc.Driver' listed under referenced libraries in the project. 4) Now, I chose to have config file in global.xml. Add generic database configuration and fill in 'com.denodo.vdp.jdbc.Driver' where driver class is required. 5) db url should be in the format jdbc:vdb://denodo-host:port/database?user=test&password=test 6) with proper permissions to the server and right user name and password, you whould be able to connect.
05-03-2020 12:18:31 -0500
Hi, I’m glad that you have found the solution to your required scenario. Alternatively, I was also able to successfully connect to Denodo from Anypoint studio by following the below steps: * In the Global elements, add a generic database connection and in the Required libraries click **configure** and choose **Use local file**. * Choose the driver file path location**denodo-vdp-jdbcdriver.jar** and input the Group ID, Artifact ID, and Version. * Click **install**. * The driver will be installed in the local repository i.e in the directory *${user.home}/.m2/repository*. You could then check the driver installation in the repository following the group id path. * Once done, Input the database connection details and **test connection**. Hope this helps!
Denodo Team
16-03-2020 08:29:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here