Driving complex DWH changes by ODI metadata

On January 1st, 2023, Euro became the official currency in the Republic of Croatia. The process of introducing Euro is one of the most demanding projects that banks in Croatia have ever faced. At Zagrebačka banka, we worked intensively on preparations and system upgrades throughout 2022 to make the transition to Euro as easy and simple as possible for our clients. Numerous IT system changes and timely and accurate data integration in the Data Warehouse (DWH) were the main guarantors of the success of the entire project.The main challenges we faced were insight into the connection between DWH processes and determining the schedule of production changes among different teams, and detection of semantic, structural and data changes in the application layer (core).Each of the changes generated the need to implement many adjustments to dependent ETL processes (Oracle Data Integrator - ODI) and associated base objects. Where to start from? How to coordinate? Is it possible to plan anything? How to deal with it? How to stay kind while being blind at the same time?Listen to our challenges, recognize yourself in them. We will show you the approach we used to resist all the demands. The basis of all solutions was ODI metadata. It provided us with incredible power and practicality in managing complex processes, giving us such essential insight into the amount and comprehensiveness of the necessary adjustments to the DWH system.