Denodo

Supported Data warehouses & lakehouses

Catalog Denodo virtual databases, base views and derived views through the Denodo VDP JDBC driver.

Capabilities

CapabilitySupportNotes
Tables, views & columns Supported
Keys, constraints & indexes Not available
Procedures & functions Not available
Data lineage Partial View definitions (VQL) can be extracted with the GET_VIEWS and DESC VQL VIEW commands.
Lineage from query history Not available
Business glossary links Supported
Data quality probes Supported
Data profiling Supported
Data classification Supported
Chat with your data Supported

Connection settings

Create the connection on the Blindata Agent from Settings > Agents > Connections with the connection wizard, choosing JDBC (generic) in the technology step.

Driver classcom.denodo.vdp.jdbc.Driver
JDBC URLjdbc:denodo://localhost:9999/<database>
Authentication
Service principal (shared technical user)
User principal (personal credentials, BYOC)
Ephemeral credentials (asked at each run)
Crawling strategyJDBC or SQL

The Blindata Agent does not include this driver: download the vendor JDBC driver and copy the .jar into the agent drivers folder, as described in Add JDBC drivers. Driver properties can be added under Advanced settings in the connection wizard.

Prerequisites & permissions

  • A Blindata Agent installed with network access to Denodo.
  • The vendor JDBC driver installed on the agent (see Add JDBC drivers).
  • A user with CONNECT and METADATA privileges on the virtual databases to document.

Set up metadata crawling

  1. Create the connection to Denodo on the agent (see Connection settings) and use Test to verify it.
  2. Create or open the system that represents Denodo in the catalog and link it to the connection.
  3. In the CRAWLING tab add a crawling job with strategy JDBC or SQL.
  4. Run a TEST to check the number of extracted objects, then RUN or schedule the job.

The job options and the column aliases of every extraction query are described in the Generic JDBC reference.