Syngenta’s Search for a Single Source of Truth

Syngenta is a global AgTech company dedicated to helping millions of farmers around the world safely and sustainably grow high-quality food, feed, fiber, and fuel. The company’s 26,000 employees in 100 countries use world-class science to transform how crops are grown and protected. In 2020, Syngenta had $14.3B in global sales and devoted 10% of revenue to R&D.

Syngenta achieved its position as a world leader in agtech through innovation and a succession of successful mergers and acquisitions. The downside of this growth path was a fractured IT environment.

For Syngenta’s data scientist and visualization engineers, the siloed IT environment presented real problems. Like an iceberg, 20% of the company’s data from trials, R&D, and field observations were visible. But ensuring the provenance of this visible tip required navigating the 80% of arcane, siloed data and processes that were obscured from view.

Syngenta’s senior data architect found a reproducible and scalable way to integrate the silos of data with the help of CompilerWorks. Creating a set of data marts on Amazon Redshift, Syngenta assimilated data from 60 different sources, integrating the entire technology, process, and product lifecycle of the Syngenta Group. CompilerWorks Lineage provided transparency enabling data scientists to see where their data originated. Data lineage was presented in a simple, understandable way, giving confidence in the new data source.

The landscape of assimilated data, processed through CompilerWorks, let Syngenta’s data scientists focus on the business meaning of the data in a trusted, agnostic way, providing data observability without ever having to dig into the source.

To read more about how CompilerWorks Lineage helped Syngenta automate data management and gave data scientists confidence in their data, read the expanded Syngenta case study on Information Week.

Cloud Data Warehouse Accelerating Data Engineering and Cloud Transformation at ABN AMRO Bank

ABN-AMRO-Netherlands

ABN AMRO Bank N.V. is the third-largest bank in the Netherlands. Headquartered in Amsterdam, it provides financial services to more than a quarter of the Dutch population. The bank employs 19,000 people and has over $465.8 billion in assets. 

In 2019, ABM AMRO began an IT digital transformation and modernization project to grow the number of teams working in the cloud. The project included migrating a 90TB on-premise appliance-based Teradata enterprise data warehouse (EDW) to Microsoft Azure.

The data warehouse migration from Teradata EDW to Azure Data Factory’s (ADF) platform as a service (PaaS) architecture promised to optimize costs. It was also a hedge against a looming 2021 end-of-support deadline for the Teradata appliance. 

Regulatory Constraints Delay Migration Deadline

The bank identified 62 end-user groups using the Teradata EDW and asked them to re-engineer their workloads on Azure as part of the data platform modernization project. Unfortunately, many of the workloads were over ten years old and involved critical business logic with little, if any, documentation. 

The prospect of rewriting complex code from scratch was daunting. A significant number of the workloads were risk models used by the bank to satisfy data governance regulations such as Basel III/IV, ECB, DCB, AFM, and GDPR. 

Any changes to the highly regulated business logic would require regulators to re-validate the models: a time-consuming process that would delay the cloud transformation project. 

CompilerWorks Slashes Time to Re-Engineer Business Logic

ABM AMRO turned to CompilerWorks for help. Using a combination of CompilerWorks Lineage and Transpiler solutions, the bank’s DevOps teams extracted the business logic used by risk models and recreated the workloads on Azure’s cloud data warehouse. 

An on-screen comparison of the Teradata and Azure datasets demonstrated to regulators that both platforms were using the same business logic, eliminating the need to re-validate the models.

Using CompilerWorks Lineage and Transpiler solutions enabled the bank to condense four years’ development work into one year. Through an automated migration, critical workloads were successfully moved to Azure on schedule, reducing EDW’s total cost of ownership (TCO) by more than 10 million euros ($12 million) per year.

In addition to financial benefits, CompilerWorks brought clarity to ABM AMRO’s re-engineering efforts. IT teams and end-user groups acquired a much deeper understanding of the business logic used in their risk models. Retiring their Teradata EDW on schedule enabled the bank to adopt a modern cloud-based data architecture years earlier than would otherwise have been possible.

Decentralized Data Models and Improved Compliance

For the future, ABN AMRO anticipates providing end-user groups from across the enterprise access to data through a self-service data marketplace. The marketplace will include information such as data quality, ownership, and lineage over time letting data consumers prove internal and external compliance at any point.

The bank also has plans to use CompilerWorks Transpiler to support future cloud database migrations. Transpiler will let users compare translated code in different SQL dialects and perform risk assessments before migrating to a new platform.

ABM AMRO Bank key outcomes:

  • Migrate workflows from Informatica PowerCenter to Azure Data Factory pipeline
  • Slash migration time and enable user groups to meet target completion dates 
  • Enable nearly $12 million per year in IT CAPEX/OPEX savings 
  • Provide upstream and downstream automated lineage transparency 
  • Achieve one-to-one transpilation from Teradata SQL to Azure SQL 
  • Simplify data architecture by identifying unused data and resources 
  • Bring clarity to business logic, streamlining regulatory compliance through automation
  • Save time, reduce cost, and hedge risk for large-scale data pipeline migrations

Find out more about how ABN AMRO Bank uses CompilerWorks Lineage and Transpiler solutions to accelerate cloud transformation, reduce costs, and maintain regulatory compliance. Read the full customer success story here.