Real-Time Operational Data Store (ODS) for a Nationwide Universal Bank

Data-Driven Business Transformation Focused on Real-Time Reporting Capabilities and Providing a Reliable Application Testing Environment

Bank Pocztowy SA is a commercial bank in Poland, offering financial services for individual customers and micro and small enterprises using the network and facilities of the Polish postal service.

The bank decided to work with Goldenore to solve frequent problems with new application rollouts and system updates, as well as reporting issues.

2 SEC DATA REFRESH

for real-time reporting

NO SILOS

for data is accessible 

IMPROVED CUSTOMER SERVICE

with access to the clients’ products 

Business Perspective

Challenges

  • Information silos with data from SAP were inaccessible to other systems causing incoherent information across applications
  • System updates were causing crashes resulting in downtime because the testing environment didn’t allow full data access due to regulatory requirements (anonymization)​

Benefits

  • Improved customer service quality providing access to the client's products in real-time
  • A fully compliant testing environment with an anonymization layer applied over complete data to produce reliable test results and prevent errors after banking systems updates​
  • Real-time information access with online reports refreshed every 2 sec.​
  • Eliminating information silos with a single Operational Data Store consolidating multiple information sources​

The Architecture

Implementing real-time data replication can solve current business continuity and data access problems, and be a starting point in a journey to an entirely data-driven enterprise.

Whether your business goal is optimizing infrastructure cost or transitioning to a more efficient data mesh architecture based on data fabric solutions, contact us for a free consultation, and let’s discuss different options.

Tech Perspective

Project Goals

  • Implementation of new high-performance infrastructure supporting an advanced ODS system
  • Implementation of dozens of data flows with advanced transformations for the purposes of supplying the ODS (Operational Data Store) system structures Implementation of a solution for data validation and data consistency
  • Minimization of replication delays with transformations necessary for the mobile application
  • Continued monitoring of the replication process for each record with a full analysis of its structure enabled

Outcomes

  • Readiness of ODS layer in real-time ODS database used by electronic banking systems and for reporting purposes
  • Consolidation of data from MS SQL Server and Oracle in one place
  • Online reports refreshed every 2 seconds

Technology Partners

Oracle

Oracle is the company that has created the world’s first – and only – autonomous database that helps to organise and secure client data. Oracle Cloud Infrastructure provides increased efficiency, security and cost savings.

Schedule a Free Consultation

We’d love to learn about your business goals and guide you through optimal technology options.