Unsupported Screen Size: The viewport size is too small for the theme to render properly.
Published by Collibra Marketplace

DGC Query Tool

Package Documentation
Free

Overview

The DGC Query Tool wraps the Collibra platform Core REST API to provide a simple REST interface for querying and exporting content from Collibra applications. The format of the response is JSON. This accelerator can be used as a standalone project, or in combination with a wrapper service/project. For example, let’s say you need to integrate Collibra platform with a reporting system:

  • If the reporting system can perform REST calls and consume a JSON response, it may be able to directly utilize the dgc-export exposed services to perform queries such as:
    • find all assets created since {yourTimestamp}
    • find all Business Terms with a status of Approved but with a missing(null) Definition value
    • find all assets within a given domain or community with an asset name containing the word “customer”
    • and much more….
  • If the reporting system can not perform REST calls or consume a JSON response, then you create a separate “wrapper” project that calls dgc-export to perform queries like the ones above. Your wrapper project can then transform the JSON response to whichever format (i.e. XML, CSV, fixed width, etc…) can be consumed by the reporting system.
    • The dgc-export-samples project is an example of this approach, and contains a few sample flows that transform the JSON response as needed.

Media

More details

Release Notes
  • JDK 8+ now required
  • Performance improvements, code refactoring
  • Tested on Collibra Platform 5.7 and 1.6
  • Fixes:
  • users in groups assigned to roles are now correctly returned
  • corrected issue with missing commas in RAML file
  • corrected filter condition with missing closing bracket
  • Added VM endpoint ‘dgc_export.asset-map’ which returns an asset response as a Map object, skipping the transformation to JSON
Compatibility
  • Collibra Platform 5.7 and newer
Dependency
  • Collibra Platform Connector 1.4.1
  • Collibra Domain 1.1
  • Java Runtime Environment 8
License and Usage Requirements
  • Collibra Connect

Release History

Version 0.5
August 15, 2017
Release Notes
  • DGC v5.1 compatibility (not backwards compatible)
    • See RAML file for updated response structures to be used going foward.
    • Use of HTTP connector to export metamodel content using DGC’s REST APIv2 ( required due to deprecation of some APIv1 resources starting in DGC v5.1)
  • Introduction of Complex Relations by Context services (i.e. Export all the Field Mappings associated to a given Column)
  • The samples project (dgc-export-samples) updated to reference modified VM endpoints, and new asset response structure
  • Community service – fixed issue of parent community returned with empty fields when a community does not have a parent. Null is now returned instead.
  • Renamed file and flow names
Compatibility
  • Collibra Platform 5.1
Dependency
  • Collibra Connector 1.4.1
  • Collibra Domain 1.1
License and Usage Requirements
  • Collibra Connect
Version 0.4
July 10, 2017
Release Notes
  • Fixed issue with null fields returned for children arrays in community and metamodel/asset_types services
  • Added mappings.lastSyncDate & mappings.lastSyncAction to asset service (response and as available query parameters)
  • Updated links to community.collibra.com pages
Compatibility
  • Collibra Platform 5.1
Dependency
  • Collibra Connector 1.4.1
  • Collibra Domain 1.1
License and Usage Requirements
  • Collibra Connect
Version 0.3
April 3, 2017
Release Notes
  • Provides DGC v5.0 compatibility
  • Facilitates web application integration.
    • Added the following access control headers to the responses returned by the DGC Query Tool:
      • Access-Control-Allow-Origin = *
      • Access-Control-Allow-Methods = GET
      • Access-Control-Allow-Headers = Authorization
    • This means that if DGC and DGC Query Tool are both using the same protocol scheme i.e. http or https, then it should now be possible for client-side (browser) Javascript code to call the DGC Query Tool services.
Compatibility
  • Collibra Platform 5.1
Dependency
  • Collibra Connector 1.4.1
  • Collibra Domain 1.1
License and Usage Requirements
  • Collibra Connect
Version 0.2
March 8, 2017
Release Notes

Removes maven repository dependencies to avoid issues while importing the application into studio.

Compatibility
  • Collibra Platform 5.1
Dependency
  • Collibra Connector 1.4.1
  • Collibra Domain 1.1
License and Usage Requirements
  • N/A
Version 0.1
December 5, 2016
Release Notes

Initial release.

`List main features:

    • RAML-based API to export assets, domains, communities, etc. from a Collibra DGC environment
    • Ability to export the entire or portions of content from a DGC environment to JSON
Compatibility
  • Collibra Platform 5.1
Dependency
  • Collibra Platform Connector 1.4.1
  • Collibra Domain 1.1
License and Usage Requirements
  • Collibra Connect

Reviews

Rating
Leave a review