Denodo¶

Dataiku has support for interacting with Denodo:

Warning

Tier 2 support: Connection to Denodo is covered by Tier 2 support

Setting up¶

Dataiku support for Denodo leverages the JDBC driver. You can download the driver from Denodo’s site: https://community.denodo.com/drivers/jdbc/9

Put the driver in a subfolder of your lib/jdbc driver, such as lib/jdbc/denodo

In Dataiku, create an “Denodo” connection

Host is the IP or hostname of the Denodo server
Port is the port of the Virtual Dataport (usually 9999)
Database is a database on the Denodo server you use to connect to the server. You can access other databases in the Virtual Dataport once connected, user permissions permitting.
Set Auth type to “User/Password” and fill the User and Password fields (OAuth2 is also possible)
For Drivers jars directory, use lib/jdbc/denodo (or another folder that you may have selected)

You can import tables using the usual Connection Explorer.

The Schema in DSS’ database explorer, and in the dataset’s settings, maps to the “database” objects in Denodo.