ABN AMRO is one of the largest retail banks in the Netherlands, with more than 5.2 million retail clients and 20,000 employees worldwide, operating in 12 different countries. Its wealth management exceeds €200 billion in assets under management, serving more than 100,000 clients.

ABN AMRO wanted to move its workloads from its legacy system, Teradata, to Azure Synapse Analytics but did not find the conventional approach of code converters appealing. ABN AMRO found that code converters have limitations in converting legacy code with poorly documented business logic. Often, manual intervention to extract, modify, and reinsert the code is required.

A further complication was the nature of the business process served by the application. Several applications served sophisticated risk models that are subject to stringent regulation. These models are certified by a regulatory body, and changes would require a time-intensive certification process before putting them into production.

Finally, the deadlines were tight. The switchover from the legacy system to Azure Synapse Analytics needed to be performed with as little downtime as possible for business analysts and other internal customers. As much as the migration was a technical problem, it was also a formidable challenge in risk management and execution.

Database virtualization leads the way

ABN AMRO turned to Microsoft partner Datometry. Based in San Francisco, California, Datometry specializes in bringing virtualization to the database stack. Its Hyper-Q platform, available in the Azure Marketplace, lets enterprises move from Teradata or Oracle Exadata to Azure Synapse Analytics without headaches.

Before the formal project kickoff, ABN AMRO had a complete blueprint of its workloads through Datometry qInsight. The qInsight report provided the team with a detailed analysis, identifying any potential challenges up-front. Equipped with this knowledge, the bank embarked on the implementation knowing there would be no major surprises.

Instead of modifying applications, ABN AMRO leveraged Datometry Hyper-Q. The Hyper-Q platform translates SQL and API calls in real time. Through Hyper-Q, existing applications work directly with Azure Synapse Analytics. The operation is fully transparent, making changes to application code unnecessary.

Hyper-Q enabled ABN AMRO to operate with a small tactical team. By drawing on strong in-house talent, the bank did not need to augment its staff significantly. Being able to keep the size of the team small was critical to maintain agility, and it also contributed to the overall cost savings.

Liberated from having to rewrite a large body of applications, the ABN AMRO team took the opportunity to selectively adjust a few individual applications. These modifications would play specifically to the strengths of Azure Synapse Analytics.

Meeting deadlines while avoiding downtime

ABN AMRO completed the project on an aggressive timeline. In nine months, the entire workload was migrated off the Teradata system and ABN AMRO was able to decommission its Teradata appliance.

Mike Waas, CEO of Datometry, said, “ABN AMRO just set a record for moving from Teradata to Azure Synapse: In only nine months, they pulled off a full migration that seemed completely impossible. Accomplishing all that, while maintaining full compliance with strict regulations that prevented any changes to the SQL text, is a phenomenal feat.”

After the migration, both the legacy system and the future stack were operated for several months side by side. This enabled business users to validate data and functionality using their original applications.

Finally, when it came time to switch over, ABN AMRO did not schedule explicit downtime. Instead, the company moved its business users to Azure Synapse Analytics, the new core data platform, completely seamlessly.

“With Datometry we have delivered a successful transformation,” said Marcel Kramer, Head of Data Engineering at ABN AMRO. “We moved our mission-critical workloads from Teradata to Azure Synapse seamlessly. With a legacy of more than 15 years of business logic, this is a remarkable result.”

The foundation for a comprehensive cloud strategy

By migrating on a short timeline, ABN AMRO realized considerable savings. The bank was able to decommission its legacy system, avoiding a costly renewal and potentially a refresh of the hardware that would have come due. Leaving the applications intact saved time and effort for rewrites and upheld regulatory requirements. Additionally, it eliminated the undue risk and room for error any modifications would have caused, ensuring the ABN AMRO team was in full control of any risk during the project.

Through Datometry's virtualization, ABN AMRO elegantly solved its migration challenge, and at a fraction of the cost of a conventional migration. Now on Azure Synapse Analytics, ABN AMRO has a strong foundation for the future.