Covers all subject areas of banking and enables information storaging that is connected with both the main activities of the bank (finance, CRM) and with the subsidiary subject areas: human resource management (HRM), budgeting and others.

ETL/ELT Data Loading Tools

Combined approach - ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) is used for time data load optimization. 

CS B2 interfaces are offered for banks that use load data as a tool.

It is possible to achieve the maximum download speed, consistency and accuracy of data due to a single vendor of the core banking system - B2 and the data warehouse. Such unity makes possible to obtain new indicators and attributes in storage for the minimum time.

Oracle Data Integrator (ODI) is used for banks that use other core banking systems or for data loading from other sources.

ODI - a software platform developed to meet the challenges of uploading, data transform and load  into the warehouse. One of the main advantages of this tool is an open architecture that allows you to make changes in existing procedures for loading, as well as to add new ones.

Much attention is paid to the process of data updating while making changes in the archive dates in the source systems. Only changed data is loading to the CS:BM system.

Oracle Golden Gate (OGG) running ODI is used for actively changing tables (contracts, applications, documents, transactions).

OGG selects data changes that have occurred since the last load, It enables to determine the delta of the modified data accurately.

Solution Architecture