Data Lineage

Ab Initio EME Compliance and Automated End-to-End Data Lineage

CS - End-to-End Data Lineage

A major credit card issuer, acquirer and network service provider company had a requirement to document data lineage for regulatory and financial reporting.

Client Challenges and Requirements

  • Client had an objective to set up end to end data lineage across platforms
  • The client had a 15 year old EME which had approximately 20K applications
  • Majority of the applications were not EME compliant (i.e. were not meeting the pre-requisites of automated data lineage)
  • Lineage documentation was manual

Bitwise Solution

support (5)

Developed a utility which identified the active non-complaint applications to resolve EME error.

checklist (7)

Prioritized cleanup for compliance considering audit requirements.

web (3)

Being an Ab Initio tool, MDH was selected as the right candidate and applied for lineage automation considering its capabilities to integrate with EME and gather data flow.

analysis (20)

Custom reports were built within MDH to extract lineage in source to target format for reporting.

Tools & Technologies We Used

Ab Initio Metadata Hub

Ab Initio Enterprise Meta Environment

AIX/Linux

Oracle JRE 1.6 or higher

Apache Tomcat

Backend DB - Oracle

Key Results
Group 3

Effective Risk Data Aggregation and Risk Reporting

construction-and-tools

Visual representation of data flow

test (4)

Establish a single source of truth that all stakeholders can trust

Share This Case Study

Share on linkedin
Share on twitter
Share on whatsapp
Share on telegram

Download Case Study

    Bitwise provides comprehensive solution for all your data projects

    Related Solution

    Metadata Management & Data Lineage

    Optimize your data assets for high-value return 

     

    Ready to start a conversation?

    Share This Case Study

    Share on linkedin
    Share on twitter
    Share on whatsapp
    Share on telegram

    Download Case Study

    Bitwise provides comprehensive solution for all your data projects

    Related Solution

    Automated ETL Migration

    Risk-free conversion and optimization of source ETL jobs to a target ETL tool with maximum automation

    Ready to start a conversation?