Denodo: JDBC Driver Setup

This document provides the basic information for setting up a tool agnostic JDBC connection to Denodo.

Summary and Requirements

This document provides the basic information for setting up a tool agnostic JDBC connection to Denodo.

Must be connected to VPN or Campus Network
Must have administrative rights to computer (or have helpdesk do the setup)
Note: JDBC driver is compatible with Java 8 (JDBC 4.2) and above

1. Download Driver

Download the most recent Windows driver from https://community.denodo.com/drivers/jdbc/

Save the .jar file in a known location that is easy for you to locate, for example:

Windows: C:\DenodoDrivers\
MacOS: ~/DenodoDrivers/
Linux: /opt/denodo/drivers/

First time users will need to create a free Denodo Community account

Use your “@wisc.edu” email address when signing up (not “@doit.wisc.edu, etc.) to qualify for free Community content

In addition to allowing you to download the JDBC drivers, your Community account will get you access to a great deal of additional training materials and free self-paced learning tracks on community.denodo.com

2. Ensure Java is Installed

The JDBC driver requires that Java is installed.

Windows: Java version 8 or later needs to be installed. Verify by opening a command prompt and enter
```
java -version
```
If the version is not current, download and install a current version.
.
MacOS: Java can be installed using Homebrew. Enter
```
brew install openjdk@11
```
Linux: Java can be installed using terminal. Enter
```
sudo apt install openjdk-11-jdk
```

3. Add JDBC Driver To Your Application

Option 1. Connection through driver properties.

In the connection configuration, enter the following:

1. Driver class name: com.denodo.vdp.jdbc.Driver
2. Host: connect.data.wisc.edu
3. Database / Schema: semantic
4. Port: 9999
5. Username: your_net_id@wisc.edu
6. Password: your_net_id_password

Option 2: Connection through JDBC URL

Use the following connection URL to connect to Denodo:

jdbc:denodo://connect.data.wisc.edu:9999/semantic?ssl=true&user=YourNetID@wisc.edu&password=YourNetIDPassword

Denodo Vendor Documentation

Denodo - Using Data Catalog Tools Denodo - Connect Tableau Desktop to Denodo

Denodo - Connect to Data Catalog

Denodo - Using Data Catalog Tools

Need More Information?

If you have questions about this document, please contact Data, Academic Planning and Institutional Research (DAPIR, https://data.wisc.edu/) at badgerdata@wisc.edu