Skip to content
Tabeth Nkangoh edited this page Oct 18, 2019 · 2 revisions

Overview

How it works

image

The above image summarizes the process: The server that the integration is located on will invoke the integration. That integration calls the HTTP-ODBC middleware server in order to get the rule and profile data. Finally once the integration receives the rule and profile data from the middleware, the integration passes the information along to Collibra via the Import API.

Installation

Please see the installation guide for Windows and Linux.

Functionality Summary

  1. Exporting of Rules from Data Studio and Pandora to Collibra
  2. Exporting of Profile Summaries from Data Studio and Pandora to Collibra.

Rule Information Exported

Specifically, within Collibra the following attributes can be filled in from data exported from Data Studio or Pandora. For more information on the Pandora/Data Studio to Collibra mapping see our documentation.

  • Description
  • Descriptive Example
  • Threshold
  • Loaded Rows
  • Rows Passed
  • Rows Failed
  • Result
  • Passing Fraction
  • Conformity Score
  • Non Conformity Score
  • Last Sync Date
  • Tags

In addition, the following relations in Collibra are created by default:

  • applies to Asset
  • executes Data Quality Rule
  • is classified by Data Quality Dimension

Profile Information Exported

Within Collibra the following attributes will be populated from data exported from Data Studio or Pandora. For more information on the Pandora/Data Studio to Collibra mapping see our documentation.

  • Original Name
  • Data Type
  • Technical Data Type
  • Column Position
  • Is Nullable
  • Mean
  • Standard Deviation
  • Minimum Value
  • Maximum Value
  • Minimum Text Length
  • Maximum Text Length
  • Row Count
  • Number of distinct values
  • Mode