Skip to main content

About the Denodo collector

Use this collector to harvest metadata for Denodo tables and columns across the enterprise systems and make it searchable and discoverable in data.world.

Note

The latest version of the Collector is 2.158. To view the release notes for this version and all previous versions, please go here.

What is cataloged

The collector catalogs the following information.

Table 1.

Object

Information cataloged

Columns

Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, Foreign), Column size, Column index

Table

Name, Description, Primary key, Schema

Views

Name, description, SQL definition

Schema

Identifier

Database

Type, Name, Identifier, Server, Port, Environment, JDBC URL



Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 1.

Resource page

Relationship

Table

Columns

Columns

Table



Lineage for Denodo

  • The collector queries Denodo’s built-in VIEW_DEPENDENCIES() function to find the tables from which each view selects data. It harvests a lineage relationship between the view and each of these dependent tables.

Denodo versions supported

  • The collector supports Virtual DataPort version 7.020200310 or 7.020200803

Authentication supported

  • The collector supports basic authentication to Denodo.