ABN AMRO Clearing: Financial Systems on EDB Postgres
ABN AMRO Clearing is a recognized global leader in derivatives and equity clearing and one of the few companies that can offer global market access and clearing services on more than 85 of the world’s financial exchanges. The company operates from 12 locations worldwide and supports more than 16 million trades per day.
Reducing operating costs while ensuring functionality, security and availability are key challenges for organizations today and ABN AMRO Clearing is no exception. To reduce costs, the company instituted a global policy to use open source solutions wherever it’s feasible. The freedom from vendor lock-in that comes from using open source was attractive too. The company builds many of its applications in-house.
High costs and vendor lock-in prompted the infrastructure architects to consider alternatives for the database. That led the team to open source-based EDB Postgres™ Advanced Server from EnterpriseDB® (EDB™) and a relationship that has expanded in recent years along with the EDB Postgres footprint at ABN AMRO.
Open Source-Based Solution
In 2006, as open source software emerged as a priority for the company, ABN AMRO Clearing started using the open source version of PostgreSQL for two applications. One of the applications was a global reporting portal, used to store clearing transaction data and compiling reports for customers, ABN AMRO departments and regulators. The database grew at an aggressive rate.
The growth, and geographic reach, of this application is an example of how applications running on PostgreSQL became more important. And as a result, the company began planning a transition from the open source database to EDB Postgres Advanced Server from EDB. EDB extends open source PostgreSQL with enterprise-class performance, security and manageability enhancements. The team did the migration in 2011 during a hardware upgrade.
“In order to provide our clients with quality and in-time service delivery, it is crucial for us that we ensure high availability and continuity for our applications,” said Pieter Van Tol, European Chief Technology Officer of ABN AMRO Clearing Bank’s London Branch. “Our applications have a 99.97% high availability requirement. Continuing to work with the community version of Postgres without the proper support model was not an option. In addition, there are things EDB Postgres offered that aren’t available in the community version, such as monitoring, tooling and compatibility for Oracle.”
Expansion of EDB Postgres
ABN AMRO Clearing has continued to expand the EDB Postgres footprint in the organization. The team ported a transactional trade capture system from the community PostgreSQL to EDB Postgres in 2013. The application was part of legacy infrastructure installed in the 1990s and had been targeted for modernization.
“As part of the European data center consolidation project we decided to immediately make use of the opportunity to migrate our reporting application to EDB Postgres,” said Mike Van Doorne, ABN AMRO Clearing’s European Technology Architect. “This migration forced us to build a solid new database platform based on EDB Postgres, which accelerated the use of EDB Postgres by other applications as well.”
As of April 2015, ABN AMRO was using EDB Postgres to facilitate between six and 10 million transactions a day. The team was also performing a Proof-of-Concept for a new mission-critical risk assessment/risk calculation application to be powered by EDB Postgres. The company was further planning a new a client query portal to be deployed on an all-flash array for high-performance and powered by EDB Postgres.
“This is an example of the evolution of EDB Postgres into our environment,” said Van Tol. “We’re expanding our EDB Postgres footprint and increasingly looking for ways to use it for our more highly business-critical systems.”