Cases of Talend Implementation in Enterprise Projects: Global Experience

Otto Group is one of Europe's most successful e-commerce companies and Germany's biggest online retailer with more than 2.8 million article positions and 6800 clothing brands for the entire family. OTTO processes about 7 million online orders annually and at peak periods it receives up to 10 new orders a second.

The existing IT architecture of the online store consisted of a large Teradata database and many islands of data. The architectural complexity was also due to the fact that some data islands used SQL, some PL/SQL, some were Oracle-based, and some used PERL scripts. So, in order to understand what kind of advertising would be the most effective for clients, the company had to do a lot of data transformation, and the data system needed a single integration tool.
Moreover, the project had a lot of integration scripts, which were very difficult to maintain, because the original developers had already left the Company.

Otto decided to build a completely new data lake and use Talend as a bridge between the new data lake, which stores data from the store website and from partner websites, and the company's 250TB Exasol database.
Talend software also made it possible to use company's own CI/CD process in the development. Talend also allowed OTTO to continuously integrate data sources and continuously develop and deliver new, small upgrades, updates, and applications as well as create test environments for new software launches. All this helped accelerate the process of development and troubleshooting, and allowed the overall reduction of risks associated with new developments and integrations.
So, if a customer wants his or her data to be removed from the OTTO system, the overall process won't take much time, since there is no need for searching several databases. Talend made it possible to communicate quickly with the data sources and simplify the process of deleting the data from Exasol and the Cloudera data lake.

Bayer AG is a German multinational pharmaceutical and life sciences company with more than 150 years of history and a key competence in the field of healthcare in the world.

Bayer carries out continuous research and testing of new drugs to determine their effectiveness and drug safety for further market launch. This requires the accumulation, analysis and storage of huge amounts of clinical findings from patients and volunteers. The data also comes from laboratories and electronic devices. All data is automatically anonymized at the collection point.
The previous information system was outdated and could not cope with the existing load and an ever-growing data flow; some processes were not automated and operations were processed manually, which often led to errors due to human factor.

Instead of managing the old system, Bayer decided to completely change the environment and architecture of the infrastructure. Bayer hosted a "hackathon", when they performed a full-fledged Talend testing and came to the conclusion that it is a perfect solution for continuous system improvement, given its principles of flexibility and the ability to support a microservice architecture.
The Talend ESB bus has been used as a middleware that connects repositories and is not visible to users. The data is transmitted into Oracle's local data lake, and the company connects to the SAS system and uses the Oracle Life Sciences Data Hub to store data on clinical trials of drugs and medicines to perform advanced analytics.
The Talend ESB service bus made it possible to promptly add new functions and in accordance with the current requirements, to improve the quality of received data and to accelerate its processing. Another advantage of Talend use is its ability to track everything that happens with the data, including the data source and the destination.