Resources Case Study
Enabled consistent availability of enterprise data across locations on an instant basis (~every 7 minutes) to support IFF’s procurement analytics.
IFF is a leading innovator of sensorial experiences with a presence across 162 countries. Their systems relied on data extracts from core system (SAP) for inputs. However, this data was requested at varying intervals of time, causing performance issues in SAP and reporting delays.
There was a need to bridge SAP with downstream applications and make information decision-ready and available in-time. IFF had already invested in Talend, but data transformation challenges remained to be addressed.
Chosen to implement Talend at IFF, Gainlnsights played a key role in designing the ETL process, the data lake architecture and project managing the complete transformation.
A data lake was created to store and manage all their data for current, future needs and to populate data to all downstream applications using Ta lend.
Sources: SAP ECC
Target: AWS Aurora S3