Real-Time Data Wearhouse for UFG - The Insurance Guarantee Fund

Data-Driven Business Transformation Focused on Real-Time Data Access and Reporting

UFG - Polish Insurance Guarantee Fund - is responsible for compensating injured parties in traffic accidents and collisions caused by uninsured motor vehicle owners and uninsured farmers. It processes millions of transactions country-wide.

They decided to work with Goldenore to enable real-time reporting and data access to insurance providers.

ON-THE-FLY DATA TRANSFORMATION

for reporting purposes

NATIONWIDE ACCESS

to vehicle insurance information

REAL-TIME DATA EXCHANGE

between the authority and insurance providers 

Business Perspective

Challenges

  • Maintaining auto insurance information for all vehicles registered in Poland and making it accessible to all insurance providers
  • Receiving, processing, and reporting on data from all insurance providers ​
  • Collecting and processing information about all Polish residents required to purchase auto and farming insurance​

Benefits

  • Complete and up-to-date information on auto insurance holders is available in real-time to all entitled entities in nationwide
  • Faster (real-time) information transfer between the fund and insurance companies ​
  • Information silos are eliminated by integrating data from multiple sources while maintaining compliance ​

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

  • Supply of infrastructure Oracle Exedata X7-2, Oracle ZFS ZSS-2, Oracle Advanced Support Gateway Servers X6-2
  • Preparation of the environment for the implementation and maintenance of replication using Oracle GoldenGate for the insurance sector
  • Implementation and maintenance of data replication mechanisms between databases using advanced transformations
  • Supply of GoldenGate and Oracle Database EnterpriseEdition licenses, as well as database options with one year technical support

Outcomes

  • The Central Data Warehouse is powered in real-time
  • Data for the expected reporting model is transformed on the fly
  • Various databases and schemes are consolidated in one place
  • Operation bases are relieved from the process of generating reports

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.