The Legacy Enterprise Data Warehouse that was moved into the Cloud
How difficult could it be? Taking your corporate data warehouse (DWH) into the cloud should be as easy as doing a copy-paste: upload the data, store it safely on a modern platform and enjoy limitless space and computing power... Or so you thought ... And then there is the real world, the legacy world: hundreds of connected components, thousands of data flows linking long-forgotten data hubs with your DWH, processes nobody cared to maintain over years but still vital to daily business... Moving the legacy DWH into the cloud then becomes a big beast: it goes deep into the DWH infrastructure covering software stacks and application architectures which do everything from loading data to consuming it on servers and user clients. And there they are, the users: querying data, analyzing it, creating their own processes; in another place this is called data-driven, in our context it is called a nightmare. Because users need to be able to work before and after a cloud migration: they work from any geographical location, they use different platforms, software, they need data all the time... And so your project of moving the data warehouse into the cloud takes shape:
Starting with platforms and solution architecture, followed by network and connectivity, business processes and users, and the DWH cloud platform.
The most important thing for such a project is not to despair and accept the challenge; especially when it comes with a short timeline... In
Vodafone Germany we completed a full DWH migration, uplifting servers, upgrading software, re-establishing connectivity, maintaining and testing applications, migrating the
Teradata database in only twelve months from project start to delivery. I am still in disbelief when I write this...
That kind of success was only possible through the hard work of many professionals who took up the challenge and did not cease to believe that they would be able to deliver a tight sequence of milestones - ultimately leading to a smooth DWH migration. Congratulations and thank you to everyone involved, just to name a few:
The Teradata database experts: Markus Linde, Guido Winzig,
Udo Weinkoetz,
Christoph Sassenrath, Jo-Anne S.,
Roger Stumpf,
Neil Corin,
Horst Höck...
The networking specialists:
Daniel Zirpoli,
Cezar Marson,
Akansha Salve,
Stefanos Moukarikas,
Nicolas Issid...
The infrastructure experts:
Lijo Thomas,
Ami Tiwari,
Andre Rodewald,
Heiko Gruner...
The application experts: Ganesh Gawade, Michael Vogt,
Stefan Kröckel,
Harsh Saxena,
Ullhas Bhave...
The testing specialists: Pavan Agrawal,
Prof. Dr. Theo Almeida Murphy,
Mandar Malekar
The security team:
Moises Margotto, CISSP, CCSP, CISA, CRISC,
William Follows, Timothy Masila
The business team:
Sven Grote-Beverborg, Rafael N.,
Linda Hollmann
The facilitators:
Vitor Bacalhau,
Deepa Dandegaonkar,
Ramy Saad,
Thorsten Heintke,
Dr. Peter Lezovic,
Tanveer Rabbani, Prasansa Chand
...and everyone else!