ETL & Data prep

Abraham Lincoln was quoted as saying “ Give me six hours to chop down a tree and I will spend the first four sharpening the ax. ” 

Data prep aims at sharpening the ax. The ETL module qualifies, harmonizes, enriches and normalises all incoming entries before loading target data in the system.

This is a key module although not very visible from an end-user perspective.

Function 1 : Extract

  • Get data from different source
    • API
    • File via FTP
    • External DB (core system, CRM, BI,…)
    • Local file
    • Forms

Function 2 : Transform

  • Perform data enrichment and transformation
    • Data mapping
    • Data enrichment
    • Data qualification
    • Calculation
    • Conditional transformation

Function 3 : Load

  • Load data manually or automatically
  • Automatic load triggered by;
    • Business event
    • Schedule

Server

  • The ETL module is based on Pentaho server edited by Hitachi Vantara encompassing a Tomcat server

Miscellaneous

  • Loaded files are stored in an archive folder for subsequence consultation

Merchant acquirer Case

Discover

ATM acquirer Case

Discover

BIN sponsor Case

Discover

See all modules

Reconciliation & Data matching

Scheme invoice forecast

Billing & Collection

Profitability & Performance

Ask for consultant

Do you need expertise in cards and payment? We will be glad to help

Schedule demo

There is nothing like a demo. Don’t hesitate to contact us and we will be glad to organize a demo shortly

*Mandatory

Get the Brochure

More information about our solutions? Ask our dedicated brochures