SDAX-listed company H&R AG has selected Talend, the global big data integration software leader, to replace its legacy system Ascential DataStage (now IBM InfoSphere DataStage). Talend Enterprise for Data Integration is now set to become the central Extract, Transform, Load (ETL) system at H&R. Its IT service provider, HRI ITS GmbH, decided to go with Talend’s leading open source solution following the successful migration of another customer – IGEPA – to the Talend platform.
HRI ITS runs a data center in Berlin for IGEPA and H&R. Both customers deploy the JD Edwards E1 enterprise resource planning system, which is now part of the Oracle portfolio. H&R also uses various supporting applications which feed data into a central business intelligence database. This creates OLAP cubes which are exported with Microstrategy software and converted into reports. These reports provide key decision-making intelligence for company management at H&R. Previously, H&R used Ascential software to extract the data from the operational system, transform it and load it to the BI database.
“The Ascential solution was a good fit for H&R’s needs for many years but was clearly approaching its limits,” explains Jan Grzenkowsky, Senior Application Developer and responsible for ETL at HRI ITS. “The load processes were taking so long that we weren’t even able to load all the data in the available window. Another drawback was the fact that Ascential did not support virtualization.”
The migration to Talend ran extremely smoothly for IGEPA. Initially, HRI ITS assumed it would need one year and two employees to migrate IGEPA’s 440 ETL jobs. In the end, a single employee completed the task in just six months. The load jobs run much faster under Talend and the company is impressed with the quality of support. Inspired by IGEPA’s positive experiences, H&R decided to follow suit. Its requirements are similar but more complex. In addition to JD Edwards E1 and Ascential, H&R uses a number of supporting applications which also need to be integrated. HRI ITS plans to complete the migration in 2014 and has already begun to roll Talend out.