Data Integration Hub (DIH) helps load the data from the source systems to the OFSAA staging tables, through logical interfaces known as Application Data Interfaces (ADI). DIH provides a set of User Interfaces (UI), which are used to define and maintain External Data Descriptors (EDD), Application Data Interfaces, and map the EDDs and ADIs through Connectors. The mappings can be one-to-one, one-to-many, and many-to-many.
The source systems that supply data include the core banking systems, rating systems, modeling systems, and so on. In the absence of DIH, the data from the source systems are extracted, transformed, and loaded (ETL process) to the physical tables in Oracle Data Integrator (ODI). With DIH, the ETL activity is not replaced; but DIH serves as an abstract, logical layer to the physical tables in Oracle Data Integrator (ODI).
Oracle Financial Services Analytical Applications (OFSAA) enables financial institutions to measure and meet risk-adjusted performance objectives, cultivate a risk management culture, lower the costs of compliance and regulation, and improve customer insight.
Oracle FLEXCUBE Universal Banking (FCUBS) supports the changing landscape of retail, corporate, and investment banking requirements with strong transaction banking and Islamic banking capabilities.
The current FCUBS-OFSAA interfaces transfer all key data elements across various modules within FCUBS to OFSAA Common Staging Area (CSA).
The integration between Oracle FCUBS and OFSAA enables financial institutions to:
· Get insight into customer patterns based on the data captured in core banking.
· Achieve end-to-end improvement in business delivery.
· Achieve effective performance and risk-free management using the available customer data.
This integration is achieved by handing off FCUBS core banking data with OFSAA through the FLEXCUBE Information Server (FIS) and DIH.
NOTE |
FCUBS versions 14.3.0.0 and 14.4.0.0 are supported. |
Figure 1: OFS FCUBS Data Flow
Procedures which are packaged within FCUBS populate data from various tables in FCUBS to several landing area tables after execution. Essentially a one-to-one mapping is done between the landing area table (EDD) and OFSAA staging area table (ADI). Most of the calculations and transformations are done within these extraction routines. The DIH connector pulls data from the landing tables and populates the same in the staging area tables.