Case Study
Vodafone Mobile Provider
A major telecommunications provider requiring modernisation of their legacy reporting and data integration infrastructure. Their platform relied on outdated DTS packages, Access databases with no documentation, and legacy Cisco Webview reporting systems that needed migration to current technologies to ensure ongoing support and operational efficiency.
Engagement Summary
The client engaged us to modernise their data integration platform, migrate legacy reporting systems, and reverse engineer undocumented Access databases. Over the course of the engagement, we successfully migrated all legacy components to modern platforms, created comprehensive documentation, and established best practices for ongoing development.
This case study highlights the core workstreams delivered:
- Legacy Integration Platform Migration (DTS to SSIS)
- Reporting Platform Modernisation (Cisco Webview to CUIC/Halo)
- Access Database Reverse Engineering & Migration Programme
Workstream 1: Legacy Integration Platform Migration (DTS to SSIS)
Challenge / Scope
The client's data integration platform relied on legacy DTS packages that were no longer supported and increasingly difficult to maintain. Migration to SSIS required not only technical conversion but also training, standardisation, and the establishment of best practices for ongoing development.
What Was Delivered
- Complete migration of all DTS packages to SSIS
- SSIS training programme for internal teams
- Template design and deployment standards
- Performance tuning and organisation of migrated packages
- Environment documentation and configuration management
- SQL Server build advisory for optimal SSIS deployment
The Outcome
- Successfully migrated all legacy packages to modern, supported platform
- Eliminated technical debt and support risks from DTS
- Improved package performance through organisation
- Established standardised SSIS development practices
- Empowered internal teams through comprehensive training
- Future-proofed data integration infrastructure
Workstream 2: Reporting Platform Modernisation (Cisco Webview to CUIC/Halo)
Challenge / Scope
The organisation needed to migrate custom reports from the legacy Cisco Webview platform to modern Cisco CUIC/Halo reporting tools. This required understanding existing report functionality, recreating reports in the new platform, and ensuring continuity of business reporting capabilities.
What Was Delivered
- Migration of all custom reports from Cisco Webview to Cisco CUIC/Halo
- Report functionality analysis and validation
- Performance organisation of migrated reports
- Documentation of report specifications and dependencies
- Project management and phased delivery approach
- User acceptance testing and validation
The Outcome
- Complete migration to modern, supported reporting platform
- Maintained business continuity throughout migration
- Improved report performance and usability
- Eliminated dependency on legacy Cisco Webview
- Established foundation for future reporting development
Workstream 3: Access Database Reverse Engineering & Migration Programme
Challenge / Scope
The client had 60 Access databases with no documentation, presenting significant operational risk and making maintenance nearly impossible. Understanding the functionality, data flows, and business logic within these databases was essential before planning their migration or modernisation.
What Was Delivered
- Reverse engineering of all 60 third-party Access databases
- Created comprehensive documentation including mind maps
- Developed phased migration approach for Access database consolidation
- Analysis of data flows, business logic, and dependencies
- Scope of works generation for future migration phases
- Risk assessment and prioritization framework
The Outcome
- Complete understanding of previously undocumented Access database estate
- Comprehensive documentation enabling future maintenance and migration
- Clear, phased approach for database modernisation
- Reduced operational risk through improved knowledge management
- Established roadmap for consolidation and platform modernisation
- Mind maps providing visual understanding of complex database relationships
Long-Term Impact
Across all workstreams, the organisation moved from legacy, unsupported, and undocumented systems to modern, well-documented platforms with established best practices, significantly reducing operational risk and improving maintainability.
Technologies & Skills Used
- SQL Server Integration Services (SSIS) (migration, design, organisation)
- DTS (legacy package analysis and conversion)
- Cisco CUIC/Halo (report development and migration)
- Cisco Webview (legacy report analysis)
- Microsoft Access (reverse engineering, analysis)
- SQL Server (build advisory, organisation)
- Documentation (mind mapping, technical specifications)
- Project management (phased delivery, scope definition)
- Performance tuning (SSIS, reporting, database organisation)
- Training and knowledge transfer
Interested in discussing any points raised in this case study?
Contact us today and speak to one of our team who will be happy to assist you with your enquiry.
View All Case Studies
Make an Enquiry