Full Data Migration
Architecture, Code Migration & Governance
- Business problem
- Migrating a live 50TB production DWH with complex transformations
- What BBI changed
- Defined and implemented the target Netezza database architecture
- Strongest supported result
- 50TB MigratedImplementation scope
Results
- 50TB MigratedImplementation scope
- 450+ Scripts MovedImplementation scope
- Redesigned ETLStated outcome
- Governed MigrationStated outcome
01Context
Etisalat UAE is a prominent multinational telecom company operating across 15 countries and serving over 167 million customers worldwide. Etisalat needed to migrate its production data warehouse from Teradata to IBM Netezza to resolve performance issues and meet current business needs.
02Challenge
Before
- 01Migrating a live 50TB production DWH with complex transformations
- 02low performance and poor data quality
- 03150 million daily records
- 04outdated ETL with no metadata management
After, as stated
- 50TB Migrated
- 450+ Scripts Moved
- Redesigned ETL
- Governed Migration
03What BBI delivered
Architecture, Code Migration & Governance
Database Architecture
Defined and implemented the target Netezza database architecture
Security Matrix
Designed and applied a security matrix for the migrated environment
Script Migration
Migrated 450+ BTEQ scripts and 60+ stored procedures to Netezza
ETL Redesign
Redesigned ETL processes for full compatibility and performance on Netezza
Live 50TB Migration
Moved the live production DWH while handling 150M daily records
Migration Governance
Established best practices for data migration and governance
04Outcomes
Implementation scope
What was implemented, and at what scale. Not a measure of business impact.
- 50TB Migrated
- 450+ Scripts Moved
Stated outcome
Listed as an outcome in the case study, without a figure.
- Redesigned ETL
- Governed Migration
05Technology & capabilities
Technology named in the case study
Capabilities
Numbers show how many of the 50 stories share each item.
Source notes
- BBI Company Profile 2025 — case studies, slide 21. The deck classifies this story under “Telecommunications” and lists its location as “UAE”.
- Outcome labels are quoted from the case study. Their grouping (impact, scope, delivery, stated) is editorial.
- The animation at the top of the page is an illustration, not a diagram of the client's systems.
→Contact BBI
Talk to BBI about your data and AI goals.
- info@bbi.ai
- Phone
- +971 4 2969 941
- Head office
- Office no 8 C6, I-Rise Tower, Barsha Heights, P.O. Box 119160, Dubai, UAE
