Unsupported Screen Size: The viewport size is too small for the theme to render properly.
Collibra Marketplace
Current Version
1.3.0
Target Industries
Any Industry
Who can set it up
Target Business Function
Any Business Function
Published by
Collibra Marketplace
Latest Release Date
February 22, 2019
Initial Release Date
September 20, 2018

Denodo Metadata and View Lineage Integration

Download Documentation

Overview

This application is designed to retrieve, map and ingest metadata from a Denodo instance into Collibra DGC using the Collibra DGC Connector. To achieve this we need to transform the inbound source Databases, Views and Columns from Denodo into objects that the Collibra Data Dictionary will recognise.

The Denodo Integration serves the following use cases (among others):

  • Increase trust and data citizen engagement around data streams that pass through, are collected by or are produced in Denodo.
  • Enhanced data lineage diagrams, data dictionaries and business glossaries. In many cases data is captured, transformed and sourced from Denodo with little documentation.
  • The data centre can track changes in Denodo metadata in order to plan and engage with relevant business process owners accordingly.

 

More details

Release Notes

Changes:

  • Fixed Column Lineage when column name contains comma character in its name
  • Replaced Complex Relation Listener calls by direct HTTP Rest calls to DGC.
  • Removed use of Collibra Domain.
  • Minor fixes in View Lineage
  • Modified metamodel to include Private Views
  • Removed Column Lineage
Dependencies
  • Collibra DGC 5.3.2
  • Collibra DGC connector 1.4.1
  • Java Runtime Environment 1.8
  • Mule ESB 3.8.5
  • Anypoint Studio 6.4.4
License Requirements
  • Collibra Catalog or Data Dictionary
  • Collibra Connect
  • Denodo 6.0
Version 1.2.0 December 4, 2018
Release Notes

Changes:

  • Modified integration to make use of Collibra Domain project.
  • Modified relationships between Denodo Views to be Complex Relations with dependency type information.
  • Added use of the Complex Relation Listener to upsert the complex relations between Denodo Views.
  • Solved bug about filtering out Denodo internal Views.
  • Solved bug about filtering out relationships between Denodo Views and Stored procedures.
Dependencies
  • Collibra DGC 5.3.2
  • Collibra DGC connector 1.4.1
  • Complex Relation Listener 1.0.0
  • Sync Job Status 1.0.2
  • Collibra Domain 1.1.0
  • Java Runtime Environment 1.8
  • Mule ESB 3.8.5
  • Anypoint Studio 6.4.4
License Requirements
  • Collibra Catalog or Data Dictionary
  • Collibra Connect
  • Denodo v6.0
Version 1.1.0 November 16, 2018
Release Notes

Changes:

  • Added RESTful endpoint URL to access the views from a browser to Denodo View assets.
  • Added tag with the layer where a view resides to Denodo View assets.

 

Dependencies
  • Collibra DGC 5.3.2
  • Collibra DGC connector 1.4.1
  • Java Runtime Environment 1.8
  • Mule ESB 3.8.5
  • Anypoint Studio 6.4.4

 

License Requirements
  • Collibra Catalog or Data Dictionary
  • Collibra Connect
  • Denodo 6.0

 

Version 1.0.2 November 2, 2018
Release Notes

Changes:

  • Solved bug that returned views for all databases instead of from the one being processed.
  • Solved bug about handling of column dependencies from more than one source column.

 

 

Dependencies
  • Collibra DGC 5.3.2
  • Collibra DGC connector 1.4.1
  • Java Runtime Environment 1.8
  • Mule ESB 3.8.5
  • Anypoint Studio 6.4.4

 

 

License Requirements
  • Collibra Catalog or Data Dictionary
  • Collibra Connect
  • Denodo 6.0

 

 

Version 1.0.1 October 22, 2018
Release Notes
  • Solved bug that returned empty dependencies when there are no read permissions.

 

 

Dependencies
  • Collibra DGC 5.3.2
  • Collibra DGC connector 1.4.1
  • Java Runtime Environment 1.8
  • Mule ESB 3.8.5
  • Anypoint Studio 6.4.4

 

 

License Requirements
  • Collibra Catalog or Data Dictionary
  • Collibra Connect
  • Denodo 6.0

 

 

Version 1.0.0 September 20, 2018
Release Notes

v1.0.0 — Sep 20, 2018

Initial release. List main features:

  • Retrieve metadata from Denodo
  • Upsert metadata to Collibra DGC instance

 

 

 

Dependencies
  • Collibra DGC 5.3.2
  • Collibra DGC connector 1.4.1
  • Java Runtime Environment 1.8
  • Mule ESB 3.8.5
  • Anypoint Studio 6.4.4

 

 

 

 

License Requirements
  • Collibra Catalog or Data Dictionary
  • Collibra Connect
  • Denodo 6.0

 

 

 

 

This item has been published in the Solution Lab section of Collibra Marketplace. You may download and use this item free of charge. However, Collibra does not warranty or provide support for this item. Items in Solution Lab are shared with the wider data citizen community to stimulate the use and implementation of the Collibra platform. Also note that there is no commitment or agreement that the items in this section will be maintained or updated with new versions of the Collibra platform, Collibra Connect or any third party technology.

Check out the #developers channel on datacitizen.slack.com and connect with the community of the Collibra Marketplace developers.

Leave a review

What version of Denodo does it support? Denodo 6.0? Denodo 7.0?

Answer: Hi Laura, please note that we have a #developers slack channel here for all your technical requests. This way you can leverage our growing developers, partners and customers communities.
If you are confronted to a blocking issue, then please raise a ticket here @https://support.collibra.com Thanks