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

Discover

Scheme invoice forecast

Discover

Billing & Collection

Discover

Profitability & Performance

Discover

Schedule demo

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

Ask for consultant

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

Get the Brochure

More information about our solutions? Ask our dedicated brochures