Staging Database/Warehouse

The staging database (warehouse) as at the heart of Excenit RSS. It sits as the bridge between all sources of data required to generate returns and the Excenit RSS application, which processes and submits them to the ORASS API.

It is a platform-agnostic RDBMS (e.g., Oracle, MySQL, SQL Server, PostgreSQL) that houses most of the ETL processes and logic for computing and transforming data, etc.

The staging database comprises multiple systems and processes, including:

  1. Header tables — each data element required by ORASS is mapped to a header id

  2. GL mapping lookup tables — each header id is mapped to a table field or a set of GLs

  3. Stored procedures and functions — logic to generate values for each header id

  4. Report (detail) tables — final tables with the data for each return

  5. Source data — all sources of data, including primarily core banking application, HR systems, flat files, data warehouse, etc.

  6. Schedulers — execute stored procedures to load data into staging

  7. DB Links — if necessary create a db link to source data

  8. Validation and upload scripts — if files are received from external sources, monitoring scripts validate and load them into staging.

Staging environment