Customer Use Case

"Pentaho allows our clients to accurately satisfy their information needs in an interactive way."

Laura Hendriks, Project Manager, ABN AMRO Clearing

ABN AMRO Clearing

An integrated approach to global transaction processing, financial logistics and risk management, processing over 10 million trades per day

Business Challenges

  • Need to offer a state of the art web application that gives access to trades, positions, cash movements and other information
  • Embed both standardized and custom-made queries, as well as provide real-time and web-based data access to meet customer needs
  • Integrated position administration and risk monitoring while minimizing total cost of ownership

Pentaho Solution

  • Pentaho Data Integration to extract, transform and load data from ABN AMRO Clearings’s Global Execution Services (GES) infrastructure, including: cleared trades, positions, margin amounts and settlement of derivatives and securities
  • Embedded Pentaho Business Analytics Server with C-Tools, leveraging a PostgreSQL database loaded by EAI-tool (Enterprise Application Integration) via web methods

Value Added

  • Improved customers satisfaction due to a major improvement of time to market for new queries, dashboards and reports
  • ETLs can be “dynamically clustered” enabling dynamic pooling of computer resources, reducing process time and improving data governance
  • Forecasted an annual 60% cost reduction of running and maintaining ABN AMRO Clearing’s readables (standardized reports)
  • Recognized for Honorable Mention in the 2014 Pentaho Excellence Awards 

Why Pentaho

  • Highly flexible and customizable solution that meets customer needs
  • Ability to scale and provide data integrity and security
  • Fast time to market with Pentaho Services and Consulting