Datagaps Integration with Collibra

Collibra + Datagaps for Enhanced Data Quality

Delve into this integration between data governance tool, Collibra and Datagaps DataOps suite- built for data validation in a student information system.

Data Governance and Data Quality

The concept of Data Governance focuses primarily on the observation and governance of the data in terms of models, definitions, dictionaries, lineage, access management, and other observation and cataloging concepts. In contrast, Data Quality is a measure of the condition of the data based on factors such as accuracy, completeness, consistency, reliability, and whether it’s up to date. It focuses on the validation of these dimensions, definitions, models, and dictionaries implying direct checks to quantify data quality using data quality scoring as opposed to cataloging.

One of our higher education customers uses Collibra as their data governance tool and Peoplesoft for their Student Information System(SIS). The data governance team makes use of the workflow capabilities of Collibra to define and manage the data quality rules for their SIS data. However, Collibra does not have any provision to apply these rules on the SIS datasets or tables and compute data quality scores. Collibra does provide a rich set of REST APIs that can be used to read the data quality rule definitions. Datagaps and the higher education customer collaborated together to come up with a solution using Datagaps DataOps Suite to automatically understand the rules defined in Collibra and then create, test, and run these rules on the SIS data. The data quality scores are then posted back to Collibra for reporting.

What are Collibra and Datagaps DataOps Suite?

Collibra is a data catalog platform and tool that helps organizations better understand and manage their data assets. Collibra helps create an inventory of data assets, capture information (metadata) about them, and govern these assets. At its core, this tool is used for helping stakeholders understand what data assets exist, what they are made of, how they are being used, and their regulatory compliance.

There are four major Collibra functional areas:

Data catalog: This catalog supplies an inventory of data assets and allows users to find and discover the right assets to use for different purposes. Users can search across several different sides of the data assets.

Data governance: This helps to create a common understanding and share information about data assets. This includes both technical metadata and user-added information.

Data lineage: Data Lineage allows users to see how data assets are created and molded as they move from one system to another system. This helps data owners track what makes up a data asset for compliance and allows users to see where an asset comes from and how it is shaped.

Data privacy: This module allows privacy and security teams to create, manage and run policies to ensure data privacy and compliance. Policy workflows can be started, and compliance data and reports are captured.

DataOps Suite

Datagaps DataOps Suite is a platform for monitoring Data Quality, Data Reconciliation, and Data Observability. DataOps suite has extensive functionality in terms of monitoring the quality of data at rest (e.g. databases) and data in motion (e.g. files being ingested in a data pipeline). It can reconcile billions of records across systems in a data migration project or a data pipeline. Each aspect of the suite is extendable making it easy to integrate with external systems.

Major Areas in DataOps Validation:

Metadata-Based Validation: One type of validation that data can be put through is in terms of metadata and related relations of data. These refer to datatype, lengths, sizes, order, and such specifics. This makes the foundation of validation as if metadata mismatches are found, entire functions and pipelines will fail. Hence the base component of any validation system.

Rule-Based Validation: Next category is logical and business rules that the values in the datasets should pass through. These come in the form of reference data checks, range-max-min aggregate-type rule-based, duplicate checks, and metrics-based rules. Usually, a Common Data Model, or a governance system is used to ensure that these and metadata-based validations are implemented over different systems and storages are applied correctly.

Trend-Based Validation: On the top of the validation pyramid lies the pattern/trend-based anomaly detection or data observability. Making use of machine learning and statistical methods, the data profile and the metrics trends can be used to identify anomalies in datasets that go through multiple functions and transformations usually either too complex to comprehend or coming from a myriad of sources that don’t have a direct correlation with the final datasets.

Reporting and Collaboration: An area that overarches these validations and analysis systems is the overall reporting and tracking capabilities. The idea is to ensure that anything done via the DataOps suite can be easily reported using the inbuilt reporting module or third-party reporting tools such as Tableau and Power BI.

The Synergy Between Data Governance and Data Quality – Collibra and DataOps Suite in Tandem

In the context of university datasets, Collibra is often used as the final authority to maintain a governed, trusted, shared and reusable set of data (reference and master) in a decentralized environment that houses multiple sources and sinks.

As there are:

  • Specific levels of access required (in terms of teachers, students, data engineers, and such)
  • A constant flux of new data sources and sink with discarding older sources and sinks
  • Policy and Rule Definers at various levels of management
  • BI and Application Developers to manage the flow of the data

While Collibra can define and maintain these specifications, it cannot implement these directly on the datasets to validate the system requires an implementation application, which is where DataOps Suite comes in.

The connectivity system between Collibra and DataOps Suite was REST APIs. Both Collibra and DataOps Suite have inbound and outbound API connections. DataOps dataflow has easy-to-use components for connecting to any REST API and processing the REST API data output.

The basic steps of integration between Collibra and the DataOps suite are as follows:

  • Data dictionary and data quality rules are defined in Collibra by the data analysts and data stewards.
  • Post approval via Collibra’s workflows the data dictionary and data quality rules are pulled into DataOps Suite by calling Collibra’s REST API from DataOps dataflow. A data model with the table definitions and the data quality rules is automatically created.
  • These rules are applied in the model for the applicable datasets in the customer’s SIS system.
  • Once the rules have been applied, the data quality score is calculated with the failure records stored in a cloud-based shared location.
  • The data quality scores and the corresponding failed dataset location are published to Collibra using REST API and DataOps dataflow.
  • The entire flow is automated using DataOps data pipeline and scheduled for execution on a daily basis.

In-App Showcase

These screenshots showcase how this collaboration looks in the DataOps Suite.

Starting with the DataOps Dataflows that pulls data from Collibra, making the data rules, running rules and how outputs are displayed in Collibra.

Data Quality

Automate testing of Business Intelligence applications by making use of the metadata available from the BI tools such as Tableau, OBIEE, and Business Objects.

Synthetic Data

Automate testing of Business Intelligence applications by making use of the metadata available from the BI tools such as Tableau, OBIEE, and Business Objects.

ETL Testing

Automate testing of Business Intelligence applications by making use of the metadata available from the BI tools such as Tableau, OBIEE, and Business Objects.

BI Validation

Automate testing of Business Intelligence applications by making use of the metadata available from the BI tools such as Tableau, OBIEE, and Business Objects.
Products
product_menu_icon01

DataOps Suite

End-to-End Data Testing Automation

product_menu_icon02

ETL Validator

Automate your Data Reconciliation & ETL/ELT testing

product_menu_icon03

BI Validator

Automate functional regression & performance testing of BI reports

product_menu_icon04

DQ Monitor

Monitor quality of data being Ingested or at rest using DQ rules & AI

product_menu_icon05

Test Data Manager

Maintain data privacy by generating realistic synthetic data using AI

About
Free Trail