Challenge
Migration from Oracle to Greenplum per Central Bank import substitution requirements
Solution
Data Vault 2.0 on Greenplum, full DWH migration, Central Bank reporting
Project Phases
1
Oracle architecture audit
2
Data Vault 2.0 design on Greenplum
3
ETL pipeline development
4
Data & reporting migration
5
Testing & launch
Results
BEFORE
Oracle-based DWH, high licensing costs, Central Bank non-compliance
AFTER
Greenplum + Data Vault 2.0, 40% TCO reduction, full Central Bank compliance
Technologies
Data Vault 2.0GreenplumOracle DBApache AirFlowGit/GitLab
“TH Consulting team completed the migration in record time — 3 months with zero downtime.”